Patch for saving a datetime in worksheet.py
Created originally on Bitbucket by Anonymous
Version 1.2.0
At present the code saves the year only and XL tries to interpret it as a julian date and ends up with a date in 1900s.
The problem is in worksheet.py as cell.value converts to datedate. If you change line 136 as follows, it works:
elif cell.data_type == cell.TYPE_NUMERIC:
tag(doc, 'v', body = '%s' % cell._value)
Great library thanks!