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 votes113 views2 answers
Python run command and read output
Python
0 vote115 views1 answer
Arduino loop array
Python
0 vote110 views2 answers
Remove nans and infs python
Python
9 votes132 views4 answers
Change the default python version mac
Python
6 votes110 views1 answer
Pd.set_option('display.max_columns', 200) pd.set_option('display.max_rows', 100)
Python
0 vote125 views1 answer
Python create unreadable save file
Python
1 vote107 views2 answers
Pygame window at center
Python
3 votes119 views1 answer
Draw a single pixel using pygame
Python
0 vote113 views1 answer
Free wifi connection disconnects frequently windows 10
Python
19 votes124 views6 answers
Python image resize
Python