Is there a way to write multiple pandas dataframes to the same sheet using openpyxl engine?

Question

I have done this but only the last dataframe was successfully written in the sheet. And I also found some samples to achive this using xlsxwriter engine,but how to do with openpyxl?

score 1 · Accepted Answer · answered Mar 21 '22 at 07:13

1

You can use ExcelWriter:

with pd.ExcelWriter('output.xlsx') as xlsx:
    df1.to_excel(xlsx, sheet_name='Sheet 1')
    df2.to_excel(xlsx, sheet_name='Sheet 1', startrow=len(df1) + 2)

answered Mar 21 '22 at 07:13

Corralien

109,409
8
28
52

Is there a way to write multiple pandas dataframes to the same sheet using openpyxl engine?

1 Answers1