Forum Discussion

smitadegolia's avatar
smitadegolia
14 years ago

How to store response values into Excel using SoapUI?

Hi, I am using SoapUI for automation testing using SOAP/HTTP. I want to store Soap response (xml) values into Excel for reporting purposes. Is there a way through Properties or Groovy to access the...
Finan's avatar
Finan
Frequent Contributor
14 years ago
I haven't yet written a groovy script to write to excel, but I would recommend you try something like http://groovy.codehaus.org/Groovy+for+the+Office

The problem of accessing the XML values is quite easy to solve.
You can either use the "getData functionality" or create an XML reader to read from the response.
Note: this is quite easy in soapUI pro, don't know if it is different in soapUI.