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)
Excel 批量插入图片
于 2023-02-01 13:28:30 首次发布