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 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.
Please download hotfix 1.6.2. Cell.DateTimeValue is added.