Python xlrd date

import datetime, xlrd
book = xlrd.open_workbook("myexcelfile.xls")
sh = book.sheet_by_index(0)
a1 = sh.cell_value(rowx=0, colx=0)
a1_as_datetime = datetime.datetime(*xlrd.xldate_as_tuple(a1, book.datemode))
print 'datetime: %s' % a1_as_datetime

Source: stackoverflow.com

Similar codes

6 votes189 views2 answers
Python type annotations
Python
0 vote169 views1 answer
How to create frequency table in python
Python
0 vote198 views2 answers
Python return multiple variables from function
Python
3 votes148 views3 answers
Add items to list in python 3
Python
0 vote190 views1 answer
Get last “column” after .str.split() operation on column in pandas DataFrame
Python
0 vote202 views1 answer
Blender show python version
Python
-4 votes179 views4 answers
Python 3.2 release date
Python
3 votes181 views2 answers
How to get key value in nested dictionary python
Python
0 vote187 views1 answer
Python three periods
Python
13 votes179 views3 answers
How to find and remove certain characters from text string in python
Python