用Python在excel中插入对象

pip install openpyxl

from openpyxl import Workbook
from openpyxl.drawing.image import Image

# 创建一个新的工作簿
workbook = Workbook()

# 选择活动的工作表
worksheet = workbook.active

# 插入对象
image = Image('path/to/image.jpg')  # 替换为实际的图片路径
worksheet.add_image(image, 'A1')  # 将图片插入到A1单元格

# 保存工作簿
workbook.save('path/to/output.xlsx')  # 替换为实际的输出路径