I have a workbook named “Source”. Column A has list of workbook filepaths, Column B has keyword. I need UiPath to open excel by excel and check for particular keyword. How do i do that?
For example: Open file in Range A1,check for keyword in B1 and update C1 with True or false
Thanks in advance. I am beginner to UiPath hope this is the place to share knowledge and gain it. Kindly help with my question.
Thanks for the response. I tried to upload the files since being the new user i was not allowed to do that. So i am pasting the screenshots
C1 will give the result TRUE since the keyword is found the Book1.xlsx
One workbook one keyword to be found and display result
1st reading the file in which we have to update the status
ForEachRow Activity for itterating each row
As der are no column names so uncheck the Add Headers property and one by one read the 1st column in which Paths are stored for other files in which we have to search for the keyword and stored in one variable
then again read range activity of workbook by passing the path variable
Then used one Linq query for searching the keyword in the Excel files. That will return the count of that searched variable
Then used If activity to check whether count is greater than Zero. If count is greater than Zero means keyword is present in that file or else Not.
As per the True False I am writing the Cell for that particular row as TRUE/FALSE