Is There A Way To Limit Fields in Table to Excel Tool?

PatrickMcKinney1 — Thu, 11 Apr 2019 18:19:34 GMT

I'm updating a custom ArcGIS Tool using ArcMap flavor ArcPy. I have a function that exports any selected features (from a select by location analysis) to an Excel Spreadsheet (using Excel to Table).

Is there a way to limit which fields get exported to Excel? A better experience would be presented to the end users if they only had the fields of interest in the exported Excel files.

And the layers being exported are "Feature Layers," as there are spatial selections being applied to them.

Re: Is There A Way To Limit Fields in Table to Excel Tool?

DanPatterson_Retired — Thu, 11 Apr 2019 19:36:38 GMT

Hide the fields you don't want to be included. Only visible fields get exported

Try setVisible

https://pro.arcgis.com/en/pro-app/arcpy/classes/fieldinfo.htm

Your code would help pinpoint any problems.

topic Is There A Way To Limit Fields in Table to Excel Tool? in Python Questions

Is There A Way To Limit Fields in Table to Excel Tool?

Re: Is There A Way To Limit Fields in Table to Excel Tool?