Question : pandas to excel add another sheet in existing excel file
Answered by : bhudis-wittayanusit
import pandas as pd
from openpyxl import load_workbook
FilePath = "your excel path"
ExcelWorkbook = load_workbook(FilePath)
writer = pd.ExcelWriter(FilePath, engine = 'openpyxl')
writer.book = ExcelWorkbook
df.to_excel(writer, sheet_name = 'your sheet name')
writer.save()
writer.close()Source : https://thinkingneuron.com/add-new-sheet-to-excel-using-pandas/ | Last Update : Fri, 03 Sep 21