Python如何读取excel中的图片

pip install pillow

pip install pypiwin32

from PIL import ImageGrab

import win32com.client as win32

excel = win32.gencache.EnsureDispatch('Excel.Application')

workbook = excel.Workbooks.Open(r'C:\Users\file.xlsx')

for sheet in workbook.Worksheets:

    for i, shape in enumerate(sheet.Shapes):

        if shape.Name.startswith('Picture'):

            shape.Copy()

            image = ImageGrab.grabclipboard()

            image.save('{}.jpg'.format(i+1), 'jpeg')

excel.Quit()