+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: Data Science (https://python-forum.io/forum-44.html)
+--- Thread: How to add a dataframe to an existing excel file (/thread-18159.html)
How to add a dataframe to an existing excel file - wendysling - May-07-2019
Hello,
I am trying to add a dataframe to an existing sheet. I don't see any error, but the data does not show on the sheet.
Is anyone able to tell me what am I missing?
Thank you!
#Grab dataframe from another excel sheet
df = pd.read_excel('C:/path/Dataframe_File.xlsx',sheetname='Data')
#Open existing excel file
workbook1 = openpyxl.load_workbook('C:/path/Existing_File.xlsx')
writer = pd.ExcelWriter('C:/path/Existing_File.xlsx', engine='openpyxl')
#Add dataframe to excel file
df.to_excel(writer,sheet_name="Sheet",index=False,startrow=17,startcol=1,engine='openpyxl')
workbook1.save('C:/path/Existing_File.xlsx')
RE: How to add a dataframe to an existing excel file - michalmonday - May-08-2019
It's just a guess but maybe you need administrator priviledges to write on that path (e.g. I have to run command prompt as administrator to use "pip install" just because it's on C drive, maybe that is also the case with saving your file)
RE: How to add a dataframe to an existing excel file - wendysling - May-09-2019
I found a way around like this.
from openpyxl import load_workbook
workbook1 = openpyxl.load_workbook('file.xlsx')
writer = pd.ExcelWriter('file.xlsx', engine='openpyxl')
writer.book = workbook1
new_file.to_excel(writer, sheet_name='Shee1',index=False,startrow=2,startcol=1)
writer.save()
writer.close()