pandas_write_excel.py

import pandas as pd

# save single sheet for excel file
df.to_excel(fp, index=True, columns=True)

# save multiple sheets for excel file
with pd.ExcelWriter(fp) as writer:
  df1.to_excel(writer, sheet_name='sheet1')
  df2.to_excel(writer, sheet_name='sheet2')

# save multiple sheets for existing file
with pd.ExcelWriter(fp) as writer:
  writer.book = openpyxl.load_workbook(fp)
  df1.to_excel(writer, sheet_name='new_sheet1')
  df2.to_excel(writer, sheet_name='new_sheet2')