修改字体样式
from openpyxl.styles import Font
from openpyxl import load_workbook
workbook=load_workbook(filename=‘XXX.xlsx’)
sheet=workbook.active
cell=sheet[‘A1’]
font=Font(name=‘思源黑体 Regular’,size=12,bold=True,italic=True,color=‘FF0000’)
#Font(name=‘字体名称’,size=字体大小,bold=是否加粗,italic=是否斜体,color=字体颜色(rgb转变为hex格式))
cell.font=font
workbook.save(filename=‘xxx.xlsx’)
获取表格中字体的格式
font=cell.font
print(font.name,font.size,font.bold,font.italic)
设置对齐样式
alignment=Alignment(horizontal=‘center’,vertical=‘center’,text_rotation=45)
#Alignment(horizontal=水平对齐模式,vertical=垂直对齐模式,text_rotation=旋转角度,wrap_text=是否自动换行)
#水平对齐:‘distributed(分散对齐)’/‘justify(两端对齐)’/‘center’/‘left’/‘fill(填充)’/‘centerContinuous(排列居中)’/‘right’
#垂直对齐:‘bottom’/‘distributed’/‘