DateTime Conversion

Aspose.Cells Product Family
1

Hi,

This has partially been discussed in a previous thread, but the solution was not clear to me.

I have a cell that contains a date (with no time component) so using Aspose>Excel how do I convert the date into a C# System.DateTime object?

I’ve tried various combinations of the Convert and Format methods without success, so some help would be great.

Thanks,
Andy

2

Dear Andy,

Thanks for your consideration.

MS Excel saves a date as a number. Currenly Aspose.Excel has not a direct way to convert it.
In next fix, you can get a DateTime object from the Cell.DateTimeValue property.

3

Dear Andy,

Please download hotfix 1.6.2. Cell.DateTimeValue is added.