We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

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