[Webtest] How to test an Excel content when the format is not Binary Excel?

Koorosh Vakhshoori Koorosh Vakhshoori" <Koorosh.Vakhshoori@synopsys.com
Fri, 4 May 2007 11:24:20 -0700


This is a multi-part message in MIME format.

------_=_NextPart_001_01C78E79.6EAD4A56
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi guys,

  I need your advice. I have a web application which when I click on
submit button generates content which is HTML format but the returned
content type is set to 'application/vnd.ms-excel'. The idea is to have
the browser treat the down loaded content as Excel and forward it to
Excel which would read and display it. The application works as
expected, of course only on Windows or on any platform that have an
Excel compatible application which supports reading HTML format. Now
understand this limitation and we are fine with it. However, when I use
the WebTest Excel steps to validate the generated content, I get the
following error:

=20

Invalid header signature; read 723401728380766730, expected
-2226271756974174256

=20

The stack trace is:

=20

java.io.IOException: Invalid header signature; read 723401728380766730,
expected -2226271756974174256
        at
org.apache.poi.poifs.storage.HeaderBlockReader.<init>(HeaderBlockReader.
java:88)
        at
org.apache.poi.poifs.filesystem.POIFSFileSystem.<init>(POIFSFileSystem.j
ava:83)
        at
com.canoo.webtest.plugins.exceltest.RetryWithCapsPOIFSFileSystem.<init>(
RetryWithCapsPOIFSFileSystem.java:22)
        at
com.canoo.webtest.plugins.exceltest.AbstractExcelStep.createWorkbook(Abs
tractExcelStep.java:60)
        at
com.canoo.webtest.plugins.exceltest.AbstractExcelStep.getExcelWorkbook(A
bstractExcelStep.java:42)
        at
com.canoo.webtest.plugins.exceltest.AbstractExcelSheetStep.getExcelSheet
(AbstractExcelSheetStep.java:22)
        at
com.canoo.webtest.plugins.exceltest.ExcelCellUtils.getExcelCellAt(ExcelC
ellUtils.java:23)
        at
com.canoo.webtest.plugins.exceltest.AbstractExcelCellStep.getExcelCell(A
bstractExcelCellStep.java:70)
        at
com.canoo.webtest.plugins.exceltest.AbstractExcelCellStep.getCellValue(A
bstractExcelCellStep.java:74)
        at
com.canoo.webtest.plugins.exceltest.ExcelStoreCellValue.doExecute(ExcelS
toreCellValue.java:48)
        at com.canoo.webtest.steps.Step.execute(Step.java:104)
        at
org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
        at org.apache.tools.ant.Task.perform(Task.java:364)
        at
com.canoo.webtest.ant.TestStepSequence.executeSteps(TestStepSequence.jav
a:43)
        at
com.canoo.webtest.ant.TestStepSequence.doExecute(TestStepSequence.java:3
1)
        at com.canoo.webtest.steps.Step.execute(Step.java:104)
        at org.apache.tools.ant.Task.perform(Task.java:364)
        at
com.canoo.webtest.ant.WebtestTask.execute(WebtestTask.java:164)
        at
org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
        at org.apache.tools.ant.Task.perform(Task.java:364)
        at org.apache.tools.ant.Target.execute(Target.java:341)
        at org.apache.tools.ant.Target.performTasks(Target.java:369)
        at
org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
        at
org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleChe
ckExecutor.java:37)
        at
org.apache.tools.ant.Project.executeTargets(Project.java:1068)
        at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:382)
        at
org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
        at org.apache.tools.ant.Task.perform(Task.java:364)
        at org.apache.tools.ant.Target.execute(Target.java:341)
        at org.apache.tools.ant.Target.performTasks(Target.java:369)
        at
org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
        at
org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleChe
ckExecutor.java:37)
        at
org.apache.tools.ant.Project.executeTargets(Project.java:1068)
        at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:382)
        at
org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:107)
        at
org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
        at org.apache.tools.ant.Task.perform(Task.java:364)
        at org.apache.tools.ant.Target.execute(Target.java:341)
        at org.apache.tools.ant.Target.performTasks(Target.java:369)
        at
org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
        at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
        at
org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecut
or.java:40)
        at
org.apache.tools.ant.Project.executeTargets(Project.java:1068)
        at org.apache.tools.ant.Main.runBuild(Main.java:668)
        at org.apache.tools.ant.Main.startAnt(Main.java:187)
        at org.apache.tools.ant.launch.Launcher.run(Launcher.java:246)
        at org.apache.tools.ant.launch.Launcher.main(Launcher.java:67)

=20

After some investigation, I have identify the source to be Jakarta POI,
which WebTest Excel step uses to read the Excel content where it only
expects to see binary Excel format and not HTML. This is how Jakarta POI
works and I am not expecting them to change it, but in the Web context a
browser looks at the content type and passes the control to the
application that is registered to handle such content. In this case, as
I mentioned before it would pass it to Excel where it sees the HTML
content and would parse it as such and displays it in Excel context. Now
could anyone suggestions a way to write my WebTest so it would test the
generated content?

=20

Thanks,
Koorosh

=20

=20

=20

=20

=20


------_=_NextPart_001_01C78E79.6EAD4A56
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<style>
<!--
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman";}
h1
	{margin-top:12.0pt;
	margin-right:0in;
	margin-bottom:3.0pt;
	margin-left:0in;
	page-break-after:avoid;
	font-size:16.0pt;
	font-family:Arial;}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{color:purple;
	text-decoration:underline;}
pre
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:10.0pt;
	font-family:"Courier New";}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:Arial;
	color:windowtext;}
@page Section1
	{size:8.5in 11.0in;
	margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
	{page:Section1;}
-->
</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Hi guys,<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&nbsp; I need your advice. I have a web application =
which
when I click on submit button generates content which is HTML format but =
the
returned content type is set to &#8216;<i><span =
style=3D'font-style:italic'>application/vnd.ms-excel&#8217;</span></i>.
The idea is to have the browser treat the down loaded content as Excel =
and
forward it to Excel which would read and display it. The application =
works as
expected, of course only on Windows or on any platform that have an =
Excel
compatible application which supports reading HTML format. Now =
understand this limitation
and we are fine with it. However, when I use the WebTest Excel steps to =
validate
the generated content, I get the following =
error:<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN =
style=3D'font-size:10.0pt;
font-family:Arial'>Invalid header signature; read 723401728380766730, =
expected
-2226271756974174256<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN =
style=3D'font-size:10.0pt;
font-family:Arial'>The stack trace is:<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<pre><font size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>java.io.IOException: Invalid header =
signature; read 723401728380766730, expected =
-2226271756974174256<o:p></o:p></span></font></pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
org.apache.poi.poifs.storage.HeaderBlockReader.&lt;init&gt;(HeaderBlockRe=
ader.java:88)<o:p></o:p></span></font></pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
org.apache.poi.poifs.filesystem.POIFSFileSystem.&lt;init&gt;(POIFSFileSys=
tem.java:83)<o:p></o:p></span></font></pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
com.canoo.webtest.plugins.exceltest.RetryWithCapsPOIFSFileSystem.&lt;init=
&gt;(RetryWithCapsPOIFSFileSystem.java:22)<o:p></o:p></span></font></pre>=
<pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
com.canoo.webtest.plugins.exceltest.AbstractExcelStep.createWorkbook(Abst=
ractExcelStep.java:60)<o:p></o:p></span></font></pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
com.canoo.webtest.plugins.exceltest.AbstractExcelStep.getExcelWorkbook(Ab=
stractExcelStep.java:42)<o:p></o:p></span></font></pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
com.canoo.webtest.plugins.exceltest.AbstractExcelSheetStep.getExcelSheet(=
AbstractExcelSheetStep.java:22)<o:p></o:p></span></font></pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
com.canoo.webtest.plugins.exceltest.ExcelCellUtils.getExcelCellAt(ExcelCe=
llUtils.java:23)<o:p></o:p></span></font></pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
com.canoo.webtest.plugins.exceltest.AbstractExcelCellStep.getExcelCell(Ab=
stractExcelCellStep.java:70)<o:p></o:p></span></font></pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
com.canoo.webtest.plugins.exceltest.AbstractExcelCellStep.getCellValue(Ab=
stractExcelCellStep.java:74)<o:p></o:p></span></font></pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
com.canoo.webtest.plugins.exceltest.ExcelStoreCellValue.doExecute(ExcelSt=
oreCellValue.java:48)<o:p></o:p></span></font></pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
com.canoo.webtest.steps.Step.execute(Step.java:104)<o:p></o:p></span></fo=
nt></pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)<o:p>=
</o:p></span></font></pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
org.apache.tools.ant.Task.perform(Task.java:364)<o:p></o:p></span></font>=
</pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
com.canoo.webtest.ant.TestStepSequence.executeSteps(TestStepSequence.java=
:43)<o:p></o:p></span></font></pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
com.canoo.webtest.ant.TestStepSequence.doExecute(TestStepSequence.java:31=
)<o:p></o:p></span></font></pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
com.canoo.webtest.steps.Step.execute(Step.java:104)<o:p></o:p></span></fo=
nt></pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
org.apache.tools.ant.Task.perform(Task.java:364)<o:p></o:p></span></font>=
</pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
com.canoo.webtest.ant.WebtestTask.execute(WebtestTask.java:164)<o:p></o:p=
></span></font></pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)<o:p>=
</o:p></span></font></pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
org.apache.tools.ant.Task.perform(Task.java:364)<o:p></o:p></span></font>=
</pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
org.apache.tools.ant.Target.execute(Target.java:341)<o:p></o:p></span></f=
ont></pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
org.apache.tools.ant.Target.performTasks(Target.java:369)<o:p></o:p></spa=
n></font></pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)<o:p>=
</o:p></span></font></pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleChec=
kExecutor.java:37)<o:p></o:p></span></font></pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
org.apache.tools.ant.Project.executeTargets(Project.java:1068)<o:p></o:p>=
</span></font></pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:382)<o:p></o:p></span>=
</font></pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)<o:p>=
</o:p></span></font></pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
org.apache.tools.ant.Task.perform(Task.java:364)<o:p></o:p></span></font>=
</pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
org.apache.tools.ant.Target.execute(Target.java:341)<o:p></o:p></span></f=
ont></pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
org.apache.tools.ant.Target.performTasks(Target.java:369)<o:p></o:p></spa=
n></font></pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)<o:p>=
</o:p></span></font></pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleChec=
kExecutor.java:37)<o:p></o:p></span></font></pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
org.apache.tools.ant.Project.executeTargets(Project.java:1068)<o:p></o:p>=
</span></font></pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:382)<o:p></o:p></span>=
</font></pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:107)<o:p=
></o:p></span></font></pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)<o:p>=
</o:p></span></font></pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
org.apache.tools.ant.Task.perform(Task.java:364)<o:p></o:p></span></font>=
</pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
org.apache.tools.ant.Target.execute(Target.java:341)<o:p></o:p></span></f=
ont></pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
org.apache.tools.ant.Target.performTasks(Target.java:369)<o:p></o:p></spa=
n></font></pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)<o:p>=
</o:p></span></font></pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
org.apache.tools.ant.Project.executeTarget(Project.java:1185)<o:p></o:p><=
/span></font></pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecuto=
r.java:40)<o:p></o:p></span></font></pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
org.apache.tools.ant.Project.executeTargets(Project.java:1068)<o:p></o:p>=
</span></font></pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
org.apache.tools.ant.Main.runBuild(Main.java:668)<o:p></o:p></span></font=
></pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
org.apache.tools.ant.Main.startAnt(Main.java:187)<o:p></o:p></span></font=
></pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
org.apache.tools.ant.launch.Launcher.run(Launcher.java:246)<o:p></o:p></s=
pan></font></pre><pre><font
size=3D2 face=3D"Courier New"><span lang=3DEN =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at =
org.apache.tools.ant.launch.Launcher.main(Launcher.java:67)<o:p></o:p></s=
pan></font></pre>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>After some investigation, I have identify the source =
to be <b><span
style=3D'font-weight:bold'>Jakarta POI</span></b>, which WebTest Excel =
step uses
to read the Excel content where it only expects to see binary Excel =
format and
not HTML. This is how Jakarta POI works and I am not expecting them to =
change
it, but in the Web context a browser looks at the content type and =
passes the
control to the application that is registered to handle such content. In =
this
case, as I mentioned before it would pass it to Excel where it sees the =
HTML
content and would parse it as such and displays it in Excel context. Now =
could anyone
suggestions a way to write my WebTest so it would test the generated =
content?<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Thanks,<br>
Koorosh<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:
10.0pt'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:
10.0pt'>&nbsp;<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>&nbsp;<o:p></o:p></span></font></p>

</div>

</body>

</html>

------_=_NextPart_001_01C78E79.6EAD4A56--