Python-Excel-openpyxl-06-插入图片

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

excel_address = r"E:\Coding\E_PythonWriting\Excel\openpyxl示例_6.xlsx"
wb = load_workbook(excel_address)
sht = wb.worksheets[0]

img_address_1 = r"E:\Coding\E_PythonWriting\Excel\1.png"
img = Image(img_address_1)
sht.add_image(img, 'A1')

sht.column_dimensions['K'].width = 20.0
sht.row_dimensions[1].height = 40.0

img_address_2 = r"E:\Coding\E_PythonWriting\Excel\1.png"
img = Image(img_address_2)
img.width = 19.0
img.height = 39.0

sht.add_image(img, 'K1')

wb.save(excel_address)