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: <step taskName="invoke" result="completed" duration="10" description="openFile(String) on screen WebPage" _line="439" _filename="c:\testScripts\tests\FT853.01-01.xml"><file:///C:\testScripts\testOutput\20140625_093546\001_FT8530101\WebTestReport.xml> <parameter value="file://C:/testScripts/testOutput/testExcel.xls" name="url"/> <resultFile name="004_response_invoke.xls"/> </step> <step taskName="excelFindRow" result="failed" duration="1" _line="449" _filename="c:\testScripts\tests\FT853.01-01.xml"><file:///C:\testScripts\testOutput\20140625_093546\001_FT8530101\WebTestReport.xml> <parameter value="BR" name="col"/> <parameter value="Rownr" name="property"/> <parameter value="Y" name="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="excelFindRow") So I actually don't understand why the selftests were successful whereas 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 .... 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 ... 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<http://www.key-work.de> Fon: +49-721-78203-269 | E-Mail: [email protected]<mailto:[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]> [mailto:[email protected]] Im Auftrag von David Jehoul Gesendet: Montag, 23. Juni 2014 14:35 An: [email protected]<mailto:[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 ... 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/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
