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 vote122 views1 answer
Python regex for a url
Python
2 votes123 views2 answers
How to round to the nearest 25 python
Python
6 votes136 views3 answers
Python how to save a Seaborn plot into a file
Python
0 vote109 views1 answer
Merge_sort
Python
2 votes116 views2 answers
Build image from dockerfile
Python
1 vote121 views1 answer
Qlabel alignment center python
Python
2 votes116 views1 answer
How to make random colors in python turtle
Python
0 vote107 views1 answer
Python array remove new element
Python
6 votes124 views1 answer
Django model form
Python
7 votes118 views2 answers
Pygame keyboard input
Python