Forum Discussion

raj's avatar
raj
New Contributor
16 years ago

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

  • omatzura's avatar
    omatzura
    Super Contributor
    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's avatar
    raj
    New Contributor
    Hi Ole,
              That was a great tip.Its working perfect now.

    Thanks,
    Raj
  • zxsoap's avatar
    zxsoap
    Occasional Contributor
    Hi Ole,

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

    Thanks,
    zx
  • omatzura's avatar
    omatzura
    Super Contributor
    Hi!

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

    regards!

    /Ole
    eviware.com
  • zxsoap's avatar
    zxsoap
    Occasional Contributor
    Hi Ole,

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

    Thanks,
    zx
  • omatzura's avatar
    omatzura
    Super Contributor
    Hi!

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

    regards!

    /Ole
    eviware.com
  • Hi,

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

    Regards,
    chikki