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="true" readFiltered="false" toFile="${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.0" encoding="ISO-8859-1"?>
<excelWorkbook backup="false"
    numberOfCellStyles="270" numberOfFonts="73" numberOfNames="0">
    <sheets>
        <sheet defaultColumnWidth="8"
            defaultRowHeight="255" firstRow="0"
            fitToPage="true" index="0"
            lastRow="24" name="Sheet1" physicalRows="21"/>
        <sheet defaultColumnWidth="8"
            defaultRowHeight="255" firstRow="0"
            fitToPage="true" index="1"
            lastRow="96" name="Sheet2" physicalRows="96"/>
        <sheet defaultColumnWidth="8"
            defaultRowHeight="255" firstRow="0"
            fitToPage="true" index="2"
            lastRow="13" name="Sheet3" physicalRows="3"/>
    </sheets>
</excelWorkbook>

news

Latest build: R_1705
Posted: 14-May-2008 13:13

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

WebTest 2.6 released, featuring upgrades to Ant 1.7, Groovy 1.5.4, and HtmlUnit 1.14.
The release includes support for data-driven testing, testing of drag-and-drop, advanced AJAX support, high-concurrency testing and reporting, real-time monitoring, and - as usual - lots of handling improvements.
Posted: 18 March 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