openpyxl单元格居中

代码

import openpyxl
from openpyxl.styles import Alignment

# 导入填充类PatternFill
wb = openpyxl.load_workbook('/Users/test0712.xlsx')
ws = wb['Sheet1']
max_rows = ws.max_row  # 获取最大行
max_columns = ws.max_column  # 获取最大列


align=Alignment(horizontal='center',vertical='center')
# openpyxl的下标从1开始
for i in range(1, max_rows + 1):
    for j in range(1, max_columns + 1):
        ws.cell(i, j).alignment = align

wb.save('/Users/test0712.xlsx')

居中前

居中后