如何将pd.dataframe列表导入到现有excel文件的末尾而不覆盖它

pip install pandas openpyxl

import pandas as pd
from openpyxl import load_workbook

file_path = 'path_to_your_excel_file'
book = load_workbook(file_path)
writer = pd.ExcelWriter(file_path, engine='openpyxl')
writer.book = book

sheet_name = 'your_sheet_name'  # 替换为你的Sheet名称
if sheet_name in book.sheetnames:
    writer.sheets = dict((ws.title, ws) for ws in book.worksheets)

dataframe_list = [df1, df2, df3]  # 替换为你的pd.dataframe列表
for dataframe in dataframe_list:
    dataframe.to_excel(writer, sheet_name=sheet_name, startrow=writer.sheets[sheet_name].max_row, index=False, header=False)

writer.save()
writer.close()