如何在.xlsm文件中使用Pandas向现有的Excel表格添加数据帧

import pandas as pd
from openpyxl import load_workbook

file_path = 'path/to/your/file.xlsm'
book = load_workbook(file_path)
writer = pd.ExcelWriter(file_path, engine='openpyxl')
writer.book = book

data = {'Column1': [1, 2, 3],
        'Column2': ['A', 'B', 'C']}
df = pd.DataFrame(data)

sheet_name = 'Sheet1'  # 要添加数据的工作表名称
df.to_excel(writer, sheet_name=sheet_name, index=False, header=False, startrow=writer.sheets[sheet_name].max_row)

writer.save()
writer.close()