xlsxwriter未将格式应用于数据帧的标题行-Python Pandas

xlsxwriter未将格式应用于数据帧的标题行-Python Pandas

您正在尝试更改标题的格式，因此应首先重置默认标题设置

pd.core.format.header_style = None

然后根据需要应用格式

format = workbook.add_format()format.set_align('center')format.set_align('vcenter')worksheet.set_column('A:C',5, format)

这是完整的工作代码

d=pd.Dataframe({'a':['a','a','b','b'],    'b':['a','b','c','d'],    'c':[1,2,3,4]})d=d.groupby(['a','b']).sum()pd.core.format.header_style = Nonewriter = pd.ExcelWriter('pandas_out.xlsx', engine='xlsxwriter')workbook  = writer.bookd.to_excel(writer, sheet_name='Sheet1')worksheet = writer.sheets['Sheet1']format = workbook.add_format()format.set_align('center')format.set_align('vcenter')worksheet.set_column('A:C',5, format)writer.save()