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 vote339 views1 answer
Change creation date filesystem py
Python
0 vote340 views1 answer
Change python 3.5 to 3.6 ubuntu
Python
6 votes400 views1 answer
Button in flask
Python
1 vote300 views1 answer
Python - remove repeted columns in a df
Python
6 votes318 views1 answer
Looking through an array in python
Python
0 vote342 views1 answer
Dataframe get index name
Python
3 votes342 views1 answer
Chech box in tkinter
Python
1 vote352 views1 answer
Django models.py convert DateTimeField to DateField
Python
0 vote356 views1 answer
Assert_series_equal
Python
5 votes357 views3 answers
Strptime python
Python