//import data from the data table to worksheet
workBook.ImportDataTable(dataTable, //data tabletrue,
//field name as first row0, //row number of the start location
0, //column number of the start location-1, //-1 for all data
rowsdataTable.Columns.Count //column count);