修改excel
from openpyxl import load_workbook #读取Excel文件 inwb = load_workbook("2020.5.27.xlsx") #循环修改固定单元格的内容,不会修改其它单元格的内容 for sheetname in inwb.get_sheet_names(): sheet = inwb[sheetname] if sheet.cell(row=2, column=10).value == "产品型号": sheet.cell(row=2, column=12,value = "BHA-") inwb.save("2020.5.27.xlsx")