How to export sql table into excel sheet in required format.

Posted by Sathiya_Narayanan under ASP.NET on 8/23/2012 | Points: 10 | Views : 1664 | Status : [Member] | Replies : 2
Hi,

Exporting the sql datas into excel sheet as required format means in excel sheet first two rows should be empty, then in
next row one line text and one line gap then again the tables from next line from should start from second row.
The xl sheet should be produced like this format.
here i attach format of xl sheet.

SATHIYANARAYANAN


Responses

Posted by: Krv on: 11/28/2012 [Member] Starter | Points: 25

Up
0
Down
You can use excel application object to get your requirement done

Check out
http://bytesofcode.hubpages.com/hub/Export-DataSet-and-DataTable-to-Excel-2007-in-C

Thanks,
R.Vasanth
MCTS(SQL Server & BI)
http://bigdatatech.blogspot.com

Sathiya_Narayanan, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Eva2012 on: 11/29/2012 [Member] Starter | Points: 25

Up
0
Down
You can try this: https://exportdata.codeplex.com , but I am not sure it must help you.After exporting to excel, you can add two rows as start rows.

Sathiya_Narayanan, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response