excle表导出成字典

import xlrd


def get_data(filename, sheetnum):
    dir_case = filename
    data = xlrd.open_workbook(dir_case)
    table = data.sheets()[sheetnum]
    nor = table.nrows
    nol = table.ncols
    dict = {}
    for i in range(1, nor):
        for j in range(nol):
            title = table.cell_value(0, j)
            value = table.cell_value(i, j)
            dict[title] = value
        yield dict


if __name__ == '__main__':
    for i in get_data('D:\\pycharm\\untitled\\demo.xlsx', 0):
        print(i)