Excel worksheet.CellsExportDataTable error

Aspose.Cells Product Family
1

Having an excel sheet, where
ExcelSheetContentCellA1Numeric.png (1.3 KB)

A1 → value with all numbers
A2, A3, etc → alphanumeric values
when reading tab using aspose.cell i get this error
ReadExcelSheetWithError.png (34.7 KB)

But, if the first cell A1 is alphanumeric and the rest can be anything, there is no problem

A1 → alphanumeric values
A2, A3, etc → numeric and/or alphanumeric
ExcelSheetContentCellA1AlphaNumeric.png (1.5 KB)

What I can do in order to stop getting error when first cell A1 is numeric and the rest can be anything?

2

@bsotelo,

Thanks for the screenshots and details.

Please note that, for exporting data table, by default, Aspose.Cells evaluates the data type for the values based on the very first (cell) value in the column. So, if the value is number, it means that the data type of the column would be numeric, which is reasonable. If the very first value is number but there are alphanumeric data or values in the column, a string data type should be assigned. To cope with it, please use ExportDataTable overload which involves ExportDataTableOptions and try to set ExportTableOptions.CheckMixedValueType Boolean attribute to “true” if a column has both numeric and string values to escape from error.

In case, you still find any issue or could not handle it, please share your sample Excel file (please zip it prior attaching here) and sample (runnable) code. We will evaluate using your resource file and assist you soon.