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

0 vote390 views1 answer
How to change a particular text inside a list of dictionary
Python
0 vote345 views1 answer
Qmenubar pyqt
Python
27 votes355 views4 answers
Random letter generator python
Python
0 vote322 views1 answer
Python update header row
Python
0 vote340 views1 answer
Cant use foreign key in list_display django
Python Django
8 votes366 views3 answers
Export multiple python pandas dataframe to single excel file
Python
2 votes314 views1 answer
Converting datetime object format to datetime format python
Python
9 votes348 views2 answers
Python not in list
Python
0 vote310 views1 answer
Powershell open file with default program
Python
0 vote405 views1 answer
Protobuf python
Python