Melody

import xlrd
import datetime


def read_excel(row, col, table=0):  #默认为第一张表
"""根据获取目标单元格不同类型的数据返回值"""
    file = "文件名.xls"
    book = xlrd.open_workbook(file)
    data =book.sheets()[table]
    name = data.cell_value(row-1, col-1)    #定位单元格坐标转换
    type = data.cell_type(row-1, col-1)
    if type == 0: #空值
                name = "empty"
    elif type ==1:  #文本类型
                name = name
    elif type ==2 and name%1 ==0:  #整数类型
                name = int(name)
    elif type == 3:  #时间类型
                date_value = xlrd.xldate_as_datetime(name, 0)
                name = datetime.date.strftime(date_value, "%Y%m%d")
    elif type ==4:   #布尔类型
                name = True

    return name