How to insert some text rows before export a datatable to an excel file

See more:

MS-Excel

DataTable

export

Hi, I have a method that use Microsoft.Office.Interop.Excel class to export a DataTable to a .xls file. Everything is ok untill I got a request that the excel need to have some text rows before displaying the data in DataTable, such like following:

TITLE OF THE EXCEL

Label1 Param1
Label2 Param2

COLUMNHEADER1 COLUMNHEADER2 COLUMNHEADER3 COLUMNHEADER4
.... .... ...... ......
.... .... ...... ......
.... .... ...... ......

I have tried with DataTable.Merge(...) method but it returned with the COLUMNHEADERS AT THE TOP OF THE EXCEL, like this:


COLUMNHEADER1 COLUMNHEADER2 COLUMNHEADER3 COLUMNHEADER4
TITLE OF THE EXCEL

Label1 Param1
Label2 Param2
.................. .................. ........................ ........................
.................. .................. ........................ ........................
.................. .................. ........................ ........................


Any suggest is appreciated. Thanks in advance.