python 柱状图设置样式_Python修改Excel字体及图样

1.修改字体样式

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

from openpyxl.styles import Font

from openpyxl import load_workbook

workbook=load_workbook(filename='test.xlsx')

sheet=workbook.active

cell=sheet['A1']

font=Font(name='黑体',size=12,bold=True,italic=True,color='FF0000')

cell.font=font

workbook.save(filename='test.xlsx')

2.获取表格中字体的样式

cell.font.属性

属性有：.name .size .bold .italic

3.设置对齐样式

Alignment(horizontal=水平对齐模式,vertical=垂直对齐模式,text_rotation=旋转角度,wrap_text=是否自动换行)

水平对齐：'distributed','justify','center','left','centerContinuous','right','general'

垂直对齐：'bottom','distributed','justify','center','top'

4.