cancel
Showing results for 
Search instead for 
Did you mean: 

How to write test result to an excel file?

raj
New Contributor

How to write test result to an excel file?

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
8 REPLIES 8
omatzura
Super Contributor

Re: How to write test result to an excel file?

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
raj
New Contributor

Re: How to write test result to an excel file?

Hi Ole,
          That was a great tip.Its working perfect now.

Thanks,
Raj
zxsoap
Occasional Contributor

Re: How to write test result to an excel file?

Hi Ole,

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

Thanks,
zx
omatzura
Super Contributor

Re: How to write test result to an excel file?

Hi!

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

regards!

/Ole
eviware.com
zxsoap
Occasional Contributor

Re: How to write test result to an excel file?

Hi Ole,

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

Thanks,
zx
omatzura
Super Contributor

Re: How to write test result to an excel file?

Hi!

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

regards!

/Ole
eviware.com
Usha_Kodali
Frequent Contributor

Re: How to write test result to an excel file?

Hi Raj,
can you post ur findings here?It would be very helpful
chikki
Contributor

Re: How to write test result to an excel file?

Hi,

if you can add it will be really helpful to other forum members... 

Regards,
chikki
"when the going get tough, that's when the tough get going"
New Here?
Join us and watch the welcome video:
Announcements
Top Kudoed Authors