Naming Tabs in an Excel Doc Using Render Tool

[seisenberg]

HI, 

I have created multiple tables, that I then union to join together and then render into an excel report with multiple tabs. There are 13 tables and each are on a different tab, thus 13 tabs. I would like to be able to name the tabs as they currently output as Sheet1, Sheet2, etc. I have added a formula tool with the name I would like for the tab to each table prior to the union tool. However, in the render, there is no option to choose Sheet Name as the tab name ... any help would be appreciated. Thanks in advance.

[kheuer]

@CharlieS - is there a way to keep all existing Excel sheets intact while rendering a new sheet into the existing file? I want to add a sheet. This solution overwrites everything I currently have. Please advise.

[CharlieS]

@kheuer 

That's only possible when using the standard Output tool and writing to Excel. Rendering formatting content will replace the file.

[kheuer]

Bummer! Thank you anyway.

[DMURPHY]

I'm having the same issue where Render is overwriting the file.  I need to use Render because I'm outputting a map image, and I need to output that map image to a specific cell in an Excel template.  I've tried various ways and no luck.  Is there any possible way to do this?

[CharlieS]

Not with Alteryx alone. Rendering will replace the entire file. The only way would be to Render the file, then use Run Command to call cscript.exe and run a lot of VBA which would be very complex and likely fragile. 

[Uli123]

I havent been able to find a solution which allows you to render a table to a specific excel sheet range, is this possible?

[EricWe]

Hi @Uli123,

Release 2020.1 has an enhancement, when you select a .xlsx or .xlsm Excel file in the Input Data and the Output Data tools, you can now select a range for cells, rows, or columns.

[Uli123]

That's great to know @eric , thanks for confirming! ill be taking a look at that functionality this week.