Start Free Trial

Alteryx Designer Desktop Discussions

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

Change excel output sheet name

Nuno_Meneses
7 - Meteor

Hello again,

 

I have a template excel file to use as output. I want to keep each sheet in order to keep it formatted but rename sheets dynamically. Also, If possible I'd like to be able to change sheets order.

 

I hope you can help me, thanks

3 REPLIES 3
PhilipMannering
16 - Nebula
16 - Nebula

Happy to be wrong, but I don't think this is possible. Your options are rename the sheets in the template file, or use Python/R/Run Command Tools.

Nuno_Meneses
7 - Meteor

It's a shame but looking from another angle is there anyway I can get a friendlier output? I just need the columns to be adjusted to the size 

PhilipMannering
16 - Nebula
16 - Nebula

The basic Output Data Tool output is a little dry. Have you considered using Table Tool → Render Tool? You can create multiple tabs that way and have formatting options. There are other posts, but here is one of somebody doing that: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Render-tool-multiple-tabs/td-p... 

Labels
Top Solution Authors