Free Support Forum - aspose.com

DateTime Conversion

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

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.

Dear Andy,

Please download hotfix 1.6.2. Cell.DateTimeValue is added.