topic Re: Exclude objectid field when running excel to table? in ArcGIS Pro Questions

Exclude objectid field when running excel to table?

RandyMcGregor3 — Mon, 14 Nov 2022 14:12:45 GMT

I have a script that selects records in a table and exports them as excel files. The fields are very important and the 'objectid' is unwanted. Is there a way to control which fields are output when running 'ExcelToTable'?

Thank you,

Randy McGregor

Re: Exclude objectid field when running excel to table?

AyanPalit — Mon, 14 Nov 2022 16:29:37 GMT

@RandyMcGregor3 I assume you have a geodatabase table that needs to be exported as Excel file.

Add table to ArcGIS Pro and right-click access to Data Design > Fields
Uncheck the visible checkbox for undesired fields and save the table design.
Run the GP 'Table to Excel' and only the visible fields will be included in the export.

Re: Exclude objectid field when running excel to table?

TylerT — Mon, 14 Nov 2022 17:49:13 GMT

The ArcGIS API for Python be well suited to this sort of transformation. Read the feature class into a spatially enabled dataframe, do stuff (filter, etc), then write to excel. Docs at https://developers.arcgis.com/python/.

HTH

Tyler

Re: Exclude objectid field when running excel to table?

RandyMcGregor3 — Tue, 15 Nov 2022 13:44:28 GMT

Thanks, but I'm not quite ready to tackle ArcGIS API for Python. I've dabbled and it looks very powerful. Trying to stick with a out of the box tools (in arcpy) for this one.

Re: Exclude objectid field when running excel to table?

RandyMcGregor3 — Tue, 15 Nov 2022 13:46:30 GMT

The tool converts an excel file to n fgdb table first, then exports multiple excel files from that table. Might work to have it be two step process:

Convert to table
set up fields
run script.

Ok, that's three steps.