nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Exclude objectid field when running excel to table?

RandyMcGregor3

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

Vind meer berichten getagd met

Analysis

Desktop

Accepted answers

Ayan Palit

@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.

All comments

RandyMcGregor3

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.

RandyMcGregor3

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.

TylerT

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

Ayan Palit

@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.

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.