python 处理Excel 常见问题-读取Excel中时间,封装函数

import xlrd
from xlrd import xldate_as_tuple
from datetime import datetime

#打印Excel表格数据类型，寻找对应的结局函数
def ensure_cell_type():
    book = xlrd.open_workbook('example.xlsx')
    sheet = book.sheet_by_name('Sheet1')
    for row in range(sheet.nrows):
        for col in range(sheet.ncols):
            print(sheet.cell(row,col))
            print('type',sheet.cell(row,col).ctype)

#转换Excel中时间格式，此处的类型是3
def tran_time_form():
    book = xlrd.open_workbook('example.xlsx')
    sheet = book.sheet_by_name('Sheet1')
    for row in range(sheet.nrows):
        for col in range(sheet.ncols):
            value = sheet.cell(row, col).value
            if sheet.cell(row, col).ctype == 3:
                date = xldate_as_tuple(sheet.cell(row, col).value, 0)
                print(date)
                value = datetime(*date)
                print(value)

def main():
    ensure_cell_type()
    #tran_time_form()

if __name__ == "__main__":
    main()