Export dataframe into different sheets in an Excel without deleting the existing ones

Question

I have a dataframe df1 and I want to export it to an Excel which already has some sheets.

I tried using:

writer = pd.ExcelWriter(file_path, engine = 'xlsxwriter')
df1.to_excel(writer, sheet_name = 'test1', index = False)
writer.save()

This code deletes the existing sheets, and exports df1 into sheet named test1.

Have you tried loading the existing excel file as a dataframe and then appending the new data to it before finally exporting? — Lakpa Tamang
– Lakpa Tamang, Commented Nov 2, 2021 at 8:43

user12011833 · Accepted Answer · 2021-11-02 08:42:12Z

1

answered Nov 2, 2021 at 8:42

user12011833

Sign up to request clarification or add additional context in comments.

Comments

MDJ · Accepted Answer · 2021-11-02 08:57:04Z

1

writer = pd.ExcelWriter(file_path, engine = 'openpyxl', mode = 'a')
df1.to_excel(writer, sheet_name = 'test1', index = False)
writer.save()

Just gotta append

answered Nov 2, 2021 at 8:57

MDJ

1429 bronze badges