from openpyxl import Workbook, load_workbook
file = 'test.xlsx'
wb = load_workbook(file)
ws = wb['test']
# 设置边框、字体、自动换行
from openpyxl.styles import Border, Font, Alignment, Side
# 定义边框格式
border = Border(left=Side(style='thin'), right=Side(style='thin'), top=Side(style='thin'), bottom=Side(style='thin'))
# 自定义字体格式,其中name:字体类型,size:字体大小,bold:是否加粗,italic:是否斜体,color:字体颜色
font = Font(name='微软雅黑', size='10', bold=True, italic=True, color="FF0000")
for row in ws.iter_rows(min_row=ws.min_row, max_row=ws.max_row, min_col=ws.min_column, max_col=ws.max_column):
for cell in row:
# 设置字体
cell.font = font
# 设置边框
cell.border = border
# 文本自动换行,水平居中,垂直居中
cell.alignment = Alignment(wrap_text=True, horizontal='center', vertical='center')
# 设置行高
for i in range(1, ws.max_row + 1):
ws.row_dimensions[i].height = 25
# 设置列宽-固定值
from openpyxl.utils import get_column_letter
for i in range(1, ws.max_column + 1):
ws.column_dimensions[get_column_letter(i)].width = 30
# 合并单元格A1-K1
ws.merge_cells('A3:C3')
wb.save(file)
openpyxl常用单元格格式设置
最新推荐文章于 2024-03-23 19:42:22 发布