数字转换星期几python_将日期从Excel以数字格式转换为日期格式python

I am reading data from excel and manipulating the data using python. But dates are coming as integers. How can I convert the dates back to date format?

5/15/2015 is coming as 42139.00

解决方案from datetime import datetime

excel_date = 42139

dt = datetime.fromordinal(datetime(1900, 1, 1).toordinal() + excel_date - 2)

tt = dt.timetuple()

print dt

print tt

As mentioned by J.F. Sebastian, this answer only works for any date after 1900/03/01

EDIT: (in answer to @R.K)

If your excel_date is a float number, use this code:

def floatHourToTime(fh):

h, r = divmod(fh, 1)

m, r = divmod(r*60, 1)

return (

int(h),

int(m),

int(r*60),

)

excel_date = 42139.23213

dt = datetime.fromordinal(datetime(1900, 1, 1).toordinal() + int(excel_date) - 2)

hour, minute, second = floatHourToTime(excel_date % 1)

dt = dt.replace(hour=hour, minute=minute, second=second)