I have a problem when importing a excel file with ExportDataTable(). Some of the cells on our worksheet have timestamps in 24h format, such as 20:00:00. When running ExportDataTable() the resulting DataTable contains a string with “08:00”.
Now when trying to convert that value to a DateTime, it is 8 am, isntead of 8 pm.
When I call the DateTimeValue property for that cell, it returns a correct DateTime object with the correct time portion. But StringValue returns “08:00”.
This seems to be a bug! Can somebody please help?
Have your tried the latest hotfix at http://www.aspose.com/Products/Aspose.Excel/Fixes/Aspose.Excel.zip? If yes, could you please upload your file here? I will check it ASAP.
thanks for your reply. Yes I’ve tried it with the same effects. I’ve uploaded the sample file here.
Please download and try v2.9.5 at http://www.aspose.com/Products/Aspose.Excel/Downloads.html.
thanks, that solved the problem.