CoreXLSX icon indicating copy to clipboard operation
CoreXLSX copied to clipboard

Distinguish date and number

Open BreGit opened this issue 3 years ago • 4 comments

I can't distinguish date and number, the type of them are both null, the dateValue of them are both valid value

TestForDate.xlsx

BreGit avatar Dec 05 '22 03:12 BreGit

Can you provide some sample code here as well?

Joannis avatar Jan 15 '23 17:01 Joannis

Can you provide some sample code here as well?

I just use the framework to read the file, nothing fancy here

GinImor avatar Jan 29 '23 13:01 GinImor

I can't read/write chinese, and wouldn't have a clue what a sensible way of parsing this would be. So reproducing code would really be helpful.

Joannis avatar Feb 08 '23 21:02 Joannis

I can't read/write chinese, and wouldn't have a clue what a sensible way of parsing this would be. So reproducing code would really be helpful. the code is clear, use the CoreXLSX to read the file, get string value of a date cell "2022/2/21", the value is supposed to be "2022/2/21", instead, the return value is a number

GinImor avatar Feb 18 '23 02:02 GinImor