您正在尝试更改标题的格式，因此应首先重置默认标题设置
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()
