2302_81864644的博客

原创 关于Python自动化办公的复制代码

new_wb = openpyxl.load_workbook(f"/Users/baizhi/sells/幸福里店/2022{month:02}.xlsx",data_only=True)wb.save("/Users/baizhi/sells/总表.xlsx")sheet_b = wb.create_sheet("东湖店")sheet_c = wb.create_sheet("锦江店")sheet["C1"].value = "销售额"sheet["B1"].value = "月份"