Unable to 'append' data to existing sheets in excel using python

Asked Jun 14 '21 at 09:04

Active Jun 14 '21 at 09:04

Viewed 94 times

I have two sets of data which I want to append in different excel sheets using python.

I tried the following code but it actually writes a new sheet ex: education and experience, education1 and experience1.

with pd.ExcelWriter('profile.xlsx',engine='openpyxl', mode = 'a') as writer:
    df_experience.to_excel(writer, sheet_name = 'experience', index = False)
    df_education.to_excel(writer, sheet_name = 'education', index = False)

what can i do to 'append' data to existing sheets?

asked Jun 14 '21 at 09:04

Aytida

You mean that you'r spreadsheet already has two sheets called _experience_ and _education_?? – ARK1375 Jun 14 '21 at 09:20
@ARK1375 Yes, I want to add more data to the already existing spreadsheets – Aytida Jun 14 '21 at 09:22
Use the `startrow` flag and see if it helps. – ARK1375 Jun 14 '21 at 09:26
https://stackoverflow.com/questions/38074678/append-existing-excel-sheet-with-new-dataframe-using-python-pandas This answer helped^^^^ – Aytida Jun 14 '21 at 17:19

Unable to 'append' data to existing sheets in excel using python

0 Answers0