We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

On keeping formatting with excel

jeffv
8 - Asteroid

On keeping formatting with excel if I overwrite existing data and use the file format c:\temp\_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

 

 

 

 

2 REPLIES 2
Luke_C
17 - Castor
17 - Castor

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-Overw...

 

 

 

jeffv
8 - Asteroid

Thanks... makes sense!

Labels
Top Solution Authors