Support Portal

for ProcessRobot and WinAutomation

Start a new topic

Search in Excel file

ADMIN

The attached Process searches for a certain value in an Excel file and retrieves its row and column index.


In case that value exists multiple times, then all the row and column indexes will be retrieved.


waj
1 Comment

Hello Peter, 


I love this Process, and would like to use it but I'm struggling to reverse engineer this so that:

  • All rows of one specific column are checked against a second list of values. (instead of all columns being checked)
  • If any of the second list of values match in the specific column, create new column (next to column that is being checked) and put a "Found" inline.
Thanks,
Mike

Login or Signup to post a comment