xlsx date type

[Edwin Knuth]

Hello!

I'm working on some code that reads spreadsheets and outputs text.
For xls files I can check the ctype of the cell to determine if it is
a date. However with cells in xlsx files I am getting a unicode
object and can't seem to reference the ctype.

I found some traffic in this group saying that it is difficult to
recognize date formatted cells, but nothing specific. I would
appreciate any guidance the group may have.

Thanks!
Edwin Knuth

[John Machin]

On Jan 21, 6:05 am, Edwin Knuth <ekn...@gmail.com> wrote:
> Hello!
>
> I'm working on some code that reads spreadsheets and outputs text.
> For xls files I can check the ctype of the cell to determine if it is
> a date.  However with cells in xlsx files I am getting a unicode
> object and can't seem to reference the ctype.

Please consider supplying some essential information: what software
are you using to read xlsx files?