openpyxl模块_测试用例读取和结果写入

openpyxl模块_读取和写入

from openpyxl import load_workbook
from tools.do_cfg import ReadConfig

class DoExcel:
    def __init__(self, path, sheet):
        self.path = path
        self.wb = load_workbook(path)   # 打开excel
        self.sheet = self.wb[sheet]     # 表单名定位表单
        self.max_row = self.sheet.max_row        # 最大行数
        self.max_column = self.sheet.max_column  # 最大列数
        # 打印调试
        # print('定位并取值：', self.sheet.cell(1,1).value)