Help Needed Reading Spreadshhet Cell that contains illegal datetime value

Aspose.Cells Product Family
1

Hi,

I am working on an app that extracts worksheet data from spreadsheets maintained manually. Some cells that have a Date cell format defined actually contain text data that causes the ExportDataTable method to throw an exception.

I have attached a code snippet and sample spreadsheet. Can you please get me pointed into the right direction.

Thanks,

Doug Kemp

2

Hi ,

If the column contains mixed value type, please use ExportDataTable(DataTable dataTable,int firstRow, int
firstColumn, int totalRows, bool exportColumnName) method.

3

Hi,

Thanks for the hint, I found that the ExportDataTable(DataTable dataTable,int firstRow, int firstColumn, int totalRows, bool exportColumnName, bool skipErrorValue) method to be the best fit.

Regards,

Doug Kemp