摘要： from openpyxl import load_workbook class Excel_util: def __init__(self,path): self.path=path # 加载输入路径的文件 self.wb=load_workbook(self.path) #获取excel的she 阅读全文

摘要： from openpyxl import load_workbook #只能加载已存在的表格 wb=load_workbook("D:\zhijing_work\测试数据\测试文件\yetangjian.xlsx") sheet=wb['Sheet1'] # 操作单列 for cell in she 阅读全文