What is the best way to keep the formatting in Excel? I have created a template with the font, column types, graphs, sums etc and removed all the data.
When I export the data into the columns, the formatting is gone, font size is different and the SUM/Graphs does't auto update as I thought it would have.
Is there any easy way around this?
Most of the posts Ive read about this, talks about using a Script Task to do further formatting?