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.设置边框样式
Side(style=,color=)#边框样式，颜色
Border(left=,right=,top=,bottom=)

5.设置填充样式
PatternFill(fill_type=,fgColor=)
GradientFill(stop=(渐变颜色1,渐变颜色2,……))

6.设置行高和列宽
.row_dimensions[行编号].height=行高
.column_dimensions[列编号].width=列宽

7.合并/取消合并单元格
.merge_cells(待合并的单元格编号)
.merge_cells(start_row=起始行号,start_column=起始列号,end_row=结束行号,end_column=结束列号)
.unmerge_cells()#括号内写法同上

8.openpyxl插入图片
openpyxl.drawing.image sheet.add_image()
from openpyxl import load_workbook
from openpyxl.drawing.image import Image
workbook=load_workbook(filename="test.xlsx")
sheet=workbook.active
logo=Image("testpic.png")
logo.height=100
logo.width=100
sheet.add_image(logo,"C1")
workbook.save(filename="test.xlsx")

9.插入柱状图
BarChart() Reference()
from openpyxl import load_workbook
from openpyxl.chart import BarChart,Reference
workbook=load_workbook(filename="test.xlsx")
sheet=workbook.active
chart=BarChart()#创建一个柱状图
data=Reference(worksheet=sheet,min_row=1,max_row=7,min_col=2,max_col=3)
categories=Reference(sheet,min_col=1,min_row=2,max_row=7)#设定x轴项目名称
chart.add_data(data,titles_from_data=True)#给柱状图添加数据，数据源中有标题
chart.set_categories(categories)
sheet.add_chart(chart,"E2")
workbook.save("test.xlsx")

10.插入条形图
LineChart()#方式类似柱状图