Forum Discussion

Qasvat's avatar
Qasvat
Occasional Contributor
14 years ago

HowTo create a simple XLS-report automatically

Hello,

I need a litte help with creating reports in soapUI 4.0.

What I want to do is export all test steps of a project to an Excel-sheet for further processing.
In theory this report looks pretty simple. I just need a column with the title of the test step and one with the status of the test step (OK/FAILED).

The report should be generated automatically after running a project.

I was not able to find out how to do this with the information from the online help. I would be glad I someone could provide me with the solution for this issue.

1 Reply

  • SmartBear_Suppo's avatar
    SmartBear_Suppo
    Icon for Alumni rankAlumni
    14 years ago
    Hi,

    easiest is probably to create a script in the corresponding tearDown script (TestCase, TestSuite or Project) that creates the XLS file with the desired contents for you. soapUI Pro bundles the jexcelapi library (http://jexcelapi.sourceforge.net/) so you can use that directly in your scripts to write the files, and the soapUI API itself (http://www.soapui.org/apidocs/index.html) gives you access to the teststeps, testcases, etc..

    Good Luck!

    /Ole
    SmartBear Stockholm