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.
@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.
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?
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.