python 读excle的日期:
1,例如像43256.0的数据,
from datetime import datetime
from xlrd import xldate_as_tuple
date = '45368.0'
date = datetime(*xldate_as_tuple(date, 0))
date = date.strftime('%Y-%m-%d')
python 读excle的日期:
1,例如像43256.0的数据,
from datetime import datetime
from xlrd import xldate_as_tuple
date = '45368.0'
date = datetime(*xldate_as_tuple(date, 0))
date = date.strftime('%Y-%m-%d')