Appending data to Excel Template

Question

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?

Create Table With Data.yxmd

Output Template.xlsx

Data File.xlsx

atcodedog05 · Answer

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

busybee · Answer

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.

Create Table With Data(2).yxmd

ExcelFile(2).xlsx

atcodedog05 · Answer

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:

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.

Create Table With Data.yxmd

Data File.xlsx

Output Template New.xlsx

Output Template.xlsx