Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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