Images are not being read from excel file
I am using openpyxl_image_loader
to load images from an Excel sheet. My sample sheet has only 5 images but out of these 5 images only 3 are readable. I have read other questions for the same problem [here for example][1] but the solutions are not helping me.
Upon further analysis, it seems that OpenpyXL is not detecting these images to begin with. For a sample sheet with 5 images, I am only seeing 3 image outputs. Below is my code and the sample excel file's link.
fname = 'sample_2.xlsx'
sheet_name = "Sheet1"
pxl_doc = openpyxl.load_workbook(fname, data_only = True)
sheet = pxl_doc[sheet_name]
image_loader = SheetImageLoader(sheet)
sheet_images = sheet._images
for image in sheet_images:
row = image.anchor._from.row + 1
col = string.ascii_uppercase[image.anchor._from.col]
print(row, col)
I am getting the following output:
7 C
6 C
3 C
Which means that it is not able to pickup images in row 4 and 5. I have uploaded an excel file here: [https://easyupload.io/2oobz2][2]
Can someone please help me on to resolve it or maybe a work around? Thanks in advance ! [1]: https://github.com/mauricio-chavez/openpyxl-image-loader/issues/4 [2]: https://easyupload.io/2oobz2