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

4 votes198 views1 answer
Get prime number python
Python
4 votes98 views1 answer
Pandas replace empty strings with NaN
Python
0 vote105 views1 answer
Helper for FastAPI Users to create a super user
Python
0 vote88 views1 answer
Python draw polygon
Python
217 votes306 views6 answers
Python random number generator
Python
1 vote107 views1 answer
Difference between loc and iloc
Python
0 vote101 views1 answer
Can i save additional information with png file
Python
69 votes107 views3 answers
Reverse the words in a string python
Python
21 votes117 views2 answers
How to update python
Python
0 vote99 views1 answer
Download pytz python
Python