P9.批量修改字体、样式.md
#修改表格内的字体、样式
#修改字体样式
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='思源黑体 Regular',size=12,bold=True,italic=True,color='FF0000')
cell.font = font
workbook.save(filename='这是一个表格.xlsx')
#获取表格中字体的样式
cell.font
例:
workbook = load_workbook(filename='这是一个表格.xlsx')
sheet = workbook.active
cell = sheet['A1']
font = cell.font
print(font.name, font.size, font.bold, fon