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 person likes this idea

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

Simple process to search for a certain value in an Excel file and retrieve its row and column index.

run 3

Good one

Login or Signup to post a comment