参考文档: https://blog.csdn.net/f2157120/article/details/105156476/
1、插入图片
from openpyxl import load_workbook,Workbook
from openpyxl.drawing.image import Image
workbook = load_workbook(filename='./2012.xlsx')
sheet = workbook.active
image = Image('./2.jpg')
image.height = 100
image.width = 100
sheet.add_image(image, 'C1')
workbook.save(filename='./2012.xlsx')