Append Data to Template then re-save file name with date - Possible?

RCern

Please tell me if this is possible because I can't seem to get this to work.

I have an empty template excel file on my C: drive that only contains Column Headers which are formatted.  I am trying to run a workflow that will take data, append it to the template file (Starting on second row) and then resave the template (with the new data) as a new file with today's date at the end of the file name.  I have attached some screenshots and the workflow but I can't seem to figure out a way of doing this.  Is this even possible?  Any help would be tremendously appreciated! 

2023-05-12_14-48-07.png

Test.yxmd

Template.xlsx

2023-05-12_14-47-37.png

SPetrie

It is possible.

The method I use involves the Blob tools.

You first copy the template file and save it as a new file so your original template remains untouched for future uses.

Then you output your data to the specific ranges you are wanting.

This is an example workflow I built for someone else a while back, but it think it should help you as well.

In this example, I wrote to two ranges in the same sheet of a template excel file that has sum formulas in it.

Template file

Output File

Blob Tools.yxzp