AW: Excel steps and mime type
"Habbert, Michael (Key-Work)" <[email protected]> Wed, 25 Jun 2014 06:19:12 +0000
| Newsgroups | gmane.comp.web.canoo.webtest |
|---|---|
| Message-ID | <020D1069F2FDF64A9D99558C22CA93A22544115C@ex3> |
--_000_020D1069F2FDF64A9D99558C22CA93A22544115Cex3_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Dear David, we do have some tests with excel-Download and analyse ... 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 a= nd Firefox)? Greetings Michael Habbert Michael Habbert Key-Work Consulting GmbH | Kriegsstr. 100 | 76133 Karlsruhe | Germany | www= .key-work.de<http://www.key-work.de> Fon: +49-721-78203-269 | E-Mail: [email protected]<mailto:michael= [email protected]> | Fax: +49-721-78203-10 Key-Work Consulting GmbH, Karlsruhe, HRB 108695, HRG Mannheim Gesch?ftsf?hrer: Andreas Stappert, Tobin Wotring Von: [email protected] [mailto:[email protected]] I= m 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 wit= h several browsers, but ended up with the same problem. I tried with build = 1823 an 1825. Same problem ... From: [email protected]<mailto:[email protected]> [= mailto:[email protected]] On Behalf Of David Jehoul Sent: maandag 23 juni 2014 13:56 To: [email protected]<mailto:[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/o= ctet-stream I read here: http://lists.canoo.com/pipermail/webtest/2008q3/010837.html th= at the expected format would be application/vnd.ms-excel, but when I manual= ly create the xls file, I still get the same error message. Does anybody have experience in this matter? Thanks! David --_000_020D1069F2FDF64A9D99558C22CA93A22544115Cex3_ 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-micr= osoft-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=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"= > <meta name=3D"Generator" content=3D"Microsoft Word 15 (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:Consolas; panose-1:0 0 0 0 0 0 0 0 0 0;} @font-face {font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 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 Vorformatiert Zchn"; margin:0cm; margin-bottom:.0001pt; font-size:10.0pt; font-family:"Courier New";} span.HTMLVorformatiertZchn {mso-style-name:"HTML Vorformatiert Zchn"; mso-style-priority:99; mso-style-link:"HTML Vorformatiert"; font-family:"Consolas","serif"; mso-fareast-language:EN-US;} p.HTMLPreformatted, li.HTMLPreformatted, div.HTMLPreformatted {mso-style-name:"HTML Preformatted"; 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;} 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.E-MailFormatvorlage21 {mso-style-type:personal; font-family:"Calibri","sans-serif"; color:windowtext;} span.E-MailFormatvorlage22 {mso-style-type:personal; font-family:"Calibri","sans-serif"; color:#1F497D;} span.E-MailFormatvorlage23 {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=3D"DE" link=3D"blue" vlink=3D"purple"> <div class=3D"WordSection1"> <p class=3D"MsoNormal"><span style=3D"color:#1F497D">Dear David,<o:p></o:p>= </span></p> <p class=3D"MsoNormal"><span style=3D"color:#1F497D"><o:p> </o:p></spa= n></p> <p class=3D"MsoNormal"><span style=3D"color:#1F497D">we do have some tests = with excel-Download and analyse …<o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"color:#1F497D"><o:p> </o:p></spa= n></p> <p class=3D"MsoNormal"><span style=3D"color:#1F497D">The content type chang= ed as far as I remember with different excel-versions.<o:p></o:p></span></p= > <p class=3D"MsoNormal"><span style=3D"color:#1F497D">What kind of content t= ype do you get by manual testing with a browser (IE and Firefox)?<o:p></o:p= ></span></p> <p class=3D"MsoNormal"><span style=3D"color:#1F497D"><o:p> </o:p></spa= n></p> <p class=3D"MsoNormal"><span style=3D"color:#1F497D">Greetings<o:p></o:p></= span></p> <p class=3D"MsoNormal"><span style=3D"color:#1F497D"><o:p> </o:p></spa= n></p> <p class=3D"MsoNormal"><span style=3D"color:#1F497D">Michael Habbert<o:p></= o:p></span></p> <p class=3D"MsoNormal"><o:p> </o:p></p> <div> <div class=3D"Section1"> <p class=3D"MsoNormal"><span style=3D"font-family:Calibri,Arial,Sans-Serif;= color:#000080"> <br> <br> <strong>Michael Habbert</strong> <br> Key-Work Consulting GmbH | Kriegsstr. 100 | 76133 Karlsruhe | Germany | <a = href=3D"http://www.key-work.de" title=3D"Key-Work Consulting GmbH" target= =3D"_blank"> www.key-work.de</a><br> Fon: +49-721-78203-269 | E-Mail: <a href=3D"mailto:michael.habbert@key-= work.de">[email protected]</a> | Fax: +49-721-78203-10 <br> <br> Key-Work Consulting GmbH, Karlsruhe, HRB 108695, HRG Mannheim<br> Geschäftsführer: Andreas Stappert, Tobin Wotring </span><o:p></o:= p></p> </div> <div style=3D"border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm = 0cm 0cm"> <p class=3D"MsoNormal"><b><span style=3D"mso-fareast-language:DE">Von:</spa= n></b><span style=3D"mso-fareast-language:DE"> [email protected]= m [mailto:[email protected]] <b>Im Auftrag von </b>David Jehoul<br> <b>Gesendet:</b> Montag, 23. Juni 2014 14:35<br> <b>An:</b> [email protected]; David Jehoul<br> <b>Betreff:</b> [Webtest] RE: Excel steps and mime type<o:p></o:p></span></= p> </div> </div> <p class=3D"MsoNormal"><o:p> </o:p></p> <p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:#1F497D">I even = tried it with the excel file that I found in the self test report on the Ca= noo webtest website. But that gives the same problem. I tried it with sever= al browsers, but ended up with the same problem. I tried with build 1823 an 1825. Same problem …<o:p></o:p><= /span></p> <p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:#1F497D"><o:p>&n= bsp;</o:p></span></p> <div> <div style=3D"border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm = 0cm 0cm"> <p class=3D"MsoNormal"><b><span lang=3D"EN-US" style=3D"font-size:10.0pt;fo= nt-family:"Tahoma","sans-serif";mso-fareast-language:NL= -BE">From:</span></b><span lang=3D"EN-US" style=3D"font-size:10.0pt;font-fa= mily:"Tahoma","sans-serif";mso-fareast-language:NL-BE"> <a href=3D"mailto:[email protected]">[email protected]= com</a> [<a href=3D"mailto:[email protected]">mailto:webtest-ad= [email protected]</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]= om</a><br> <b>Subject:</b> [Webtest] Excel steps and mime type<o:p></o:p></span></p> </div> </div> <p class=3D"MsoNormal"><span lang=3D"NL-BE"><o:p> </o:p></span></p> <p class=3D"MsoNormal"><span lang=3D"NL-BE">Hi,<o:p></o:p></span></p> <p class=3D"MsoNormal"><span lang=3D"NL-BE"><o:p> </o:p></span></p> <p class=3D"MsoNormal"><span lang=3D"EN-US">We want to start to use some ex= cel steps.<o:p></o:p></span></p> <p class=3D"MsoNormal"><span lang=3D"EN-US">The first problem I have is tha= t the format of a normal excel file seems to be not supported.<o:p></o:p></= span></p> <p class=3D"MsoNormal"><span lang=3D"EN-US">This is the error message I get= when I use the excelFindRow task:<o:p></o:p></span></p> <p class=3D"MsoNormal"><span lang=3D"EN-US"><o:p> </o:p></span></p> <p class=3D"MsoNormal"><span lang=3D"EN-US">File does not have correct cont= ent type (not a '.xls' file?): application/octet-stream<o:p></o:p></span></= p> <p class=3D"MsoNormal"><span lang=3D"EN-US"><o:p> </o:p></span></p> <pre><span lang=3D"EN-US" style=3D"font-size:11.0pt;font-family:"Calib= ri","sans-serif";mso-fareast-language:EN-US">I read here:</s= pan><span lang=3D"EN-US"> <a href=3D"http://lists.canoo.com/pipermail/webte= st/2008q3/010837.html">http://lists.canoo.com/pipermail/webtest/2008q3/0108= 37.html</a> </span><span lang=3D"EN-US" style=3D"font-size:11.0pt;font-fami= ly:"Calibri","sans-serif";mso-fareast-language:EN-US">t= hat the expected format would be application/vnd.ms-excel, but when I manua= lly create the xls file, I still get the same error message.<o:p></o:p></sp= an></pre> <pre><span lang=3D"EN-US" style=3D"font-size:11.0pt;font-family:"Calib= ri","sans-serif";mso-fareast-language:EN-US"><o:p> </o:= p></span></pre> <pre><span lang=3D"EN-US" style=3D"font-size:11.0pt;font-family:"Calib= ri","sans-serif";mso-fareast-language:EN-US">Does anybody ha= ve experience in this matter?<o:p></o:p></span></pre> <pre><span lang=3D"EN-US" style=3D"font-size:11.0pt;font-family:"Calib= ri","sans-serif";mso-fareast-language:EN-US"><o:p> </o:= p></span></pre> <pre><span lang=3D"EN-US" style=3D"font-size:11.0pt;font-family:"Calib= ri","sans-serif";mso-fareast-language:EN-US">Thanks!<o:p></o= :p></span></pre> <pre><span lang=3D"EN-US" style=3D"font-size:11.0pt;font-family:"Calib= ri","sans-serif";mso-fareast-language:EN-US">David </span><s= pan lang=3D"EN-US"><o:p></o:p></span></pre> <p class=3D"MsoNormal"><span lang=3D"EN-US"><o:p> </o:p></span></p> </div> </body> </html> --_000_020D1069F2FDF64A9D99558C22CA93A22544115Cex3_--