Excel 批量插入图片

from openpyxl.drawing.image import Image
import os

img_path = r'C:\Users\Administrator\Desktop\临时任务\50 images/'
excel_path = r'C:\Users\Administrator\Desktop\临时任务/测试.xlsx'
work = op.Workbook()
active = work.active
count = 1

# 调整表格列宽和行高
active.column_dimensions['A'].width = 9
active.column_dimensions['B'].width = 15
active.column_dimensions['C'].width = 15
active.column_dimensions['D'].width = 15
active.column_dimensions['E'].width = 15
active.column_dimensions['F'].width = 15

col_list = 'BCDEF'
COL_INDEX = 0

for img_file in os.listdir(img_path):

    im = os.path.join(img_path, img_file)
    img = Image(im)  # 获取图片
    img.width, img.height = (70, 70)  # 设置图片大小

    active.add_image(img, anchor=col_list[COL_INDEX] + str(count))  # 插入对应单元格
    # 设置列宽
    active.row_dimensions[count].height = 68
    COL_INDEX += 1
    if COL_INDEX == 5:
        COL_INDEX = 0
        count += 1
work.save(excel_path)