Loading

issue in exporting data in existing excel without header col

Darshan Bhatt

Hi all,

I am developing a web project in which i have to export data from sql database to an existing excel 2007 file now problem is my excel file is not having any header and top 4-5 rows is occupied with some merged texts so how can i export my datatable to this excel. i also have to export two tables in two different sheets of this excel file.

Please help me to get out of this.

Thanks in advance..

--darshan bhatt

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Neeraj Kumar11y ago
Check this link http://www.c-sharpcorner.com/Blogs/10767/generate-excel-with-multiple-sheet-from-dataset.aspx