from datetime import datetime
from xlrd import xldate_as_tuple
import xlrd
if __name__ == '__main__':
book = xlrd.open_workbook(filename=r'C:\Users\think\Desktop\场次配置批量导入.xlsx')
table = book.sheet_by_name("场次配置")
for row_i in range(table.nrows):
row_value = table.row_values(row_i)
print(row_value)
# 处理日期 --------
date_value = table.row_values(1)[2]
# date_t = xlrd.xldate.xldate_as_datetime(date_value, 0)
date_t = xldate_as_tuple(date_value, 0)
# print(date_t.strftime('%Y/%m/%d'))
date_f = datetime(*date_t).strftime('%Y/%m/%d')
print(date_f)
# 处理时间------
time_v = table.row_values(1)[3]
time_t = xldate_as_tuple(time_v, 0)
print(time_t)
print(date_t[:3] + time_t[3:])
# time_t = xlrd.xldate.xldate_as_datetime(time_v, 0)
# print(type(time_t.strftime('%H:%M:%S')))
time_f = datetime(*(date_t[:3] + time_t[3:])).strftime('%H:%M:%S')
print(time_f)
15:30:00这种如果用xldate_as_tuple转,再转成datetime会有问题,因为年月日是0