search

catamphetamine / read-excel-file

Read *.xlsx files in a browser or Node.js. Parse to JSON with a strict schema.
https://catamphetamine.gitlab.io/read-excel-file/
MIT License
301 stars 52 forks source link

unable to parse time properly (00:22:12) . #70

Closed rjdugar closed 4 years ago

rjdugar commented 4 years ago

My excel sheet has value in format hh:mm:ss but while converting it to JSON this value is converted in date format.

I need the value in JSON to be same .

catamphetamine commented 4 years ago

How would you imagine that. If a cell type is date or time, it's converted to date or time automatically. There's no option to disable it in the code.

rjdugar commented 4 years ago

2020-01-30

This is the excel snippet But in case of time, it's not able to convert it. for example -- 00:22:12 is converted to Date object having value -- 1899-12-30T12:42:48.000Z

catamphetamine commented 4 years ago

Provide the file and I can take a look

techie-cloud commented 4 years ago

i have same issue.my time in 12:16 PM and i is parsing it as "1899-12-31T00:16:00.000Z" which on conversion is "4:44:12 AM".

rjdugar commented 4 years ago

i have same issue.my time in 12:16 PM and i is parsing it as "1899-12-31T00:16:00.000Z" which on conversion is "4:44:12 AM".

try -- Xls-json-parser

catamphetamine commented 4 years ago

Closing since no file has been provided.

andreieuganox commented 4 years ago

Still valid