Distinguish date and number

[BreGit]

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

TestForDate.xlsx

[Joannis]

Can you provide some sample code here as well?

[GinImor]

Can you provide some sample code here as well?

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

[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.

[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.
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