python读取excel

import xlrd

def read_xlsx():
    with xlrd.open_workbook('', 'rb') as book:
        table = book.sheet_by_name('Sheet1')
        row_num = table.nrows
        col_num = table.ncols
        xlsx_list = []
        key = table.row_values(0)
        if row_num <= 1:
            log.info('excel为空')
        else:
            j = 1
            for i in range(row_num - 1):
                xlsx_dict = {}
                values = table.row_values(j)
                for x in range(col_num):
                    xlsx_dict[key[x]] = values[x]
                j = j + 1
                xlsx_list.append(xlsx_dict)
            return xlsx_list