Find Row
Find the row of excel sheet.
Find the row of the excel sheet by searching the cell value row wise and stores it in a variable.
This activity can only be used after the Open Excel File activity.
Input
Options
Column Name :
String Argument
Optional
The name of the column in which the cell value is to be found. If it not specified, the entire row will be searched.\
The column name is specified in A
format.
Index :
Integer Argument
Optional
The index of the row to be found. It is only valid when the method is At Index.\
Method :
First
- Search the first occurrence of cell content.AtIndex
- Search the cell content in specified index.All
- Search the all cell content.\
Output
Found :
Boolean Variable
The variable that stores the true value if specified cell value found in the excel sheet otherwise store false.
Last updated