Alteryx Designer Desktop Discussions

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

Appending data to Excel Template

busybee
7 - Meteor

I possess an Output Template.xlsx. I have a Create Table with Data.yxmd workflow which I used to create Data File.xlsx. I would like to append the 3 columns of data in Data File.xlsx below Output Template.xlsx at Cell A16 and create a new Excel file using Reporting tools. 

 

I have attached the 3 files. Can I get recommendations on how to create the required output? 

4 REPLIES 4
atcodedog05
22 - Nova
22 - Nova

Hi @busybee 

 

Since you have a template file you can directly write to the file. You can configure like below.

 

Workflow:

atcodedog05_0-1627050810727.png

 

1. Write from range. Start A16 and infinite end Z99999 so that it can fit the table.

2. Skip field names.

3. Preserve formatting on overwrite.

4. Output option should be overwrite sheet.

 

Output:

atcodedog05_0-1627050950174.png

 

Hope this helps : )

atcodedog05
22 - Nova
22 - Nova

Hi @busybee 

 

If you want to create a new file each time and keep the original template as it is you can do something like below. This is a method I learnt from @AkimasaKajitani 

 

Workflow:

atcodedog05_0-1627053087181.png

 

You can use a branch with blob tools to read a template file and create a copy of it with a different name. Once you have created the new template file write to it using output tool.

 

busybee
7 - Meteor

The Table tool in my Create Table with Data.yxmd workflow will create background colors and font colors for the data. I cannot output this formatting without Reporting tools. 

 

The updated workflow and the output are attached. 

atcodedog05
22 - Nova
22 - Nova

Hi @busybee 

 

If you are using report tool then you would need to use render tool to output the file. Render tool default and only mode is to overwrite file hence it cannot write range or write to an existing formatted excel file.

 

You can instead apply all these formatting including conditional formatting in the excel file itself and write to it using output tool. The formatting will be applied based on the excel file hence if you have conditional formatting it would format based on value.

 

Hope this helps : )

Labels
Top Solution Authors