Python与openpyxl的不解之缘【3】

目录

1 批量调整字体、样式

1.1 获取字体样式

1.2 修改字体样式、

1.3 设置单元格格式分类

1.4 设置对齐样式

1.5 设置边框样式

1.6 设置填充颜色

1.7 设置行高和列高

1.8 合并单元格

---

1 批量调整字体、样式

1.1 获取字体样式

cell.font.属性

from openpyxl.styles import Font
from openpyxl import load_workbook

workbook = load_workbook(filename='写入表格.xlsx')
sheet = workbook.active
cell = sheet['A1']
font = cell.font
print('font.name是:',font.name,'font.size是:',font.size,'是否粗体:',font.bold,'是否斜体:',font.italic)

1.2 修改字体样式、

font = Font(name=‘字体名称’,size =字体大小,bold = 是否粗体,italic = 是否斜体,color =‘字体颜色’)

from openpyxl.styles import Font
from openpyxl import load_workbook

workbook = load_workbook(filename='写入表格.xlsx')
sheet = workbook.active
cell = sheet['A1']
font = Font(name='宋体',size =12,bold = True,italic = True,color ='FF0000')
cell.font =font
workbook.save(filename='写入表格.xlsx')

1.3 设置单元格格式分类

可以通过设置单元格的风格来设置单元格格式分类

[openpyxl所支持的excel的单元格格式][https://openpyxl.readthedocs.io/en/stable/_modules/openpyxl/styles/numbers.html?highlight=openpyxl.styles.numbers]

from openpyxl.styles import Font
from openpyxl import load_workbook

workbook = load_workbook(filename='写入表格.xlsx')
sheet = workbook.active
cell = sheet['A1']

# 设置单元格分类为百分比
cell.style = &#