Write Dataframe to excel with template

Question

I am trying to write my dataframe to excel. I am able to write the data using pandas.

df.to_excel(r'Path where the exported excel file will be stored\File Name.xlsx', index = False)

But the excel I am trying to write contain some template which look something like this.

Whenever I try to write the df values to excel using df.to_excel it always remove the template and write is there way I can write the data below the template in excel.

Any suggestions?

Does this answer your question? How to write to an existing excel file without overwriting data (using pandas)? — Binit Amin
– Binit Amin, Commented Nov 1, 2021 at 14:20

Tonechas · Accepted Answer · 2021-11-01 21:58:30Z

1

I am able to solve this using below code:

import pandas as pd
from openpyxl import load_workbook

path = "Excel.xlsx"
book = load_workbook(path)
writer = pd.ExcelWriter("Excel.xlsx", engine='openpyxl')
writer.book = book
writer.sheets = {ws.title: ws for ws in book.worksheets}
df.to_excel(writer, startrow=writer.sheets['Sheet1'].max_row, index=False, header=False)
writer.save()

edited Nov 1, 2021 at 21:58

Tonechas

13.8k16 gold badges52 silver badges85 bronze badges

answered Oct 27, 2021 at 7:31

rohi

3152 silver badges13 bronze badges

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

1 Comment

Community Over a year ago

Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

Write Dataframe to excel with template

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related