Get type of column when reading row?

[kynx]

Thanks for the extension! We've been using it for writing xlsx for a while and it's fast. Now I'm trying to read files and that's fine, except for dates.

These are user-supplied spreadsheets, so I have no way to know the format of the columns up front. That doesn't really matter, except for dates. I've searched the code base to see if there's a way to determine if a particular cell is a date, but can't find anything. Is this possible?

In a perfect world there would be a global setting to get date columns returned as DateTimeImmutable, but not sure if that's even possible.

Many thanks

[xywf221]

You can try EXECL > insertdate

[viest]

The time xlsx file stores floating-point numbers, and currently we do not read the style, so we cannot judge whether it is time by floating-point numbers.

I don’t know if I understand what you mean, if I understand it wrong, please reopen the issue.

[kynx]

Thanks @viest - yeah, thought that might be the case. FWIW it looks like brechtsanders/xlsxio#47 adds information about the cell type, but it's been open since 2019 :(