Canoo Webtest WebTest Canoo

Excel Step excelStructureFilter

Description

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

Parameters

description
Required? no
The description of this test step.

Details

Here is an example of using excelStructureFilter:

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

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"
    numberOfCellStyles="270numberOfFonts="73numberOfNames="0">
    <sheets>
        <sheet defaultColumnWidth="8"
            defaultRowHeight="255firstRow="0"
            fitToPage="trueindex="0"
            lastRow="24name="Sheet1physicalRows="21"/>
        <sheet defaultColumnWidth="8"
            defaultRowHeight="255firstRow="0"
            fitToPage="trueindex="1"
            lastRow="96name="Sheet2physicalRows="96"/>
        <sheet defaultColumnWidth="8"
            defaultRowHeight="255firstRow="0"
            fitToPage="trueindex="2"
            lastRow="13name="Sheet3physicalRows="3"/>
    </sheets>
</excelWorkbook>

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