How to find the name in the documents folder which are already there in excel

Help Studio
, ,
1

hi
I’ve excel file which contains the names and the folder that contains many images Untitled

image
image693×370 10.8 KB

now i need to read the excel and find the each name image from the folder and need to get the data
can anyone suggest how can this be done

2

Hi @lakshmi3 ,

Could you please be explain a bit more on the scenario? Does the image name contain the name in the excel file or do we need to extract and check the name from the image itself?

3

need the check wheather the name in the excel has any match in the images and if matches need to extract the score data from the image

data
data763×588 45.9 KB

image
image693×370 10.8 KB
!!image

4
  1. need to read the excel row by row then find the image which matches for the name in the 1st row and if the image is found the need to extract the score data from the image and the this process should continue for all the data rows in the excel
5

Hi @lakshmi3 ,

How you can match the image? Image names are random ids. On what criteria name and image name matches?

6

we do have the image id’s , i need to know how to find the match in the image folder for the name in the excel

7

Hi @lakshmi3 ,

If you have the image id which are matches with your name then you can do as the following workflow.

FilefromFolder.xaml (10.4 KB)
SampleData.xlsx (8.6 KB)
samplepics.zip (952.9 KB)