Pandas to excel: append a dataframe to an excel sheet with existing data w/o overwritting

Asked Feb 12 '19 at 12:32

Active Feb 12 '19 at 12:45

Viewed 143 times

This question has been asked but I tried every solution and it still overwrite what I already have in my sheet. What I have tried: writer = pd.ExcelWriter('/home/viktor/Downloads/kpi_report_current.xlsx', engine='openpyxl') df_kpi.to_excel(writer, index=True) writer.save()

But it overwrite the dataframe that I previously exported to the excel sheet...I tried every solution on the following page:How to write to an existing excel file without overwriting data (using pandas)?

To be more precise, I tried the following: from openpyxl import load_workbook

book = load_workbook('/home/viktor/Downloads/kpi_report_current.xlsx')
writer = pd.ExcelWriter('/home/viktor/Downloads/kpi_report_current.xlsx', engine='openpyxl') 
writer.book = book
writer.sheets = dict((ws.title, ws) for ws in book.worksheets)

df_kpi.to_excel(writer)

writer.save()

Which load the existing data on the excel sheet, but it is still overwritting it...

Any other idea? Thanks!

edited Feb 12 '19 at 12:45

asked Feb 12 '19 at 12:32

Viktor.w

1,787
2
20
46

1

Did you try loading the excel to a dataframe append the new data and then save it to excel again? – hodisr Feb 12 '19 at 12:36
Just open existing worksheet using openpyxl module and write data row by row and close file. Try This https://stackoverflow.com/questions/38074678/append-existing-excel-sheet-with-new-dataframe-using-python-pandas – Anonymous Feb 12 '19 at 12:45
@SurajM can you show me? I am stuck right now.. – Viktor.w Feb 12 '19 at 13:03
Example is given in link that I provided above...Check `def append_df_to_excel` function. – Anonymous Feb 12 '19 at 13:07
Yes thanks I did not read everything! Thanks – Viktor.w Feb 12 '19 at 13:10

Pandas to excel: append a dataframe to an excel sheet with existing data w/o overwritting

0 Answers0