entrouvert
/
debian-python-pyexcel-xls
17
0
Fork 0
Code Issues Pull Requests Releases Activity

Merge pull request #48 from vinraspa/dev 

Update xlsw.py
This commit is contained in:
jaska 2021-09-26 09:47:39 +01:00 committed by GitHub
parent 26b665c137 473ee14be5
commit 23fc6a58fd
No known key found for this signature in database
GPG Key ID: 4AEE18F83AFDEB23
1 changed files with 8 additions and 0 deletions
Show Stats Download Patch File Download Diff File Expand all files Collapse all files

8
pyexcel_xls/xlsw.py
View File

@ -52,6 +52,14 @@ class XLSheetWriter(ISheetWriter):
value = xlrd.xldate.xldate_from_datetime_tuple(tmp_array, 0)
style = XFStyle()
style.num_format_str = DEFAULT_DATETIME_FORMAT
elif isinstance(value, datetime.timedelta):
hours = value.days * 24 + value.seconds // 3600
minutes = (value.seconds // 60) % 60
seconds = value.seconds % 60
tmp_array = [hours, minutes, seconds]
value = xlrd.xldate.xldate_from_time_tuple(tmp_array)
style = XFStyle()
style.num_format_str = DEFAULT_TIME_FORMAT
elif isinstance(value, datetime.date):
tmp_array = [value.year, value.month, value.day]
value = xlrd.xldate.xldate_from_date_tuple(tmp_array, 0)