RE: RE: Excel steps and mime type

Martin Huber <[email protected]> Thu, 26 Jun 2014 09:44:48 +0200 (CEST)
Newsgroups gmane.comp.web.canoo.webtest
Message-ID <[email protected]>
This is a multipart message in MIME format.

------=_NextPart_000_002D_01CF9123.44618B80
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi David,



just an idea:

the information about what file extensions belong to what mime type
usually are somewhere in the OS setup. I could imagine that these also ar=
e
honoured by the jvm.

So if you are using Windows you probably will have to check in the Window=
s
Registry, if there is some mapping from .xls files to
application/octet-stream instead of to application/vnd.ms-excel .

The CI is running on an old Linux system, there the mapping may be
different. I don't know what the correct mapping should be, but
application/octet-stream normally is used for binary files that just
should be downloaded w/o any closer information about its type.



Cheers,

Martin





From: [email protected] [mailto:[email protected]=
]
On Behalf Of David Jehoul
Sent: Mittwoch, 25. Juni 2014 09:57
To: [email protected]; Habbert, Michael (Key-Work)
Subject: [Webtest] RE: Excel steps and mime type



Hi Michael,



Actually, the file is a .gz file that is fetched from the server. Then it
is locally unzipped to result in a .csv file. After that, the .csv is
converted to a .xls with this tool:
http://www.softinterface.com/Convert-XLS/Features/Convert-CSV-To-XLS.htm.



However, when I create a simple test and use the testExcel.xls file that
is used in the Webtest self tests, I get the same problem. Here are the
resulting steps:




<file:///C:\testScripts\testOutput\20140625_093546\001_FT8530101\WebTestR=
e
port.xml> <step taskName=3D"invoke" result=3D"completed" duration=3D"10"
description=3D"openFile(String) on screen WebPage" _line=3D"439"
_filename=3D"c:\testScripts\tests\FT853.01-01.xml">

<parameter value=3D"file://C:/testScripts/testOutput/testExcel.xls
<file:///C:\testScripts\testOutput\testExcel.xls> " name=3D"url"/>

<resultFile name=3D"004_response_invoke.xls"/>

</step>


<file:///C:\testScripts\testOutput\20140625_093546\001_FT8530101\WebTestR=
e
port.xml> <step taskName=3D"excelFindRow" result=3D"failed" duration=3D"1=
"
_line=3D"449" _filename=3D"c:\testScripts\tests\FT853.01-01.xml">

<parameter value=3D"BR" name=3D"col"/>

<parameter value=3D"Rownr" name=3D"property"/>

<parameter value=3D"Y" name=3D"text"/>

</step>



And the result is:

c:\testScripts\tests\FT853.01-01.xml:449: File does not have correct
content type (not a '.xls' file?): application/octet-stream, Step:
ExcelFindRow at c:\testScripts\tests\FT853.01-01.xml:449:  with
(taskName=3D"excelFindRow")



So I actually don=92t understand why the selftests were successful wherea=
s
on my system, that a similar test with the same excel file does not work.

I really hope you can help me because Canoo is under pressure already
because of the inability of html unit to work with the latest JQuery =85.



Thanks!

David

From: [email protected] [mailto:[email protected]=
]
On Behalf Of Habbert, Michael (Key-Work)
Sent: woensdag 25 juni 2014 8:19
To: [email protected]
Subject: [Webtest] AW: Excel steps and mime type



Dear David,



we do have some tests with excel-Download and analyse =85



The content type changed as far as I remember with different
excel-versions.

What kind of content type do you get by manual testing with a browser (IE
and Firefox)?



Greetings



Michael Habbert





Michael Habbert
Key-Work Consulting GmbH | Kriegsstr. 100 | 76133 Karlsruhe | Germany |
www.key-work.de
Fon: +49-721-78203-269 | E-Mail: [email protected] | Fax:
+49-721-78203-10

Key-Work Consulting GmbH, Karlsruhe, HRB 108695, HRG Mannheim
Gesch=E4ftsf=FChrer: Andreas Stappert, Tobin Wotring

Von: [email protected] [mailto:[email protected]]
Im Auftrag von David Jehoul
Gesendet: Montag, 23. Juni 2014 14:35
An: [email protected]; David Jehoul
Betreff: [Webtest] RE: Excel steps and mime type



I even tried it with the excel file that I found in the self test report
on the Canoo webtest website. But that gives the same problem. I tried it
with several browsers, but ended up with the same problem. I tried with
build 1823 an 1825. Same problem =85



From: [email protected] [mailto:[email protected]=
]
On Behalf Of David Jehoul
Sent: maandag 23 juni 2014 13:56
To: [email protected]
Subject: [Webtest] Excel steps and mime type



Hi,



We want to start to use some excel steps.

The first problem I have is that the format of a normal excel file seems
to be not supported.

This is the error message I get when I use the excelFindRow task:



File does not have correct content type (not a '.xls' file?):
application/octet-stream



I read here: http://lists.canoo.com/pipermail/webtest/2008q3/010837.html
that the expected format would be application/vnd.ms-excel, but when I
manually create the xls file, I still get the same error message.

Does anybody have experience in this matter?

Thanks!
David




------=_NextPart_000_002D_01CF9123.44618B80
Content-Type: text/html;
	charset="iso-8859-1"
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:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns=3D"http://www.w3.org/TR/REC-html40"><head><meta =
http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1"><meta name=3DGenerator content=3D"Microsoft Word =
14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
	{font-family:Tahoma;
	panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
	{font-family:Consolas;
	panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Calibri","sans-serif";
	mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:purple;
	text-decoration:underline;}
pre
	{mso-style-priority:99;
	mso-style-link:"HTML Preformatted Char";
	margin:0cm;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Calibri","sans-serif";
	mso-fareast-language:EN-US;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
	{mso-style-priority:99;
	mso-style-link:"Balloon Text Char";
	margin:0cm;
	margin-bottom:.0001pt;
	font-size:8.0pt;
	font-family:"Tahoma","sans-serif";
	mso-fareast-language:EN-US;}
span.HTMLPreformattedChar
	{mso-style-name:"HTML Preformatted Char";
	mso-style-priority:99;
	mso-style-link:"HTML Preformatted";
	font-family:"Courier New";
	mso-fareast-language:NL-BE;}
span.BalloonTextChar
	{mso-style-name:"Balloon Text Char";
	mso-style-priority:99;
	mso-style-link:"Balloon Text";
	font-family:"Tahoma","sans-serif";
	mso-fareast-language:EN-US;}
span.HTMLVorformatiertZchn
	{mso-style-name:"HTML Vorformatiert Zchn";
	mso-style-priority:99;
	mso-style-link:"HTML Vorformatiert";
	font-family:Consolas;
	mso-fareast-language:EN-US;}
p.HTMLVorformatiert, li.HTMLVorformatiert, div.HTMLVorformatiert
	{mso-style-name:"HTML Vorformatiert";
	mso-style-link:"HTML Vorformatiert Zchn";
	margin:0cm;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Calibri","sans-serif";
	mso-fareast-language:EN-US;}
span.EmailStyle23
	{mso-style-type:personal;
	font-family:"Calibri","sans-serif";
	color:windowtext;}
span.EmailStyle24
	{mso-style-type:personal;
	font-family:"Calibri","sans-serif";
	color:#1F497D;}
span.EmailStyle25
	{mso-style-type:personal;
	font-family:"Calibri","sans-serif";
	color:#1F497D;}
span.EmailStyle26
	{mso-style-type:personal;
	font-family:"Calibri","sans-serif";
	color:#1F497D;}
span.block
	{mso-style-name:block;}
span.EmailStyle29
	{mso-style-type:personal-reply;
	font-family:"Calibri","sans-serif";
	color:#1F497D;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-size:10.0pt;}
@page WordSection1
	{size:612.0pt 792.0pt;
	margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]--></head><body lang=3DDE-CH link=3Dblue =
vlink=3Dpurple><div class=3DWordSection1><p class=3DMsoNormal><span =
style=3D'font-size:12.0pt;color:#1F497D'>Hi =
David,<o:p></o:p></span></p><p class=3DMsoNormal><span =
style=3D'font-size:12.0pt;color:#1F497D'><o:p>&nbsp;</o:p></span></p><p =
class=3DMsoNormal><span style=3D'font-size:12.0pt;color:#1F497D'>just an =
idea:<o:p></o:p></span></p><p class=3DMsoNormal><span lang=3DEN-GB =
style=3D'font-size:12.0pt;color:#1F497D'>the information about what file =
extensions belong to what mime type usually are somewhere in the OS =
setup. I could imagine that these also are honoured by the =
jvm.<o:p></o:p></span></p><p class=3DMsoNormal><span lang=3DEN-GB =
style=3D'font-size:12.0pt;color:#1F497D'>So if you are using Windows you =
probably will have to check in the Windows Registry, if there is some =
mapping from .xls files to application/octet-stream instead of to =
application/vnd.ms-excel .<o:p></o:p></span></p><p =
class=3DMsoNormal><span lang=3DEN-GB =
style=3D'font-size:12.0pt;color:#1F497D'>The CI is running on an old =
Linux system, there the mapping may be different. I don't know what the =
correct mapping should be, but application/octet-stream normally is used =
for binary files that just should be downloaded w/o any closer =
information about its type. <o:p></o:p></span></p><p =
class=3DMsoNormal><span lang=3DEN-GB =
style=3D'font-size:12.0pt;color:#1F497D'><o:p>&nbsp;</o:p></span></p><p =
class=3DMsoNormal><span lang=3DEN-GB =
style=3D'font-size:12.0pt;color:#1F497D'>Cheers,<o:p></o:p></span></p><p =
class=3DMsoNormal><span lang=3DEN-GB =
style=3D'font-size:12.0pt;color:#1F497D'>Martin<o:p></o:p></span></p><p =
class=3DMsoNormal><span lang=3DEN-GB =
style=3D'font-size:12.0pt;color:#1F497D'><o:p>&nbsp;</o:p></span></p><p =
class=3DMsoNormal><a name=3D"_MailEndCompose"><span lang=3DEN-GB =
style=3D'font-size:12.0pt;color:#1F497D'><o:p>&nbsp;</o:p></span></a></p>=
<div><div style=3D'border:none;border-top:solid #B5C4DF =
1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=3DMsoNormal><b><span =
lang=3DEN-US =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-l=
anguage:DE-CH'>From:</span></b><span lang=3DEN-US =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-l=
anguage:DE-CH'> [email protected] =
[mailto:[email protected]] <b>On Behalf Of </b>David =
Jehoul<br><b>Sent:</b> Mittwoch, 25. Juni 2014 09:57<br><b>To:</b> =
[email protected]; Habbert, Michael (Key-Work)<br><b>Subject:</b> =
[Webtest] RE: Excel steps and mime =
type<o:p></o:p></span></p></div></div><p =
class=3DMsoNormal><o:p>&nbsp;</o:p></p><p class=3DMsoNormal><span =
lang=3DNL-BE style=3D'color:#1F497D'>Hi Michael,<o:p></o:p></span></p><p =
class=3DMsoNormal><span lang=3DNL-BE =
style=3D'color:#1F497D'><o:p>&nbsp;</o:p></span></p><p =
class=3DMsoNormal><span lang=3DEN-US style=3D'color:#1F497D'>Actually, =
the file is a .gz file that is fetched from the server. Then it is =
locally unzipped to result in a .csv file. After that, the .csv is =
converted to a .xls with this tool: <a =
href=3D"http://www.softinterface.com/Convert-XLS/Features/Convert-CSV-To-=
XLS.htm">http://www.softinterface.com/Convert-XLS/Features/Convert-CSV-To=
-XLS.htm</a>.<o:p></o:p></span></p><p class=3DMsoNormal><span =
lang=3DEN-US style=3D'color:#1F497D'><o:p>&nbsp;</o:p></span></p><p =
class=3DMsoNormal><span lang=3DEN-US style=3D'color:#1F497D'>However, =
when I create a simple test and use the testExcel.xls file that is used =
in the Webtest self tests, I get the same problem. Here are the =
resulting steps:<o:p></o:p></span></p><p class=3DMsoNormal><span =
lang=3DEN-US style=3D'color:#1F497D'><o:p>&nbsp;</o:p></span></p><p =
class=3DMsoNormal><span lang=3DNL-BE><a =
href=3D"file:///C:\testScripts\testOutput\20140625_093546\001_FT8530101\W=
ebTestReport.xml"><span lang=3DEN-US>&lt;</span><span lang=3DEN-US =
style=3D'color:#990000'>step</span><span lang=3DEN-US> </span><span =
lang=3DEN-US style=3D'color:#990000'>taskName</span><span =
lang=3DEN-US>=3D&quot;</span><b><span lang=3DEN-US =
style=3D'color:black'>invoke</span></b><span lang=3DEN-US>&quot; =
</span><span lang=3DEN-US style=3D'color:#990000'>result</span><span =
lang=3DEN-US>=3D&quot;</span><b><span lang=3DEN-US =
style=3D'color:black'>completed</span></b><span lang=3DEN-US>&quot; =
</span><span lang=3DEN-US style=3D'color:#990000'>duration</span><span =
lang=3DEN-US>=3D&quot;</span><b><span lang=3DEN-US =
style=3D'color:black'>10</span></b><span lang=3DEN-US>&quot; =
</span><span lang=3DEN-US =
style=3D'color:#990000'>description</span><span =
lang=3DEN-US>=3D&quot;</span><b><span lang=3DEN-US =
style=3D'color:black'>openFile(String) on screen WebPage</span></b><span =
lang=3DEN-US>&quot; </span><span lang=3DEN-US =
style=3D'color:#990000'>_line</span><span =
lang=3DEN-US>=3D&quot;</span><b><span lang=3DEN-US =
style=3D'color:black'>439</span></b><span lang=3DEN-US>&quot; =
</span><span lang=3DEN-US style=3D'color:#990000'>_filename</span><span =
lang=3DEN-US>=3D&quot;</span><b><span lang=3DEN-US =
style=3D'color:black'>c:\testScripts\tests\FT853.01-01.xml</span></b><spa=
n lang=3DEN-US>&quot;&gt;</span></a><o:p></o:p></span></p><p =
class=3DMsoNormal style=3D'text-indent:35.4pt'><span =
lang=3DEN-US>&lt;<span style=3D'color:#990000'>parameter</span> <span =
style=3D'color:#990000'>value</span>=3D&quot;<b><span =
style=3D'color:black'><a =
href=3D"file:///C:\testScripts\testOutput\testExcel.xls">file://C:/testSc=
ripts/testOutput/testExcel.xls</a></span></b>&quot; <span =
style=3D'color:#990000'>name</span>=3D&quot;<b><span =
style=3D'color:black'>url</span></b>&quot;/&gt;<o:p></o:p></span></p><p =
class=3DMsoNormal style=3D'text-indent:35.4pt'><span =
lang=3DEN-US>&lt;<span style=3D'color:#990000'>resultFile</span> <span =
style=3D'color:#990000'>name</span>=3D&quot;<b><span =
style=3D'color:black'>004_response_invoke.xls</span></b>&quot;/&gt;<o:p><=
/o:p></span></p><p class=3DMsoNormal><span class=3Dblock><span =
lang=3DEN-US style=3D'color:blue'>&lt;/</span></span><span =
class=3Dblock><span lang=3DEN-US =
style=3D'color:#990000'>step</span></span><span class=3Dblock><span =
lang=3DEN-US style=3D'color:blue'>&gt;</span><span =
style=3D'color:blue'><o:p></o:p></span></span></p><p =
class=3DMsoNormal><span lang=3DNL-BE><a =
href=3D"file:///C:\testScripts\testOutput\20140625_093546\001_FT8530101\W=
ebTestReport.xml"><span lang=3DEN-US>&lt;</span><span lang=3DEN-US =
style=3D'color:#990000'>step</span><span lang=3DEN-US> </span><span =
lang=3DEN-US style=3D'color:#990000'>taskName</span><span =
lang=3DEN-US>=3D&quot;</span><b><span lang=3DEN-US =
style=3D'color:black'>excelFindRow</span></b><span lang=3DEN-US>&quot; =
</span><span lang=3DEN-US style=3D'color:#990000'>result</span><span =
lang=3DEN-US>=3D&quot;</span><b><span lang=3DEN-US =
style=3D'color:black'>failed</span></b><span lang=3DEN-US>&quot; =
</span><span lang=3DEN-US style=3D'color:#990000'>duration</span><span =
lang=3DEN-US>=3D&quot;</span><b><span lang=3DEN-US =
style=3D'color:black'>1</span></b><span lang=3DEN-US>&quot; </span><span =
lang=3DEN-US style=3D'color:#990000'>_line</span><span =
lang=3DEN-US>=3D&quot;</span><b><span lang=3DEN-US =
style=3D'color:black'>449</span></b><span lang=3DEN-US>&quot; =
</span><span lang=3DEN-US style=3D'color:#990000'>_filename</span><span =
lang=3DEN-US>=3D&quot;</span><b><span lang=3DEN-US =
style=3D'color:black'>c:\testScripts\tests\FT853.01-01.xml</span></b><spa=
n lang=3DEN-US>&quot;&gt;</span></a></span><o:p></o:p></p><p =
class=3DMsoNormal style=3D'text-indent:35.4pt'><span =
lang=3DEN-US>&lt;<span style=3D'color:#990000'>parameter</span> <span =
style=3D'color:#990000'>value</span>=3D&quot;<b><span =
style=3D'color:black'>BR</span></b>&quot; <span =
style=3D'color:#990000'>name</span>=3D&quot;<b><span =
style=3D'color:black'>col</span></b>&quot;/&gt;<o:p></o:p></span></p><p =
class=3DMsoNormal style=3D'text-indent:35.4pt'><span =
lang=3DEN-US>&lt;<span style=3D'color:#990000'>parameter</span> <span =
style=3D'color:#990000'>value</span>=3D&quot;<b><span =
style=3D'color:black'>Rownr</span></b>&quot; <span =
style=3D'color:#990000'>name</span>=3D&quot;<b><span =
style=3D'color:black'>property</span></b>&quot;/&gt;<o:p></o:p></span></p=
><p class=3DMsoNormal style=3D'text-indent:35.4pt'><span =
lang=3DEN-US>&lt;<span style=3D'color:#990000'>parameter</span> <span =
style=3D'color:#990000'>value</span>=3D&quot;<b><span =
style=3D'color:black'>Y</span></b>&quot; <span =
style=3D'color:#990000'>name</span>=3D&quot;<b><span =
style=3D'color:black'>text</span></b>&quot;/&gt;<o:p></o:p></span></p><p =
class=3DMsoNormal><span class=3Dblock><span lang=3DEN-US =
style=3D'color:blue'>&lt;/</span></span><span class=3Dblock><span =
lang=3DEN-US style=3D'color:#990000'>step</span></span><span =
class=3Dblock><span lang=3DEN-US style=3D'color:blue'>&gt;</span><span =
style=3D'color:blue'><o:p></o:p></span></span></p><p =
class=3DMsoNormal><span =
style=3D'color:#1F497D'><o:p>&nbsp;</o:p></span></p><p =
class=3DMsoNormal><span lang=3DEN-US style=3D'color:#1F497D'>And the =
result is:<o:p></o:p></span></p><p class=3DMsoNormal><span lang=3DEN-US =
style=3D'font-size:10.0pt;font-family:"Courier =
New";mso-fareast-language:NL-BE'>c:\testScripts\tests\FT853.01-01.xml:449=
: File does not have correct content type (not a '.xls' file?): =
application/octet-stream, Step: ExcelFindRow at =
c:\testScripts\tests\FT853.01-01.xml:449:&nbsp; with =
(taskName=3D&quot;excelFindRow&quot;)<o:p></o:p></span></p><p =
class=3DMsoNormal><span lang=3DEN-US =
style=3D'font-size:10.0pt;font-family:"Courier =
New";mso-fareast-language:NL-BE'><o:p>&nbsp;</o:p></span></p><p =
class=3DMsoNormal><span lang=3DEN-US style=3D'color:#1F497D'>So I =
actually don&#8217;t understand why the selftests were successful =
whereas on my system, that a similar test with the same excel file does =
not work.<o:p></o:p></span></p><p class=3DMsoNormal><span lang=3DEN-US =
style=3D'color:#1F497D'>I really hope you can help me because Canoo is =
under pressure already because of the inability of html unit to work =
with the latest JQuery &#8230;.<o:p></o:p></span></p><p =
class=3DMsoNormal><span lang=3DEN-US =
style=3D'color:#1F497D'><o:p>&nbsp;</o:p></span></p><p =
class=3DMsoNormal><span lang=3DEN-US =
style=3D'color:#1F497D'>Thanks!<o:p></o:p></span></p><p =
class=3DMsoNormal><span lang=3DEN-US =
style=3D'color:#1F497D'>David<o:p></o:p></span></p><div><div =
style=3D'border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm =
0cm 0cm'><p class=3DMsoNormal><b><span lang=3DEN-US =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-l=
anguage:NL-BE'>From:</span></b><span lang=3DEN-US =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-l=
anguage:NL-BE'> <a =
href=3D"mailto:[email protected]">[email protected]=
om</a> [<a =
href=3D"mailto:[email protected]">mailto:webtest-admin@lists.=
canoo.com</a>] <b>On Behalf Of </b>Habbert, Michael =
(Key-Work)<br><b>Sent:</b> woensdag 25 juni 2014 8:19<br><b>To:</b> <a =
href=3D"mailto:[email protected]">[email protected]</a><br><b=
>Subject:</b> [Webtest] AW: Excel steps and mime =
type<o:p></o:p></span></p></div></div><p class=3DMsoNormal><span =
lang=3DEN-US><o:p>&nbsp;</o:p></span></p><p class=3DMsoNormal><span =
lang=3DDE style=3D'color:#1F497D'>Dear David,<o:p></o:p></span></p><p =
class=3DMsoNormal><span lang=3DDE =
style=3D'color:#1F497D'><o:p>&nbsp;</o:p></span></p><p =
class=3DMsoNormal><span lang=3DDE style=3D'color:#1F497D'>we do have =
some tests with excel-Download and analyse =
&#8230;<o:p></o:p></span></p><p class=3DMsoNormal><span lang=3DDE =
style=3D'color:#1F497D'><o:p>&nbsp;</o:p></span></p><p =
class=3DMsoNormal><span lang=3DDE style=3D'color:#1F497D'>The content =
type changed as far as I remember with different =
excel-versions.<o:p></o:p></span></p><p class=3DMsoNormal><span =
lang=3DDE style=3D'color:#1F497D'>What kind of content type do you get =
by manual testing with a browser (IE and =
Firefox)?<o:p></o:p></span></p><p class=3DMsoNormal><span lang=3DDE =
style=3D'color:#1F497D'><o:p>&nbsp;</o:p></span></p><p =
class=3DMsoNormal><span lang=3DDE =
style=3D'color:#1F497D'>Greetings<o:p></o:p></span></p><p =
class=3DMsoNormal><span lang=3DDE =
style=3D'color:#1F497D'><o:p>&nbsp;</o:p></span></p><p =
class=3DMsoNormal><span lang=3DDE style=3D'color:#1F497D'>Michael =
Habbert<o:p></o:p></span></p><p class=3DMsoNormal><span =
lang=3DDE><o:p>&nbsp;</o:p></span></p><div><div><p =
class=3DMsoNormal><span lang=3DDE =
style=3D'color:navy'>&nbsp;<br>&nbsp;<br><strong><span =
style=3D'font-family:"Calibri","sans-serif"'>Michael =
Habbert</span></strong> <br>Key-Work Consulting GmbH | Kriegsstr. 100 | =
76133 Karlsruhe | Germany | <a href=3D"http://www.key-work.de" =
target=3D"_blank" title=3D"Key-Work Consulting =
GmbH">www.key-work.de</a><br>Fon: +49-721-78203-269 | E-Mail: <a =
href=3D"mailto:[email protected]">[email protected]</=
a> | Fax: +49-721-78203-10 <br>&nbsp;<br>Key-Work Consulting GmbH, =
Karlsruhe, HRB 108695, HRG Mannheim<br>Gesch=E4ftsf=FChrer: Andreas =
Stappert, Tobin Wotring </span><span =
lang=3DDE><o:p></o:p></span></p></div><div =
style=3D'border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm =
0cm 0cm'><p class=3DMsoNormal><b><span lang=3DDE =
style=3D'mso-fareast-language:DE'>Von:</span></b><span lang=3DDE =
style=3D'mso-fareast-language:DE'> <a =
href=3D"mailto:[email protected]">[email protected]=
om</a> [<a =
href=3D"mailto:[email protected]">mailto:webtest-admin@lists.=
canoo.com</a>] <b>Im Auftrag von </b>David Jehoul<br><b>Gesendet:</b> =
Montag, 23. Juni 2014 14:35<br><b>An:</b> <a =
href=3D"mailto:[email protected]">[email protected]</a>; =
David Jehoul<br><b>Betreff:</b> [Webtest] RE: Excel steps and mime =
type<o:p></o:p></span></p></div></div><p class=3DMsoNormal><span =
lang=3DDE><o:p>&nbsp;</o:p></span></p><p class=3DMsoNormal><span =
lang=3DEN-US style=3D'color:#1F497D'>I even tried it with the excel file =
that I found in the self test report on the Canoo webtest website. But =
that gives the same problem. I tried it with several browsers, but ended =
up with the same problem. I tried with build 1823 an 1825. Same problem =
&#8230;<o:p></o:p></span></p><p class=3DMsoNormal><span lang=3DEN-US =
style=3D'color:#1F497D'><o:p>&nbsp;</o:p></span></p><div><div =
style=3D'border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm =
0cm 0cm'><p class=3DMsoNormal><b><span lang=3DEN-US =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-l=
anguage:NL-BE'>From:</span></b><span lang=3DEN-US =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-l=
anguage:NL-BE'> <a =
href=3D"mailto:[email protected]">[email protected]=
om</a> [<a =
href=3D"mailto:[email protected]">mailto:webtest-admin@lists.=
canoo.com</a>] <b>On Behalf Of </b>David Jehoul<br><b>Sent:</b> maandag =
23 juni 2014 13:56<br><b>To:</b> <a =
href=3D"mailto:[email protected]">[email protected]</a><br><b=
>Subject:</b> [Webtest] Excel steps and mime =
type<o:p></o:p></span></p></div></div><p class=3DMsoNormal><span =
lang=3DNL-BE><o:p>&nbsp;</o:p></span></p><p class=3DMsoNormal><span =
lang=3DNL-BE>Hi,<o:p></o:p></span></p><p class=3DMsoNormal><span =
lang=3DNL-BE><o:p>&nbsp;</o:p></span></p><p class=3DMsoNormal><span =
lang=3DEN-US>We want to start to use some excel =
steps.<o:p></o:p></span></p><p class=3DMsoNormal><span lang=3DEN-US>The =
first problem I have is that the format of a normal excel file seems to =
be not supported.<o:p></o:p></span></p><p class=3DMsoNormal><span =
lang=3DEN-US>This is the error message I get when I use the excelFindRow =
task:<o:p></o:p></span></p><p class=3DMsoNormal><span =
lang=3DEN-US><o:p>&nbsp;</o:p></span></p><p class=3DMsoNormal><span =
lang=3DEN-US>File does not have correct content type (not a '.xls' =
file?): application/octet-stream<o:p></o:p></span></p><p =
class=3DMsoNormal><span =
lang=3DEN-US><o:p>&nbsp;</o:p></span></p><pre><span lang=3DEN-US>I read =
here:</span><span lang=3DEN-US =
style=3D'font-size:10.0pt;font-family:"Courier =
New";mso-fareast-language:NL-BE'> <a =
href=3D"http://lists.canoo.com/pipermail/webtest/2008q3/010837.html">http=
://lists.canoo.com/pipermail/webtest/2008q3/010837.html</a> </span><span =
lang=3DEN-US>that the expected format would be application/vnd.ms-excel, =
but when I manually create the xls file, I still get the same error =
message.<o:p></o:p></span></pre><pre><span =
lang=3DEN-US><o:p>&nbsp;</o:p></span></pre><pre><span lang=3DEN-US>Does =
anybody have experience in this =
matter?<o:p></o:p></span></pre><pre><span =
lang=3DEN-US><o:p>&nbsp;</o:p></span></pre><pre><span =
lang=3DEN-US>Thanks!<o:p></o:p></span></pre><pre><span =
lang=3DEN-US>David </span><span lang=3DEN-US =
style=3D'font-size:10.0pt;font-family:"Courier =
New";mso-fareast-language:NL-BE'><o:p></o:p></span></pre><p =
class=3DMsoNormal><span =
lang=3DEN-US><o:p>&nbsp;</o:p></span></p></div></body></html>
------=_NextPart_000_002D_01CF9123.44618B80--