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

0 vote138 views1 answer
Django set boolean field value in view
Python Django
2 votes175 views1 answer
Dollar
Python
2 votes166 views2 answers
Export pythonpath linux
Python
2 votes175 views2 answers
How to print right angle triangle in python
Python
0 vote165 views1 answer
Python how to write array into matlab file
Python
1 vote157 views1 answer
Max string length python
Python
6 votes167 views2 answers
Import numpy as np arr = np.array([[ 1, 2, 3], [2, 4, 6]]) arr. min ( =0)
Python
12 votes158 views3 answers
Iloc in dataframe
Python
0 vote164 views1 answer
Plt.plot(x, softmax(scores).T, linewidth=2)
Python
0 vote194 views1 answer
Condtion for equal time in selenium python
Python