前置:准备3个sheet页,各多张图片
注意事项:打开的excel要提前关闭,不然会报错
图片不可设置为悬浮或嵌入单元格,否则shape.Name更改,无效
from PIL import ImageGrab
import win32com.client as win32
ex=win32.gencache.EnsureDispatch('Excel.Application')
wb=ex.Workbooks.Open(r'E:\wt\text.xlsx')
num=1
for i in wb.Worksheets:
for n,shape in enumerate(i.Shapes):
if shape.Name.startswith('Picture'):
shape.Copy()
image=ImageGrab.grabclipboard()
image.convert('RGB').save(r'E:\wt\photo.air\{}.png'.format(num),'jpeg')
print(num)
num+=1
print(i)
ex.Quit()
效果: