appending new sheet to old excel file using openpyxl code example
Example: pandas append sheet to workbook
writer = pd.ExcelWriter("sample.xlsx")
df1.to_excel(writer, shet_name = "sheet1")
df2.to_excel(writer, sheet_name = 'sheet2')
writer.save()
writer = pd.ExcelWriter("sample.xlsx")
df1.to_excel(writer, shet_name = "sheet1")
df2.to_excel(writer, sheet_name = 'sheet2')
writer.save()