Not able to extract image file stored in a cell to the tests where I need to attach that image

Asked Feb 24 '23 at 07:31

Active Feb 24 '23 at 07:31

Viewed 48 times

Following is the code I'm using to extract the image stored in G7 cell:

def getImageAttachment():
    ExcelBook = openpyxl.load_workbook("F:\\MSL Automation Framework\\msl.test\\TestDataExcel.xlsx")
    sheet = ExcelBook.active
    image_loader = SheetImageLoader(sheet)
    image = image_loader.get('G7')
    test_ImageAttachment = [{sheet['G6'].value: image}]
    return test_ImageAttachment

But TypeError: object of type 'JpegImageFile' has no len() error is thrown when running the test. Screenshot is attached below:

Below is the screenshot attached to demonstrate image stored in G7 cell:

Please help me out. I don't want to provide image path directly to avoid hard coding and want to get the image from excel sheet.

asked Feb 24 '23 at 07:31

deepak thakur

Does this answer your question? [Python cant read file TypeError: object of type 'file' has no len()](https://stackoverflow.com/questions/28629536/python-cant-read-file-typeerror-object-of-type-file-has-no-len) – Srinivasu Kaki Feb 24 '23 at 10:50
No @SrinivasuKaki – deepak thakur Feb 24 '23 at 12:20
Are all your imported packages up to date? – moken Feb 26 '23 at 10:38
Yes, they are @moken – deepak thakur Feb 27 '23 at 05:20
Looks like a jpeg image which is anchored at G7 but can't see any reason for the error in code. I cannot duplicate your issue but I don't know the specifics of your sheet/image that may be causing the issue. – moken Feb 27 '23 at 06:21

Not able to extract image file stored in a cell to the tests where I need to attach that image

0 Answers0