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

5 votes169 views3 answers
Split a column into two columns pandas
Python
1 vote210 views1 answer
Print console sys.stdout
Python
3 votes166 views2 answers
Os.listdir in python
Python
0 vote168 views1 answer
Gurobi python example
Python
14 votes177 views3 answers
Pillow image from array
Python
0 vote178 views1 answer
Pouring 8 litres into 2 empty container of size 3 and 5 to get 4 litre in any container
Python
23 votes178 views2 answers
Python How To Check if String Is Empty
Python
14 votes179 views3 answers
Pyautogui down arrow
Python
0 vote168 views1 answer
Fibbonnai in python
Python
0 vote188 views1 answer
How to find determinant in numpy
Python