生成excel内图表

插入图片
from openpyxl.drawing.image import Image
from openpyxl import load_workbook
workbook=load_workbook(filename=‘XXX.xlsx’)
sheet=workbook.active

img=Image(‘XXX.png’)
img.height=100
img.width=100
sheet.add_image(img,‘C1’)

workbook.save(filename=‘xxx.xlsx’)

生成图表

插入柱状图
from openpyxl.chart import BarChart,Reference
chart=BarChart()
data=Reference(worksheet=sheet,min_row=1,max_row=7,min_col=2,max_col=3)
#data为需要生成的数据
categories=Reference(sheet,min_col=1,min_row=2,max_row=7)
#categories是分类的名称

chart.add_date(data,titles_from_data=True)
#data包括标题，给柱状图添加标题
chart.set_categories(categories)
sheet.add_chart(chart,‘E2’)

插入条形图
from openpyxl.chart import LineChart,Reference
chart=LineChart()
data=Reference(worksheet=sheet,min_row=20,max_row=21,min_col=2,max_col=3)
categories=Reference(sheet,min_col=1,min_row=2,max_row=7)

chart.add_date(data,from_rows=True,titles_from_data=True)
#from_rows表示按行排列
chart.set_categories(categories)
sheet.add_chart(chart,‘B23’)

将xls文件改为xlsx文件，运行程序会报错
File contains no valid workbook part

学习链接：https://www.bilibili.com/video/BV197411f7Rp