On keeping formatting with excel

Question

On keeping formatting with excel if I overwrite existing data and use the file format c:	emp\_test.xlsx|||'Data$a:c' and the data has less number of rows than what what there previously in spreadsheet it leaves the previous data...  example say I have 10 rows on sheet and I run the script and it retrieves 5 then from row 6 through 11 is left on sheet with old data.  I'm curious (likely simple) how one uses the formatting string so it keeps column widths and formatting and it overwrites (and clears out) all rows.

Thanks,

Jeff

Luke_C · Accepted Answer

Hi @jeffv

I typically find that maintaining an empty 'template' file works best. The workflow can then be built to make a copy of that template and output the data to it each time. Check out the below thread that has an example of a solution I previous put together.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Clearing-Data-in-Template-before-Overwrite/td-p/738441