python获取excel表格中的图片并且修改图片名字

# coding=utf-8
# 20221101

from PIL import ImageGrab
import win32com.client as win32
import os,time
excelpath = os.path.join(os.getcwd(),'信息表.xlsx')
imagepath = os.path.join(os.getcwd(),'picture')
try:
    ex=win32.gencache.EnsureDispatch('Excel.Application')
except Exception as e:
    ex=win32.Dispatch('Excel.Application')
wb=ex.Workbooks.Open(excelpath)

num=1
for i in wb.Worksheets:     
    for n,shape in enumerate(i.Shapes):  
        if shape.Name.startswith('Picture'):
            shape.Copy()
            image=ImageGrab.grabclipboard()
            samplenum = i.Cells((num+1),2).Value   #获取每个图片对应的编号
            image.convert('RGB').save(os.path.join(imagepath,'{}.png'.format(samplenum)),'jpeg')                        
            print(num)
            print (samplenum)
            num+=1            
        print(i)
                   
ex.Quit()