Eviware Forum

soapUI => soapUI => Topic started by: raj on April 30, 2008, 10:07:31 pm



Title: How to write test result to an excel file?
Post by: raj on April 30, 2008, 10:07:31 pm
I have written groovy script to run a datadriven test.But now i am trying to display the test result of each test case to an excel file.
The format of teh excel will be like this:

Test Name      Test Result
-------------      ----------------
Testcase1       Passed
Testcase2       Failed
Testcase3       Passed

Can someone suggest how to write the result to a excel file in groovy script?

Regards,
Raj


Title: Re: How to write test result to an excel file?
Post by: omatzura on May 01, 2008, 07:23:32 am
Hi!

try using the jexcelapi library for this (http://jexcelapi.sourceforge.net/); put their jar(s) in the soapui\bin\ext folder and then use the library as described in their documentation for creating the output.

regards!

/Ole
eviware.com


Title: Re: How to write test result to an excel file?
Post by: raj on May 01, 2008, 11:36:29 pm
Hi Ole,
          That was a great tip.Its working perfect now.

Thanks,
Raj


Title: Re: How to write test result to an excel file?
Post by: zxsoap on June 19, 2008, 05:03:13 pm
Hi Ole,

Can you tell us what directory from jexcelapi contains .java files should I include?

Thanks,
zx


Title: Re: How to write test result to an excel file?
Post by: omatzura on June 19, 2008, 07:04:42 pm
Hi!

you should just put the jexcelapi jar file in the bin\ext folder, no other files required..

regards!

/Ole
eviware.com


Title: Re: How to write test result to an excel file?
Post by: zxsoap on June 23, 2008, 08:58:55 pm
Hi Ole,

Can you please tell me more detail on it? I could not get it.

Thanks,
zx


Title: Re: How to write test result to an excel file?
Post by: omatzura on June 23, 2008, 11:36:52 pm
Hi!

hmm.. exactly what do you need help with? Adding the library? Or creating the groovy scritps?

regards!

/Ole
eviware.com