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 vote193 views1 answer
Get midnight of current day python
Python
9 votes219 views2 answers
Django delete instance
Python
0 vote177 views1 answer
How t o add dataframe python
Python
31 votes198 views6 answers
How to remove whitespace from string in python
Python
0 vote184 views1 answer
Python close database connection
Python
1 vote205 views1 answer
For idx, col_name in enumerate(X_train.columns): print("The coefficient for {} is {}".format(file_name, regression_model.coef_[0][idx]))
Python
0 vote167 views1 answer
Inherit init method
Python
22 votes219 views3 answers
How to get tomorrow date in python
Python
3 votes135 views1 answer
How to present if statement in dfd
Python
0 vote183 views1 answer
Noninspection access to protected member
Python