Clear historical data from output template file prior to writing new values

Question

I am working on process where I take 2 input files and transform them, (xlsx) summarise the outputs and overwrite to a template file based on the sheet names. I have 3 summaries being output to the same sheet with different ranges eg B4:P38, B39:P73 and B74:P124 using 3 different output tools.

'Overwrite Sheet or Range' does not clear all the historical contents when writing the new values to the output sheets.

Is there a simple way I can clear all of the contents but maintain the format and headers of the template prior to outputting the data?

SPetrie · Answer

This is a generalization of how I handle my templated excel files.

Take a look and see if this helps.

Original Template file example

Example Final Output created with template

TemplateExample.yxzp

LewisThompson16992 · Answer

The only thing I need from the template is the headers they're static. I'm writing a specified range of values to each sheet.

I've seen use of the blob input and output tools but I have no knowledge how to configure them and incorporate it into my workflow.

SPetrie · Answer

Does the template need to be populated with data first?

The easiest method is to keep a clean template in one location, copy it to a holding folder like the temp folder and write your data to that temp file and use another blob to output that file back out.

I can mock up an example workflow to show you what I mean if you are ok with a blank template to begin with.