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

3 votes132 views1 answer
Python list to tensor
Python
1 vote173 views1 answer
Python f string round
Python
0 vote147 views1 answer
Python find matching string regardless of case
Python
0 vote182 views1 answer
Django save object in view
Python Django
0 vote142 views1 answer
Drop portion of string in dataframe python
Python
1 vote133 views2 answers
How to have player input in python
Python
0 vote147 views1 answer
How to fill a shape with colour in python turtle
Python
51 votes139 views6 answers
Pickle load
Python
6 votes142 views3 answers
Virtual environment mac
Python
0 vote143 views1 answer
Imread real color cv2
Python