topic Re: Append an existing Excel file using model builder in ArcGIS Pro Questions

Append an existing Excel file using model builder

ScottDeNeice — Tue, 22 May 2018 21:06:24 GMT

Hello,

I am trying to create a model that will extract data from a feature data service hosted in AGOL into a fgdb, (using the Download Service tool) and then create a query layer (to insert columns into a new table where there are many case statements like if column a is null use column b (CASE WHEN column a IS NOT NULL THEN column a ELSEcolumn b END AS newcolumn). The last step is to export that data into a formated xlsx file, where the xlsx file has the column names and several other columns have built in expressions to calculate data from columns in the spread sheet. Is it possible to do the last step in model builder. I know I can create a new xlsx file using the Table to Excel tool, but do not see any way to export to an existing xlsx. I am using ArcGIS Pro 2.1.2. My python is limited to exporting a model to a script and make some slight modifications, so not an expert in actually programming with python.

Thanks

Re: Append an existing Excel file using model builder

JoeBorgione — Tue, 22 May 2018 22:33:11 GMT

I believe the only way to add data to an existing workbook is to add a new worksheet with panda....

Re: Append an existing Excel file using model builder

ScottDeNeice — Wed, 23 May 2018 01:24:45 GMT

Thanks. I figured that was the case but was hoping someone knew a way around it.

Re: Append an existing Excel file using model builder

JoeBorgione — Wed, 23 May 2018 01:30:33 GMT

It's really pretty easy to run; see my repsonses to Export multiple tables in GDB to Excel with a new sheet for each table.