请教一下在导出excel的时候按照图上的表头进行自定义?

pandas你值得拥有

import openpyxl
from openpyxl.styles import Alignment

data = [
    ['Name', 'John', 'Alice', 'Bob'],
    ['Age', 30, 25, 28],
    ['Location', 'New York', 'London', 'Paris']
]

wb = openpyxl.Workbook()
ws = wb['Sheet']

ws['A1'].value = "Table"
start_row = 1
end_row = 1
start_column = 1
end_column = len(data[0])

merge_range = f"{ws.cell(row=start_row, column=start_column).coordinate}:{ws.cell(row=end_row, column=end_column).coordinate}"
ws.merge_cells(merge_range)

for row in data:
    ws.append(row)

al = Alignment(horizontal='center', vertical='center')
for row in ws['A1':'D4']:
    for cell in row:
        cell.alignment = al

wb.save('example.xlsx')