April 20, 2010 at 4:17 am
Hi Friends,
I need to export the data using the pre created excel template from the Stored procedure. Now My challenge is that, i need to have two level header information. Below is the high level format of the excel template
ABC INFORMATION
COLUMN1NAME|COLUMN2NAME|COLUMN3NAME
I am using the OPENROWSET to achieve this so far when I had only one header. Now when I added the another row above the column name as shown above 'ABC INFORMATION', it is not able to populate the data.
Please help me, how can I fix this issue?
Thanks
April 20, 2010 at 6:03 am
Post your sql query which you are using to export data
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 20, 2010 at 6:53 pm
Never mind, I have added the additional information required in the header and footer of the worksheet and it is working fine.
Thanks!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply