官方文档: http://openpyxl.readthedocs.io/en/default/
OpenPyXL库 --单元格样式设置
单元格样式的控制,依赖openpyxl.style包,其中定义有样式需要的对象,引入样式相关:
from openpyxl.styles import PatternFill, Font, Alignment, Border, Side
- Border 边框 Side 边线
- PatternFill 填充
- Font 字体
- Aignment 对齐
以上基本可满足需要
基本用法是,将单元格对象的设置的属性赋为新的与默认不同的相应对象。
导入excel
from openpyxl import load_workbook
from openpyxl.styles import Border,Side
wb = load_workbook("模板.xlsx")#使用openpyxl读取xlsx文件,创建workbook
ws = wb.active
ws
<Worksheet "sheet1">
1、Border 边框 Side 边线
from openpyxl.styles import Border, Side
border_type=Side(border_style=None, color='FF000000')
border = Border(left=border_type,
right=border_type,
top=border_type,
bottom=border_type,
diagonal=border_type,
diagonal_direction=0,
outline=border_type,
vertical=border_type,
horizontal=border_type
)
border_style的样式有:
‘dashDot’,‘dashDotDot’,‘dashed’,‘dotted’,‘double’,
‘hair’,‘medium’,‘mediumDashDot’,‘mediumDashDo