OpenPyXL库 --单元格样式设置
单元格的控制,依赖openpyxl.style包,其中定义有需要的对象,引入相关:
from openpyxl.styles import PatternFill, Font, Alignment, Border, SideBorder 边框 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
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&