Python Excel在现有的工作表中编写一个DataFrame

我想在现有的工作表(这里是“sheet1”)中添加一个数据aframe，但是代码创建了一个新的“sheet1”。 这是我的代码: 非常感谢你的帮助 亚历克斯

import pandas as pd
import numpy as np
from openpyxl import load_workbook

path = ""
df = pd.DataFrame({'Data': [11, 12, 13, 14]})
book = load_workbook(path)
writer = pd.ExcelWriter(path, engine = 'openpyxl')
writer.book = book
df.to_excel(writer,sheet_name="Sheet1" startrow=1, startcol=5, header=False,index=False)
writer.save()
writer.close()

问题来源StackOverflow 地址：/questions/59378901/python-excel-write-a-dataframe-in-an-existing-sheet