SSIS - output excel based on template

Question

i have a template like the attached image, first the first row , theses column header are merge cell. (for address and tel header at the first row)

i have prepare the sql to extract the data and fill in excel, for the merge fields, how can i fill to correct position to C3,D3,E3 and F3 and export to excel or csv (which one is better for output?)

output excel template

Answer 1

Hi

First let's load data to excel manager connection with code about the data scope, we may preview as below. And then click the columns, we could edit the column name as you want.

select * from [Sheet1$A2:F3]  

Export to excel or csv depends on your own requirement, both are good.

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.