如何将pandas数据框追加到excel工作表中

pip install pandas

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

# 追加数据框到工作表中
df.to_excel(writer, sheet_name='sheet_name', index=False, header=False, startrow=writer.sheets['sheet_name'].max_row)

# 保存修改后的Excel文件
writer.save()
writer.close()