Keep Formatting in Excel Output

[tycarbone]

Hello community,

I am having trouble keeping the formatting when I output to excel. The issue that I am running into is setting the range. This is because my output does not have a specific number of rows that I will be outputting so I can't set the range to say A1:C7. Is there a way where I can keep the formatting of the spreadsheet I am outputting to and only specify the columns that I am outputting to? 

[echuong1 · Accepted solution]

You can set the record limit to be something large. So for example, if I write to A2:E10000000, it will write to columns A-E and only fill in the rows for which it has data.

[Qiu]

@tycarbone 

As @echuong1  had explained, there is an option for this.

Refer this for the sample flow.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Excel-output-to-formatted-sheet/td-p/5...