hh:mm:ss time format seconds not appearing in csv file

Open mikerob-w4 opened this issue 5 years ago • 1 comments

I've been using xlsx2csv for a while but just come across an issue where time in format hh:mm:ss in the xlsx file is being converted as hh:mm so the seconds don't appear in the csv file.

I've tried changing the dateformat parameters but this doesn't seem to address the issue.

2019DukesAveOD.xlsx

Mar 31 '20 20:03 mikerob-w4

Please ignore, I looked through the code and saw there is a timeformat option so I needed to have timeformat = '%H:%M:%S'

Apr 01 '20 08:04 mikerob-w4