Extracting text from logo in Excel file

[Shreya_Gandhi]

Hello,

We have Excel files which is embedded with a logo (image). We need to extract the text from this image. The excel file contains other text data too, which we are extracting from usual excel activities.

Thank you
Shreya

[Srini84 (Srinivas Kadamati)]

Hi @Shreya_Gandhi

I suggest to look the below link

Excel Macro: Export All Pictures and Rename - ExcelBaby

Hope this may help you

Thanks,
Srini

[Gokul001 (Gokul Balaji)]

Hi @Shreya_Gandhi

Can you check out the thread

To Extract the text (data) from Images

Hi Hope the below steps would help you resolve this Use a build datatable activity and create a table as you need with column names and get the output as dt We can split the obtained text based on NewLine and then add them to datatable through add DataRow activity To split the string input arr_split = Split(Strinput.ToString,Environment.NewLine.ToArray()) Then use a FOR EACH activity and pass the above array variable as input and change the type argument as string Now use a IF activit…

Regards
Gokul

[Kartheek_Battu]

Hello @Shreya_Gandhi

1. Read Excel File (Excel Application Scope, Read Range, etc.)
2. Loop through Excel rows
   a. Extract the image as binary data
   b. Use OCR (Tesseract OCR) on the image binary data to get text
   c. Store the extracted text
3. Continue with other Excel data extraction as needed

Thanks & Cheers!!!

[Shreya_Gandhi]

Hi,

Since the image on our excel was not linked to any particular cell, we could not use any activities related to excel. We have written a VBA code to retrieve the image and then used OCR to extract the text.

Thank you everyone for providing your inputs.
Shreya