Why export data data in excel? Because User wants it in excel. Sometimes I asked myself is there any reason for my work except “satisfying” Users want for excel sheets. From “A1” to final destination ∞. Also, all these sheets should be formatted on right way.
Microsoft didn’t make enough properties for “so loved” Excel Destination in Dataflow Task and I decided to make formatting it on this way:
– create template excel file (saved far away from Users) with Headings and “dummy” row with cell formats
– copy file to desired location and export data into it
Data Flow to Excel Destination will take the format of last used row for every new row. So, data in W3 cell will be italic with percentage format.