Excel Step excelFindRow

Description

This step allows you to find a specific row on a sheet. This is useful for using with repeat when you don't know how many rows there will be on a table. It starts from a specified cell and searches down for a row matching the given text in an Excel spreadsheet and saves the resulting row as a property.

Parameters

property

Required? yes

The name of the property in which to store the value.

text

Required? yes

The text value to search for. Will be treated as a regex if surrounded with '/'s (eg '/test\d+/')

col

Required? no

The column reference (eg. 'B' or '2') to search in.

description

Required? no

The description of this test step.

propertyType

Required? no, default is the "defaultPropertyType" as specified in the "config" element is used.

The type of the property in which to store the value. Either "ant" or "dynamic".

sheetIndex

Required? no

The index of the sheet to select, starting at zero. If no sheet is selected, the value of the last excelSelectSheet call is used, or defaults to the first sheet.

sheetName

Required? no

The name of the sheet to select. If no sheet is selected, the value of the last excelSelectSheet call is used, or defaults to the first sheet.

startRow

Required? no, default is 1

The row to start searching from

Details

Here is an example of using excelFindRow: