Export to Excel Sheet Question

• cvvikram 71819

  SSC Enthusiast

  Points: 178

  More actions

  April 20, 2010 at 4:17 am

  #146589

  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

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  April 20, 2010 at 6:03 am

  #1154481

  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;-)

• cvvikram 71819

  SSC Enthusiast

  Points: 178

  More actions

  April 20, 2010 at 6:53 pm

  #1155041

  Never mind, I have added the additional information required in the header and footer of the worksheet and it is working fine.

  Thanks!