Find Cell
Find the cell of excel sheet.
Find the cell of Excel sheet with a string value and stores it in a variable.
Input
Input :
ExcelHandle Variable
A variable name that references the opened excel file handle.
Sheet Name :
String Argument
The name of the sheet in which the cell data is to be found.
Index :
Integer Argument
The index of the particular cell content from the search results.
Options
Cell Content :
String Argument
The cell content to be found.
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