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 vote128 views1 answer
Comment arrêter l'exécution d'un programme python
Python
7 votes137 views3 answers
Update django
Python
0 vote137 views2 answers
Messagebox python pyqt
Python
0 vote135 views1 answer
Open pkl file python
Python
3 votes138 views3 answers
Convert all columns to float pandas
Python
3 votes151 views2 answers
Venv upgrade python
Python
13 votes146 views2 answers
Map function using lambda in python
Python
9 votes142 views6 answers
Python text to speech
Python
0 vote140 views1 answer
Get or create django
Python
0 vote140 views1 answer
Mongodb in python
Python