How do I write data to an existing file in Excel using Pandas?

Question

I used the following code to read data in file_1 then write that to a new file_2.

import pandas as pd
inventory = pd.read_excel('file_1.xlsx', skiprows=3)
inventory.to_excel('file_2.xlsx')

file_2 is a newly created file each time. How do I write the data to specific tab in an existing file without clearing out other tabs that contain data?

thorntonc · Accepted Answer · 2020-08-31 21:00:11Z

1

ExcelWriter can be used to append to an existing Excel file using mode='a'. Specify the sheet name with the sheet_name parameter.

with pd.ExcelWriter('file_2.xlsx', mode='a') as writer:  
    inventory.to_excel(writer, sheet_name='Sheet_name_1')

edited Aug 31, 2020 at 21:00

answered Aug 31, 2020 at 20:55

thorntonc

2,1261 gold badge10 silver badges20 bronze badges

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

3 Comments

user14131935 Over a year ago

Thank you. The only part I don't understand is how it knows how to find file_2 with that code.

thorntonc Over a year ago

The file will be written to the default working directory unless otherwise specified.

user14131935 Over a year ago

This is helpful. Thank you. When I do that it keeps creating a new sheet. Is there a way to have it put the data in an existing sheet?

Collectives™ on Stack Overflow

How do I write data to an existing file in Excel using Pandas?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related