topic Re: Table to Excel Script - Multiple workbooks in Geoprocessing Questions

Table to Excel Script - Multiple workbooks

JustinGleeson2 — Tue, 06 Sep 2016 21:28:18 GMT

I am using the Table to Excel Script to export a table from a model. This works nicely for one table. However, the data I am processing within the model comes under a number of different Themes and is stored in separate tables.

Is there a script/tool available that allow multiple tables to be exported to the one excel file in different workbooks?

many thanks

Justin

Re: Table to Excel Script - Multiple workbooks

NeilAyres — Wed, 07 Sep 2016 06:41:35 GMT

From reading the help for Table to Excel, it wouldn't seem to allow you to do this. Only as separate excel files.

You may have to roll your own with python / xlrt.

Re: Table to Excel Script - Multiple workbooks

RebeccaStrauch__GISP — Wed, 07 Sep 2016 14:57:24 GMT

Doing a quick browser search, it looks like there are ways to do this with Python using Pandas. I haven't used Pandas so can't give much advice on that, but I'll tag a few that might know more Dan Patterson‌ Xander Bakker Darren Wiens

But this also looks like a place I would start Combining Data From Multiple Excel Files - Practical Business Python

and a few others from the comment section of that thread and another search on Pandas and Excel

Creating Excel files with Python and XlsxWriter — XlsxWriter Documentation

Working with Python Pandas and XlsxWriter — XlsxWriter Documentation

python - pandas: Writing to an existing excel file (xlsx) using to_excel - Stack Overflow

pandas.DataFrame.to_excel — pandas 0.18.1 documentation

(I could have used something like this to combine file myself last night)

Re: Table to Excel Script - Multiple workbooks

DanPatterson_Retired — Wed, 07 Sep 2016 15:16:18 GMT

If you have Pro installed, the distribution makes installing excel stuff easy, an example given here

/blogs/dan_patterson/2016/07/17/anaconda-spyder-and-arcgis-pro