Alteryx Designer Desktop Discussions

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

How to do .xlsx predesigned template based output

Kinetic_analytics
11 - Bolide

Hello:

Good morning. I want to output the result of the workflow based on a pre-designed template. When I am exporting I see the output but the template is missing. 

I want the solution:

in the.xlsx file, two templates with two different tabs. 

 

appreciate your help.

Thanks

4 REPLIES 4
Robin_McIntosh
11 - Bolide

I personally build the pre-defined template in Excel and save as an .XLSX file if it's something I will use over and over again.  Then use that as my Output file.  You could also add to this a Run Command tool to copy the template file to use as your output so that you always have a clean template.

 

Not sure if this is an option for you or not.

 

Kinetic_analytics
11 - Bolide

Still Could not solve the problem. Looking forward to your help. 

Robin_McIntosh
11 - Bolide

@Kinetic_analytics 

I've modified your workflow here and only modified the first process; the other process is in a disabled container.

I remvoed the blob tools (this is how I do Excel templates).

Reminder that if your template has 5 columns then the output cannot have more than 5 fields.

You will need to update the info as follows for the tools with below annotations:

 

1 - Update info here. Template - You will need to enter the file path of where your Excel template is stored (full path with template file name).
Output File Path - You will need to enter the file path of where you want to save your output (leave off the file name).
Output File Name - You will need to enter the file name you want to save your output to.

 

2 - Update File Formula here. Update the File formula text of SheetNameHere with the sheet name you have in your template.

 

3 - Update the Output for your .bat file. You will need to click on the Output button and then just update the path of where you want to save the .bat file. This .bat file is used in the Run Command tool and simply copies the template and saves. You can rename the file as well if you want. Do not change anything else in the popup window even though it all relates to .csv. After clicking OK, copy the resulting file path/name to the Command under Run External Program.

 

Robin_McIntosh_1-1661864356364.png

 

Kinetic_analytics
11 - Bolide

appreciate your help.

Labels
Top Solution Authors