from openpyxl import load_workbook wb=load_workbook('anju.xlsx') sheet=wb.active for uu in range(1,100): sheet.cell(row=uu,column=6).value=zuijin(av1,av2) wb.save("1.xlsx")
python 修改EXCEL另存
发布时间 2023-04-05 16:34:16作者: myrj
from openpyxl import load_workbook wb=load_workbook('anju.xlsx') sheet=wb.active for uu in range(1,100): sheet.cell(row=uu,column=6).value=zuijin(av1,av2) wb.save("1.xlsx")