Error Index out of range with SheetImageLoader

87 views
Skip to first unread message

Madhvi Gupta

unread,
Jun 18, 2023, 2:54:15 AM6/18/23
to openpyxl-users
Hi All,

I am trying to SheetImageLoader to extract images from the excel sheet.

In some cases is raise an exception 

 File "C:\Users\emgupda\Anaconda3\lib\site-packages\openpyxl_image_loader\sheet_image_loader.py", line 20, in __init__
    col = string.ascii_uppercase[image.anchor._from.col+1]
IndexError: string index out of range

I am not sure the reason for same. 

I have seen  a fix while working with ImageLoader that after Z column it does not read column on the web page https://github.com/ultr4nerd/openpyxl-image-loader/issues/3


Does anybody has faced similar issue?  My excel contain around 100 plus images.

Any help is appreciated!

Regards,
Madhvi
Reply all
Reply to author
Forward
0 new messages