DateTime field wrong timezone.

sestegra / spreadsheet_decoder

Spreadsheet Decoder is a library for decoding spreadsheets for ODS and XLSX files.

MIT License

55 stars 21 forks source link

DateTime field wrong timezone. #40

Open Mmisiek opened 2 years ago

Mmisiek commented 2 years ago

Hi, Thanks for a great plugin! I am loading excel with date/time fields, and I noticed that they are one hour later than they should. Like the wrong timezone is decoded. How it is possible ? Date value in the cell: 5/5/2021 6:38:00 AM is decoded in futter as:2021-05-05T07:38:00.000

sestegra commented 2 years ago

Currently, the package only supports native date/time formats. If you don't use a custom format for date and time, the package will be able to parse them.

As a workaround, select cells with date and format as a date instead of a custom.

See https://github.com/sestegra/spreadsheet_decoder#features-not-yet-supported

sestegra commented 2 years ago

Duplicate #37