I am using ASPOSE to open a .xlsm file which contains header row. Is there a way to create data table from this .xlsm file excluding the header row?
I am using the following code to open and create data table.
Workbook uploadedWorkBook = new Workbook(FilePath);
TempDt = wsWorSheet.Cells.ExportDataTable(0, 0, wsWorSheet.Cells.MaxRow + 1, wsWorSheet.Cells.MaxColumn + 1);
Now the data table is exported with column names as column 1, column etc…
Can i export the data table with column names as say header 1, Header 2 etc?