@rkoncarevic,
Thanks for the template file, sample code and details.
Well, since your data column F contains mixed value types (number, strings, etc.), so you got this error. Aspose.Cells will generally determine the datatype of a column based on the very first cell value in the column (F2 in your case). Since F2 is numeric value, so it tries to specify the numeric data type for the exported column but the column do have strings also, so you cannot insert strings into numeric data type column and you got the error.
To cope with your issue, you should instantiate ExportTableOptions and set the Boolean attribute “CheckMixedValueType” to true, see the following sample code that works fine:
e.g
Sample code:
Workbook workbook = new Workbook("e:\\test2\\input.xlsx");
Worksheet worksheet = workbook.Worksheets[0];
ExportTableOptions options = new ExportTableOptions();
options.CheckMixedValueType = true; //Since your F column has mixed value, so you should set it true to escape from error.
options.ExportColumnName = true;
DataTable datatable = worksheet.Cells.ExportDataTable(0, 0, worksheet.Cells.MaxRow + 1, worksheet.Cells.MaxColumn + 1, options);
Hope, this helps a bit.
Thank you.