【PYTHON,EXCEL】利用python进行EXCEL处理4 编辑图表

本篇让我们介绍一下编辑图表的方法

1.插入图片方法：

from openpyxl import load_workbook
from openpyxl.drawing.image import Image             #tupian


workbook = load_workbook(filename="2.xlsx")
sheet = workbook.active

one = Image("666.png")
one.height = 50
one.width = 50

sheet.add_image(one,"c1")
workbook.save(filename="2.xlsx")