python处理Excel数据并返回字典格式

#!/usr/bin/env python  
# -*- coding:utf-8 _*-  
""" 
@author: 壹拾壹
@Time: 2021/10/14 14:37
"""
from openpyxl import load_workbook


class EncapsulationExcel:
    """封装Excel
    """
    def __init__(self, filename, sheet=None):
        self.filename, self.sheet = filename, sheet

    def operation_excel(self):
        """操作Excel获取数据
        :return:
        """
        # 1.打开Excel
        wb = load_workbook(self.filename)
        # 2.定位表单
        if self.sheet is None:
            ws = wb.active
        else:
            ws = wb[self.sheet]
        # 3.获取表数据
        values = tuple(ws.iter_rows(min_row=1, max_row=1, values_only=True))
        sheet_head_tuple = values[0]
        cases_list = []  # 将数据字典信息, 存放在列表中, 这个列表就是嵌套字典列表
        for data in tuple(ws.iter_rows(min_row=2, values_only=True)):
            cases_list.append(dict(zip(sheet_head_tuple, data)))

        return cases_list


if __name__ == '__main__':
    file_name = "xlsx类型的excel"
    one_excel = EncapsulationExcel(filename=file_name)
    A = one_excel.operation_excel()
    print(A)