python读取excel，对日期合时间的转换

from datetime import datetime
from xlrd import xldate_as_tuple

import xlrd


if __name__ == '__main__':
    book = xlrd.open_workbook(filename=r'C:UsersthinkDesktop场次配置批量导入.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