Webtest WebTest GitHub Home

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>