datetime cell recognize as integer value

[helizhi]

Dear brechtsanders: when using yours projects, the cell value actually is 2013/3/24, but after transferring into csv file , the value becames an integer value "41357"，the project version is xlsxio-0.2.8, are there any solutions?

[brechtsanders]

Hi, Determining the type, especially with date/time formats has proven to be quite difficult. Can you send me an example file so I can investigate? Regards Brecht

[helizhi]

Hi: The source file is: test.xlsx After exectuting xlsxio_xlsx2csv, csv file is generated, the content in csv is: id,name,birth,money1,money2 1,helizhi,42986,20.23,120.23 2,zhoumeiling,41357,25.08,125.08

[brechtsanders]

Dates and times are really stored as (floating point) numbers in Excel. Seeing them as date and time is more like a format thing. That 's why you get numbers when reading the data. However, if you use xlsxioread_sheet_next_cell_datetime() you will get a time_t value, but that's only useful if you know you want to read that cell as a date/time value. Is this of any use to you?

[helizhi]

How can I know whether it is a date/time value or a string value before using xlsxioread_sheet_next_cell_datetime ?

[damian-m-g]

Reporting same need here.

[abcdef123ghi]

hopefully has functionality which could detect the type of cell

[gvollant]

what information can we get about format?

same problem on this other lib https://github.com/troldal/OpenXLSX/issues/104

[damian-m-g]

As this issue is opened from a long time ago, I want to add my 2 cents here and suggest a lib I made some time ago for only reading XLSX. You might get rid of this problem using that if you only want to read XLSX. Cheers.