python openpyxl模块合并单元格，设置行高，列宽，边框，居中，字体样式

原创

已于 2022-12-05 08:54:00 修改 · 1.1w 阅读

标签

#python #excel

收录于

于 2022-02-23 15:11:35 首次发布

from openpyxl.styles import Border,Side,Alignment,Font
from openpyxl import load_workbook,Workbook
# 居中样式
align = Alignment(horizontal='center',vertical='center',wrap_text=True)
# 边框样式
border = Border(left=Side(border_style='thin'),
    right=Side(border_style='thin'),
    top=Side(border_style='thin'),
    bottom=Side(border_style='thin'))

wb = Workbook()

# temp_names = wb.sheetnames
# sheet1 = wb.get_sheet_by_name(temp_names[3])

sheet1 = wb.active
# 合并单元格A1-K1
sheet1.merge_cells('A1:K1')
sheet1['A1'] = '记录表'
# 设置font 字体
font_title = Font(u'微软雅黑',size=18