Canoo Webtest WebTest Canoo

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:

excelFindRow example
<webtest name="exceltest - find row">
  <config .../>
  <steps>
    <invoke url="testExcel.xls"/>
    <excelFindRow startRow="5col="Ctext="Totalproperty="totalRow"/>
    ...
  </steps>
</webtest>

news

Latest build: development
Posted: 19-Jul-2016 17:36

WebTest 3.0 released, featuring upgrades to Java 5, Groovy 1.6, and HtmlUnit 2.4.
The release includes support for maven integration, IDE-integration like for unit tests, capturing of background JavaScript errors, new steps for mouseOver and mouseOut events, better parallel execution of tests and - as usual - lots of handling improvements.
Posted: 5 March 2009

WebTest @ JavaOne
Dierk König presented "Functional testing of web applications: scaling with Java" on Wed May 7, 13:30 at JavaOne 2008 in the Tools and Scripting Languages track.
Posted: 8 May 2008

New WebTest screencast available:
Data Driven WebTest
Posted: 13 November 2007

First WebTest screencast available:
Creating a first Webtest Project

Extend WebTest with Groovy! Groovy in Action is available in every good bookstore.
Groovy in Action
Posted: 29 January 2007