Canoo Webtest WebTest Canoo

Excel Step excelStructureFilter


Extracts the structure of the current XLS document, as a xml file.


Required? no
The description of this test step.


Here is an example of using excelStructureFilter:

excelStructureFilter example
<webtest name="exceltest - structure filter">
  <config .../>
    <invoke url="testExcel.xls"/>
    <compareToExpected saveFiltered="truereadFiltered="falsetoFile="${expectedFile}">
      <excelStructureFilter description="extract XLS structure"/>
      <lineSeparatorFilter description="normalise line separators"/>

As a result of invoking the above steps a file would be created containing something like the following:

excelStructureFilter output
<?xml version="1.0encoding="ISO-8859-1"?>
<excelWorkbook backup="false"
        <sheet defaultColumnWidth="8"
        <sheet defaultColumnWidth="8"
        <sheet defaultColumnWidth="8"


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