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