Reading Date values from cell

[sourav13]

I tried the parsing with sharedStrings and the value of cells directly in case of numbers. Both work fine. But when there is a date in the cell field. It's not returned as String, which I thought it would be. But I get a rather random number 4328 something.

[MaxDesiatov]

Hi @sourav13, thank you for reporting this. Would you be able to attach this file here or to send it to hello@corexlsx.org if you can't share the file publicly? This way it would be significantly easier to reproduce and fix the issue.

[sourav13]

Dates.xlsx

[sourav13]

Hello @MaxDesiatov So have you tested it with above file?

[MaxDesiatov]

Hi @sourav13, these dates are stored in a special "OLE Automation Date" format:

An OLE Automation date is implemented as a floating-point number whose integral component is the number of days before or after midnight, 30 December 1899, and whose fractional component represents the time on that day divided by 24. For example, midnight, 31 December 1899 is represented by 1.0; 6 A.M., 1 January 1900 is represented by 2.25; midnight, 29 December 1899 is represented by -1.0; and 6 A.M., 29 December 1899 is represented by -1.25.

For now you can parse these dates by converting the string to a Double or Decimal value and then converting it to a date using an algorithm described above. CoreXLSX will be able to convert those dates for you automatically in a future version and I'll keep this issue open until then.

[sourav13]

@MaxDesiatov I tried parsing them as strings, If they would have been parsable as strings I would have tried converting them to the desired format but I can't read them as Strings from sharedStrings Model.

[MaxDesiatov]

These cells don't have type "s" which would indicate their value is stored in sharedStrings, it can be accessed directly from the value property instead.

[jcampana]

Hi, waiting for this issue. Any news? Thanks @MaxDesiatov !

[MaxDesiatov]

I apologize for the delay. There's a new dateValue property added on the Cell type in #102, hope this resolves the issue.