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 votes199 views1 answer
Python if string contains char
Python
8 votes147 views3 answers
Linear search python
Python
0 vote167 views2 answers
Tsv to csv python
Python
10 votes156 views4 answers
Multiply each element in list python
Python
1 vote160 views1 answer
Python increase one item in list
Python
4 votes181 views2 answers
Flask arguments in url
Python Flask
11 votes151 views4 answers
Flask debug
Python
0 vote182 views1 answer
Ope pickle file
Python
18 votes149 views4 answers
Create a venv
Python
0 vote140 views1 answer
Df add value at first index
Python