Canoo Webtest WebTest Canoo

Excel Step excelSelectSheet

Description

Provides the ability to select the current sheet. Any subsequent calls to excel steps will use the selected sheet if not overridden

Parameters

description
Required? no
The description of this test step.
sheetIndex
Required? yes/no
The index of the sheet to select, starting at zero. Either sheetName or sheetIndex must be selected.
sheetName
Required? yes/no
The name of the sheet to select. Either sheetName or sheetIndex must be selected.

Details

excelSelectSheet Example
<webtest name="exceltest - select sheet">
  <config .../>
  <steps>
    <invoke url="testExcel.xls"/>
    <excelSelectSheet sheetName="Sheet1"/>
    <excelVerifyCellValue cell="A1text="Sheet 1 Cell"/>
    ...
    <excelSelectSheet sheetIndex="1"/>
    <excelVerifyCellValue cell="A1text="Sheet 2 Cell"/>
    ...
  </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