python处理excel中的图片（注意：图片在excel中不能嵌入）

from openpyxl import load_workbook
from openpyxl_image_loader import SheetImageLoader

lis = []
def test(x):
    ws = load_workbook(x).worksheets[0]
    image_load = SheetImageLoader(ws)
    for index, row in enumerate(ws.rows, start=1):
        if image_load.image_in(f'C{index}'):
            image = image_load.get(f'C{index}')
            name = row[0].value
            if '\n' in name:
                name = name.split('\n')[0]
            lis.append(name)
            image.save('D:/photo/' + name + '.png')