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 首次发布
这段代码演示了如何使用openpyxl库在Excel文件中插入图片,并调整图片大小及对应单元格的列宽和行高。它遍历指定文件夹中的图片,按顺序插入到Excel的特定列中,并保持单元格的高度和宽度适配图片。
摘要由CSDN通过智能技术生成