openpyxl对excel进行读写

使用openpyxl对excel进行读写，没啥东西，贴代码吧

import openpyxl
import os


class ExcelHandler:
    def __init__(self, fpath):
        self.fpath = fpath

    def read(self, sheet_name):
        """读取文件"""
        # 打开文件
        wb = openpyxl.open(self.fpath)
        # 获取表格
        ws = wb[sheet_name]
        data = list(ws.values)
        # 关闭文件
        wb.close()
        header = data[0]
        all_data = []
        for row in data[1:]:
            row_dict = dict(zip(header, row))
            all_data.append(row_dict)
        return all_data

    def write(self, sheet_name, data, row, column):
        """写入excel数据"""
        wb = openpyxl.load_workbook(self.fpath)
        # 获取表格
        ws = wb[sheet_name]
        ws.cell(row=row, column=column).value = data
        # 通过workbook 保存和关闭
        wb.save(self.fpath)
        wb.close()


if __name__ == '__main__':
    xls = ExcelHandler(os.path.abspath('..')+'\\data\\cases.xlsx')
    excle_data = xls.read('register')