search

PydPiper / pylightxl

A light weight, zero dependency, minimal functionality excel read/writer python library
https://pylightxl.readthedocs.io
MIT License
303 stars 47 forks source link

Read datetime cell #36

Closed VladislavN closed 3 years ago

VladislavN commented 3 years ago

Hi, how i can parse datetime with your library? Снимок экрана от 2021-03-25 19-51-35 Снимок экрана от 2021-03-25 19-51-53

PydPiper commented 3 years ago

Hi Vladislav, thank you for considering using pylightxl. We added datetime handling in v1.54. Please upgrade your pylightxl with pip install pylightxl -U

spaceofmiah commented 2 years ago

datefield

Date field is resulting to float value when read. Initially I felt it was a timestamp, but after conversion from timestamp, I get a wrong date. How do I rightly retrieve the date value from a cell. Below is a code sample of what i'm doing:

shot

pylightxl v1.58
PydPiper commented 2 years ago

@spaceofmiah thank you for letting me know. I took a look and found out that the issue was Microsoft's use of custom styles that are not part of the base xml datetime styles link

I released a new version v1.59 please download the new version for support of the custom datetimes.