python封装函数自动读写excel数据
操作excel文档需要先安装openpyxl库,pip install openpyxl;
import openpyxl
class CaseData:
pass
class HandleExcel:
def __init__(self, filename, sheetname):
"""获取文件名和表单名"""
self.filename = filename
self.sheetname = sheetname
def open(self):
# 打开文件
self.wb = openpyxl.load_workbook(self.filename)
# 选中表单
self.sh = self