Python不在Excel工作簿中追加带有pandas的数据

import pandas as pd
from openpyxl import load_workbook

excel_file = 'path/to/excel/file.xlsx'
df = pd.read_excel(excel_file)

new_data = pd.DataFrame({'Column1': [value1, value2, ...], 'Column2': [value1, value2, ...], ...})

df = df.append(new_data, ignore_index=True)

with pd.ExcelWriter(excel_file, engine='openpyxl', mode='a') as writer:
    writer.book = load_workbook(excel_file)
    df.to_excel(writer, sheet_name='Sheet1', index=False)