ExportDataTable() problems with timestamps

Iluvatar · March 22, 2005, 5:50am

Hi,

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?

Laurence · March 22, 2005, 6:15pm

Hi Michael,

Have your tried the latest hotfix at

Aspose.Cells for .NET (Download | NuGet)
Aspose.Cells for Java (Download | Maven)

If yes, could you please upload your file here? I will check it ASAP.

Iluvatar · March 23, 2005, 12:50am

Hi Laurence,

thanks for your reply. Yes I’ve tried it with the same effects. I’ve uploaded the sample file here.

Laurence · March 23, 2005, 5:31am

Please download and try v2.9.5 at

Aspose.Cells for .NET (Download | NuGet)
Aspose.Cells for Java (Download | Maven)

Iluvatar · March 23, 2005, 5:49am

Hi Laurence,

thanks, that solved the problem.