Excel to find keyword in another workbook and update result in another workbook

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

image

Thanks in advance. I am beginner to UiPath hope this is the place to share knowledge and gain it. Kindly help with my question.

Hi @nraaja4

If you provide those all files then it will be easy to give you perfect solution for the same.

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

Hi @Pratik_Wavhal

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

Hi @nraaja4

Below is the workflow for the same :-
MainPratik.xaml (12.3 KB)
Main.xlsx (8.6 KB)
Book1.xlsx (9.0 KB)
Book2.xlsx (9.1 KB)

Mark as solution and like it :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

1 Like

Thankyou so much @Pratik_Wavhal It works perfectly the same way. :hugs:

From the learning perspective can you brief me how you made it

Hi @nraaja4

  1. 1st reading the file in which we have to update the status
  2. ForEachRow Activity for itterating each row
  3. 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
  4. then again read range activity of workbook by passing the path variable
  5. Then used one Linq query for searching the keyword in the Excel files. That will return the count of that searched variable
  6. 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.
  7. As per the True False I am writing the Cell for that particular row as TRUE/FALSE

Thats it.

Mark as solution and like it :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

Thanks again @Pratik_Wavhal

Learned something today and you made my day!.

Hi @nraaja4

You are welcome :sunny:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.