Using excel2json to convert to JSON - issue with dates

I am trying to use excel2json to convert a .xls file to JSON. The excel file has 3 columns:

Column 1   Column 2   Column 3  1           BOB         1/1/2020  2           SALLY       1/4/2020  

I used:

import excel2json  excel2json.convert_from_file('test.xls')  

It works well for all but the date column. The dates given in the JSON file are random numbers, for example: 43831.0

Where is this coming from? How can I keep the date the same format in JSON?

https://stackoverflow.com/questions/65453341/using-excel2json-to-convert-to-json-issue-with-dates December 26, 2020 at 11:04AM