Hi:
I'm getting error while exporting data into data Table. Please find the attached error screen shot.
Here is the sample code:
public DataTable ExportDataTable(int sheetNumber,int firstRow,byte firstCol,int maxRows,byte maxCols)
{
Worksheet sheet = this.WorkSheet(sheetNumber);
Cells cells = sheet.Cells;
return cells.ExportDataTable(firstRow,firstCol,maxRows,maxCols);
}
and here is the sample excel file :
| Name | ACP 1999-3 |
| XXXXXXXXXX | 29 |
| WWW | 1089 |
| XXXX | 1001 |
| Current XXXXXXXX | 000,000,000 |
| XXXXXXXX | |
| Total XXXXXXX | 000,000,000 |
I'm getting error at reading the name "ACP 1999-3";
Thanks