When I use Spire.XLS to read data from an XLSX file, and a particular cell contains a DATE value, the I actually get is an integer like "42,855".
How do I convert that value back into a date?
I understand that the value is supposed to represent the number of days since Jan-1,1900, but the results I get are several days off, like it's not correctly accounting for leap year or something like that.