我正在使用xlsxwriter将pandas DataFrame保存为Excel文件。我已经成功格式化了所有数据(设置列宽、字体大小等),但无法更改表头的字体,我找不到方法。以下是我的示例:
import pandas as pd
data = pd.DataFrame({'test_data': [1,2,3,4,5]})
writer = pd.ExcelWriter('test.xlsx', engine='xlsxwriter')
data.to_excel(writer, sheet_name='test', index=False)
workbook = writer.book
worksheet = writer.sheets['test']
font_fmt = workbook.add_format({'font_name': 'Arial', 'font_size': 10})
header_fmt = workbook.add_format({'font_name': 'Arial', 'font_size': 10, 'bold': True})
worksheet.set_column('A:A', None, font_fmt)
worksheet.set_row(0, None, header_fmt)
writer.save()
倒数第二行尝试设置标题格式,但实际上无效。