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 vote190 views2 answers
Mechanize python
Python
0 vote195 views1 answer
Cumulative percentaile pandas
Python
10 votes183 views3 answers
Accessing element from csv file in python
Python
0 vote174 views1 answer
Matplotlib radial averaging
Python
6 votes178 views1 answer
Getting dummies and input them to pandas dataframe
Python
72 votes163 views3 answers
How to split a string by character in python
Python
0 vote210 views1 answer
How to wait until pressing button in tkinter
Python
134 votes187 views6 answers
Rename columns pandas
Python
0 vote178 views1 answer
Iterating over the two ranges simultaneously and saving it in database
Python
1 vote220 views1 answer
Python divide one column by another
Python