如何用python将df更新到已有的excel文件

import pandas as pd
from openpyxl import load_workbook

# 读取Excel文件
book = load_workbook('path/to/excel_file.xlsx')

# 选择要更新的工作表
writer = pd.ExcelWriter('path/to/excel_file.xlsx', engine='openpyxl')
writer.book = book
writer.sheets = dict((ws.title, ws) for ws in book.worksheets)

# 读取DataFrame数据
df = pd.read_excel('path/to/data.xlsx')

# 将DataFrame数据写入指定的工作表
df.to_excel(writer, sheet_name='Sheet1', index=False)

# 保存Excel文件
writer.save()