WebTestRecorderExcel 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:
excelFindRow example
<webtest name="exceltest - find row">
<config .../>
<steps>
<invoke url="testExcel.xls"/>
<excelFindRow startRow="5" col="C" text="Total" property="totalRow"/>
...
</steps>
</webtest>
<config .../>
<steps>
<invoke url="testExcel.xls"/>
<excelFindRow startRow="5" col="C" text="Total" property="totalRow"/>
...
</steps>
</webtest>
