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

Tue, 11 Jul 2006 11:24:56 +1000

This is a multi-part message in MIME format.
--------------010600040101060807080108
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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.

--------------010600040101060807080108
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
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.<br>
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 ...<br>
<font color="#000000"><br>
<a class="moz-txt-link-freetext" href="http://cocoon.apache.org/2.1/userdocs/xls-serializer.html">http://cocoon.apache.org/2.1/userdocs/xls-serializer.html</a></font><br>
<font color="#000000"><a class="moz-txt-link-freetext" href="http://jakarta.apache.org/poi/hssf/quick-guide.html">http://jakarta.apache.org/poi/hssf/quick-guide.html</a><br>
<a class="moz-txt-link-freetext" href="http://wldj.sys-con.com/read/185302_1.htm">http://wldj.sys-con.com/read/185302_1.htm</a><br>
<a class="moz-txt-link-freetext" href="http://www.experts-exchange.com/Web/Web_Languages/JSP/Q_21899206.html">http://www.experts-exchange.com/Web/Web_Languages/JSP/Q_21899206.html</a><br>
<br>
Cheers<br>
&nbsp;Rob<br>
</font><br>
on 11/07/06 06:53 Dierk Koenig said the following:
<blockquote
 cite="midFDECKBKBGOHEGDCBMOMLEEEOICAA.dierk.koenig@canoo.com"
 type="cite">
  <meta http-equiv="Content-Type" content="text/html; ">
  <meta content="MSHTML 6.00.2900.2912" name="GENERATOR">
  <style></style>
  <div><span class="775354920-10072006"><font color="#0000ff"
 face="Arial" size="2">WebTest writes all result information to
WebTestResult.xml.</font></span> <br>
  </div>
  <div><span class="775354920-10072006"><font color="#0000ff"
 face="Arial" size="2">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.</font></span></div>
</blockquote>
</body>
</html>

--------------010600040101060807080108--