xlsx-stream-reader icon indicating copy to clipboard operation
xlsx-stream-reader copied to clipboard
verified publisher icon DaSpawn

Datetime can't be parsed properly

Open potatozerg opened this issue 4 years ago • 1 comments

Hi, thanks for the great package!

Problem: The datetime can't be parsed properly.

From: 536365 | 84029E | RED WOOLLY HOTTIE WHITE HEART. | 6 | 12/1/2010 8:26 | 3.39 | 17850 | United Kingdom

To: image

Test file: Online Retail small.xlsx

potatozerg avatar May 14 '21 15:05 potatozerg

Same issue I am also having. You should also give type of value as metadata. Other issue is if there is '21st June' in excel as a date it converts it to string rather than actually converting into date object or above date number

nakad-vii avatar Jul 02 '24 13:07 nakad-vii