🔒 Reading images from an .xlsx file

[earnest chasm]

I want to read data from an .xlsx file. I have a lot of data, some cells contain images that I would like to extract somehow. It's important to know on which cell the image is placed.

I have already tried such libraries as pandas, openpyxl, and even something as auxiliary as openpyxl-image-loader

Maybe someone has worked with this type of problem? Thank you in advance for your attention

[celest canopy]

@earnest chasm

Python help channel opened

Remember to:

• Ask your Python question, not if you can ask or if there's an expert who can help.
• Show a code sample as text (rather than a screenshot) and the error message, if you've got one.
• Explain what you expect to happen and what actually happens.

:warning: Do not pip install anything that isn't related to your question, especially if asked to over DMs.

Closes after a period of inactivity, or when you send !close.

[half grail]

have u tried "pillow"?

[earnest chasm]

I think it's a problem with the data in the file itself. Because in the end I get NaN

However, I have these images

[deft otter]

It's not a problem with the file
The image is not "in" the cell
It's "on top of" the cell
The cell is empty

[austere ermine]

I probably would check on that openpyxl module you mentioned, pandas is expecting numbers most likely.

[deft otter]

I don't think Pandas can see the images

[deft otter]

What did openpyxl-image-loader show you?

[earnest chasm]

Literally nothing. I tried to call the _images attribute but got {}

[half grail]

can u send me that .xlsx so i can test out something

u can send dm

[earnest chasm]

ye

[celest canopy]

Python help channel closed

This help channel has been closed and it's no longer possible to send messages here. If your question wasn't answered, feel free to create a new post in #1035199133436354600. To maximize your chances of getting a response, check out this guide on asking good questions.