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

1 vote183 views1 answer
Must have equal len keys and value when setting with an ndarray
Python
0 vote177 views1 answer
Print nested dictionary values in python
Python
0 vote153 views2 answers
Pydrive download file
Python
0 vote178 views1 answer
How to show Screen keyboard ubuntu with python
Python
1 vote181 views2 answers
Python multiline comment
Python
8 votes179 views2 answers
Min and max number in list python
Python
6 votes189 views2 answers
Django read mesage
Python
3 votes140 views1 answer
Binomial variance
Python
6 votes169 views2 answers
How to press enter python keyboard
Python
0 vote180 views1 answer
Right-left staircase python
Python