用xlrd读取excel表格（python）

def data(excelPath, sheetName):    data = xlrd.open_workbook(excelPath)    table = data.sheet_by_name(sheetName)    # 获取第一行作为key值    keys = table.row_values(0)    # 获取总行数    rowNum = table.nrows    # 获取总列数    colNum = table.ncols    if rowNum <= 1:        raise BaseException("测试数据异常")    else:        r = []        j = 1        for i in range(rowNum - 1):            s = {}            # 从第二行取对应values值            values = table.row_values(j)            for x in range(colNum):                s[keys[x]] = values[x]            r.append(s)            j += 1        return r