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

• 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.