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

• 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 value is to be found.

Options

• Cell Value : String Argument The cell value to be found.\

• 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

• Data Row: Object Variable The variable that stores the data row or list of data row of specified cell value found in the excel sheet.

• Found : Boolean Variable

  The variable that stores the true value if specified cell value found in the excel sheet otherwise store false.