讨论数量:
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')
推荐文章: