How to convert from Python date to Excel date using xlrd (attribute xlrd.xldate_from_date_tuple does not exist)

Question

How to convert from Python date to Excel date using xlrd module? How to convert a python datetime.datetime to excel serial date number suggests a 'manual' solution, I wonder if it is the best way.

Xlrd document suggests to use xlrd.xldate_from_date_tuple

but

>>> import xlrd
>>> xlrd.xldate_from_date_tuple
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
AttributeError: 'module' object has no attribute 'xldate_from_date_tuple'

Could you help? Thanks.

I am looking for the opposite of xlrd_as_tuple. This one works like a charm. — Yulia V, Jan 24 '13 at 10:19

score 3 · Accepted Answer · answered Jan 24 '13 at 18:33

3

Use xlrd.xldate.xldate_from_date_tuple

answered Jan 24 '13 at 18:33

John Machin

81,303
11
141
189

How to convert from Python date to Excel date using xlrd (attribute xlrd.xldate_from_date_tuple does not exist)

1 Answers1