How to do .xlsx predesigned template based output

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

templates output.yxwz

Workflow

Accepted answers

Robin_McIntosh

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

Discussion_templates_output_modified.yxmd

All comments

Robin_McIntosh

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

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

Robin_McIntosh

@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:

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

Discussion_templates_output_modified.yxmd

Kinetic_analytics

appreciate your help.

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235