How to write to existing Excel file in Pandas

In this post you learn how to write to existing Excel file in Pandas library of Python. In pandas, you can write to an existing Excel file using the pandas.DataFrame.to_excel method.

Example of writing to Excel file

Here is an example:

import pandas as pd

# create a sample dataframe
df = pd.DataFrame({'col1': [1, 2, 3, 4, 5], 'col2': [3, 4, 5, 6, 7]})

# write data to an existing Excel file
writer = pd.ExcelWriter('existing_file.xlsx', engine='openpyxl', mode='a')
df.to_excel(writer, index=False, sheet_name='Sheet1')
writer.save()

In this example, existing_file.xlsx is the name of the existing Excel file. The engine parameter is set to ‘openpyxl’ to specify the engine used to write the file, and mode=’a’ means to open the file in append mode, so the new data will be appended to the existing data instead of overwriting it. The sheet_name parameter is set to ‘Sheet1’ to specify the name of the sheet where the data will be written. The index parameter is set to False to exclude the index column.

See also:
How to save dataframe as Excel file
How to read multiple Excel sheets in Pandas
How to save dataframe as csv