Steps accepting regex patterns have a regex="true/false" attribute. This is currently not the case of excelVerifyCellValue but it would make sense to fix it. Patch is welcome.
Cheers, Marc. -- Web: http://www.efficient-webtesting.com Blog: http://mguillem.wordpress.com Michael Habbert wrote: > Hi Immo, > > your right: > > ------------------------- corrected version > --------------------------------- > > <invoke url="https://url-to-excelfile" > username="${portalUserTest}" > password="${portalUserPasswordTest}"/> > <excelVerifyCellValue cell="D2" text="Ergebnis Werbemittelhochrechnung"/> > <excelVerifyCellValue cell="H2" text="Hochrechnung > ${ags.standard.test.season.label} vom .* (Standardkurven-Hochrechnung)"/> > so for now the Excel gets downloaded and the first check > succeeds but the second not. > > > Details > > expected value Hochrechnung HW2008 vom .* (Standardkurven-Hochrechnung) > actual value Hochrechnung HW2008 vom 13.01.2009 > (Standardkurven-Hochrechnung) > > ----------------------------------------------- > > I also tried: "\d{1,2}\.\d{1,2}\.2009" but it also failed > > btw. I'm using: R_1724 > > yours > > Michael Habbert > > > > > Hueneke, Immo schrieb: >> Hi Michael, >> >> I can't actually see the regex delimiters in your WebTest script. Are >> you sure you have included them as illustrated in your "expected >> value" below? >> >> Best regards, >> Immo >> >> -----Original Message----- >> From: webtest-ad...@lists.canoo.com >> [mailto:webtest-ad...@lists.canoo.com] On Behalf Of Michael Habbert >> Sent: 16 January 2009 10:28 >> To: webtest@lists.canoo.com >> Subject: [Webtest] Strange Excel-Value-Test >> >> Hi Folks, >> >> I'm using webtests quite intensive and decided to extend one test to >> check a Excelfile - provided by a webpage. >> >> So I'm testing: >> >> <invoke url="https://url-to-excelfile" >> username="${portalUserTest}" >> password="${portalUserPasswordTest}"/> >> <excelVerifyCellValue cell="D2" text="Ergebnis Werbemittelhochrechnung"/> >> <excelVerifyCellValue cell="H2" text="Hochrechnung >> ${ags.standard.test.season.label} vom .* (Standardkurven-Hochrechnung)"/> >> so for now the Excel gets downloaded and the first >> check succeeds but the second not. >> >> >> Details >> >> expected value /Hochrechnung HW2008 vom .* >> (Standardkurven-Hochrechnung)/ >> actual value Hochrechnung HW2008 vom 13.01.2009 >> (Standardkurven-Hochrechnung) >> >> >> >> >> I found some examples on the webtest-pages: >> >> <excelVerifyCellValue cell="E#{row}" text="/SUM\(.*\)/"/> >> <excelVerifyCellValue cell="O99" text="/\d+/" description="Check >> number"/> >> >> which indicate the usage of regex, I am right? >> >> Any hints? >> >> thanks >> >> Yours >> Michael Habbert >> >> Michael Habbert Key-Work Consulting GmbH | Kriegsstr. 100 | 76133 >> Karlsruhe | Germany | www.key-work.de >> Fon: +49-721-78203-269 | E-Mail: michael.habb...@key-work.de | Fax: >> +49-721-78203-10 >> >> Key-Work Consulting GmbH Karlsruhe, HRB 108695, HRG Mannheim >> Geschäftsführer: Andreas Stappert, Tobin Wotring >> _______________________________________________ >> WebTest mailing list >> WebTest@lists.canoo.com >> http://lists.canoo.com/mailman/listinfo/webtest >> > > _______________________________________________ > WebTest mailing list > WebTest@lists.canoo.com > http://lists.canoo.com/mailman/listinfo/webtest > _______________________________________________ WebTest mailing list WebTest@lists.canoo.com http://lists.canoo.com/mailman/listinfo/webtest