Date values from xlsx file didn't convert to string properly

[wotmshuaisi]

default.xlsx

above xlsx file has a date type value 01/09/2019, when i use excel.Read() function to decode the xlsx row to string slice, i got string value 43709

is there any way that i can get data types of each cell?

[szyhf]

I think the fastest way is to set the cell to "text" type, to auto convert the date type to string, may I have a try~

[wotmshuaisi]

the string 43709 representing how many days passed from 1899-12-30.

But I've found the excel is using integer value type as date type from source file, which made it tricky to get the exact type.

set cell type as "text" sounds like an option, thanks in advance!

[szyhf]

I'm read the document of xlsx format, to slove the problem has to parse another config and it has lots of rules, it may take days to try and test.

[wotmshuaisi]

thanks for take look into it!

[szyhf]

I'm not sure when I can finish it, I add it to my todo list, but my job is very busy these days, you may use the fast solution first.

[wotmshuaisi]

I'm not rely on it now, do it anytime you want.