使用XlsxWriter将数据框和按钮添加到同一工作表

import pandas as pd
import xlsxwriter

workbook = xlsxwriter.Workbook('output.xlsx')
worksheet = workbook.add_worksheet()

data = {'Name': ['John', 'Amy', 'David'],
        'Age': [25, 30, 35],
        'City': ['New York', 'London', 'Paris']}
df = pd.DataFrame(data)

# 写入数据框到工作表
worksheet.write('A1', 'Name')
worksheet.write('B1', 'Age')
worksheet.write('C1', 'City')

for i, row in df.iterrows():
    worksheet.write(i+1, 0, row['Name'])
    worksheet.write(i+1, 1, row['Age'])
    worksheet.write(i+1, 2, row['City'])

# 添加按钮
worksheet.insert_button('D2', {'macro': 'my_macro', 'caption': 'Click Me'})

# 定义宏
worksheet.add_vba_project('./vbaProject.bin')

vba_code = '''
Sub my_macro()
    MsgBox "Button Clicked!"
End Sub
'''

# 添加VBA代码
worksheet.add_vba_module(vba_code)

workbook.close()