Clearing Data in Template before Overwrite

pmelikian

Hello,

I have a workflow that overwrites data within a .xlsx template. The overwrite works fine but I am having issues when the data that was previously there is larger than what it is being overwritten (see example senerio below). Is there a way to clear a data range before it gets overwritten? or possibly fill in the remaining lines with null values?

Example: Say there was 10 lines of data on a template and I run the workflow and overwrite the file with new data that is only 5 lines. I am still seeing 10 lines of data. 5 lines of new data + the bottom 5 from the previous dataset that did not get overwritten. 

Any advice is appreciated here.

thanks

Paul 

Luke_C

@jcboyle82 @pmelikian 

Attached is a sample of how this would work. If you open the yxzp it should make the folders for you and work as expected once you run it. You'll need to tweak the formulas to your needs, but essentially the commands are very straightforward:

1. Copy Syntax: copy 'source file path' 'destination file path'
   1. Note, you can use the * operators, so something like C:\Users\..\Templates\*.xlsx would copy all the xlsx files from that location.
2. Rename Syntax: ren 'original file path and name' 'new file name'

Hope this helps. Also worth noting you could use the 'events' menu in designer to trigger a copy .bat file before the workflow runs, which would need the .bat file to be saved somewhere on your computer. 

TestTemplate2.yxzp