Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Naming Tabs in an Excel Doc Using Render Tool

seisenberg
5 - Atom

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.

17 REPLIES 17
kheuer
8 - Asteroid

@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
17 - Castor
17 - Castor

@kheuer 

 

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

kheuer
8 - Asteroid

Bummer! Thank you anyway.

DMURPHY
6 - Meteoroid

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
17 - Castor
17 - Castor

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
7 - Meteor

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
Alteryx
Alteryx

 

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
7 - Meteor

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

Labels