Select a table to use when calling TableToExcel()

VincentFuller — Wed, 30 Nov 2016 22:57:37 GMT

How can I get the current open table names in ArcGIS to use with the TableToExcel() function? Its not easy to find. This is the current table that is visible when im using the gui.

Thank you,

Re: Select a table to use when calling TableToExcel()

JoshuaBixby — Sat, 11 Dec 2021 16:38:22 GMT

If you only want table tables, and not feature class tables, that are loaded into an ArcGIS Pro project:

aprx = arcpy.mp.ArcGISProject("CURRENT")
table_names = [table.name for map in aprx.listMaps() for table in map.listTables()]‍‍‍‍‍‍‍‍‍‍

Although the code above will create a list of table names, having a list of table names or Table objects still doesn't fully address the issue, at least within the interactive Python window. The interactive Python window in ArcGIS Pro appears to be scoped within Maps so passing the table name from another Map will generate an error. I hadn't run into this issue before, somewhat surprisingly, so I will have to dig into it a bit more.

topic Select a table to use when calling TableToExcel() in ArcGIS Pro Questions

Select a table to use when calling TableToExcel()

Re: Select a table to use when calling TableToExcel()