[Webtest] How to write to Excel file with CanooWebTest?

[Siegfried Goeschl]

Hi folks,

AFIAK

+) for creating EXCEL the library POI (http://jakarta.apache.org/poi/) 
is used

+) using CSV might be also an option (EXCEL uses ';' as a seperator)

Cheers,

Siegfried Goeschl



Rob Manthey wrote:
> My understanding is that Cocoon at least can be run from outside a 
> container (don't quote me on that) and it has an XML to Excel renderer.
> I recently trapped these urls using google to find material on creating 
> Excel's from within a servlet container ... you may be able to extract 
> something useful for non-container operations ...
> 
> http://cocoon.apache.org/2.1/userdocs/xls-serializer.html
> http://jakarta.apache.org/poi/hssf/quick-guide.html
> http://wldj.sys-con.com/read/185302_1.htm
> http://www.experts-exchange.com/Web/Web_Languages/JSP/Q_21899206.html
> 
> Cheers
>  Rob
> 
> on 11/07/06 06:53 Dierk Koenig said the following:
> 
>> WebTest writes all result information to WebTestResult.xml.
>> You can use all kinds of tools to extract data from there and store it 
>> into Excel, e.g. XSLT or a little Groovy script.
>