python实现excel中批注图片填充

import xlwings as xw
import os

# 打开工作簿并选择要读取的工作表
workbook = xw.Book(r'D:\Users\work\2Other\NBU\2024恢复\Q1\oracle_2024Q1.xlsx')
worksheet = workbook.sheets['Sheet1']

# 从A列第二行开始读取单元格内容并填充图片
for row in range(2, worksheet.range('A' + str(worksheet.cells.last_cell.row)).end('up').row + 1):
    # 读取单元格内容并拼接成图片路径
    cellValue = worksheet.range('A' + str(row)).value
    imagePath = 'D:\\Users\\work\\2Other\\NBU\\2024恢复\\Q1\\screenshot\\oracle\\' + cellValue + '.JPG'

    #print(imagePath)
    if not os.path.exists(imagePath):
        continue

    # 将图片填充到E列批注中
    comment = worksheet.range('D' + str(row)).api.Comment
    comment.Shape.Fill.UserPicture(imagePath)

# 关闭工作簿
workbook.save()
workbook.close()