How do I get images of an embedded cell?

[林伟明]

I want to get images from sheet, but cannot get images that embedded in cell

[Mingo Lin (Mingo)]

when i use sheet._images , only get images which not embedded in cell.how do i get images of an embedded cell?

[Michel MARTIN]

You use the openpyxl_image_loader module

from openpyxl import load_workbook
from openpyxl_image_loader import SheetImageLoader

# Load the workbook and the specific sheet
wb = load_workbook('your_file.xlsx')
ws = wb.active

# Load the images from the sheet
image_loader = SheetImageLoader(ws)

# Check if there is an image in a specific cell
if image_loader.image_in('A1'):
    # Extract the image
    img = image_loader.get('A1')
    img.save('extracted_image.png')