Find Cell
Find the cell of excel sheet.
Find the cell of Excel sheet with a string value and stores it in a variable.
This activity can only be used after the Open Excel File activity.
Input
Index :
Integer Argument
The index of the particular cell content from the search results.
Options
Method :
ByRow
- Find the cell by searching rows.Default
ByColumn
- Find the cell by searching columns.
Mode :
First
- Search the first occurrence of cell content.Default
AtIndex
- Search matching cell contents and return the cell name of the specified index from the search results.All
- Search all cell content.
Output
Output :
Object Variable
The variable that stores the cell name or list of cell names of specified cell data found in the excel sheet.
Last updated