Excel file with multiple sheet of images. how can I iterate each sheet and fetch the text from each sheet and fill the fetched data in another sheet

uiautomation
studio

#1

Hi All,

I have an excel file with multiple sheet of images. how can I iterate each sheet and fetch the text from each sheet and need to fill the fetched data in another sheet.

Thanks in advance


#2

Hi @naga.nagiri,

Refer this post

you can get all the sheet names then you can loop through the sheet name use read range

Regards,
Arivu


#3

Hi @arivu96,

Thank you for your response,

I got the all the sheet names, now i need to read the image and get the text by sheet wise.

i tried OCR logic to get text from image, for one tab it is working not for all the tabs.

can suggest me to do any other logic to get the text from all the images by sheet wise.

Thanks,
Nagesh