【日常水贴 12】在已有 sheet 的 excel 追加新的 sheet，不覆盖已有的 sheet

from openpyxl import load_workbook
book = load_workbook(r’C:\Users\86133\Desktop\taizhang.xlsx’,)
writer = pd.ExcelWriter(r’C:\Users\86133\Desktop\taizhang.xlsx’, engine=‘openpyxl’)
writer.book = book
writer.sheets = dict((ws.title, ws) for ws in book.worksheets)

df.to_excel(writer, “sheet2”,index=False)
writer.save()
writer.close()