如何将xlsxwriter和Excelwriter一起使用来填充包含一些格式化文本和python导出的DataFrame的excel文件？

import pandas as pd
from pandas import ExcelWriter
import xlsxwriter

data = {'姓名': ['张三', '李四', '王五'],
        '年龄': [25, 30, 35],
        '性别': ['男', '女', '男']}
df = pd.DataFrame(data)

writer = ExcelWriter('output.xlsx', engine='xlsxwriter')
df.to_excel(writer, sheet_name='Sheet1', index=False)

workbook = writer.book
worksheet = writer.sheets['Sheet1']

bold_format = workbook.add_format({'bold': True})

worksheet.write('A1', '姓名', bold_format)
worksheet.write('B1', '年龄', bold_format)
worksheet.write('C1', '性别', bold_format)

writer.save()