How do i Capturing response value to a excel file in soapui open source

user_15571104 0
Viewed 372

I am using free soap-ui version . for basic project (Calculator WSDL). for that i want to save soapui response values to excel, I have written groovy script for that like shown below , am passing multi data in request but in excel its saving last response only , i want to get all response values. can any one please help me.

import jxl.*
import jxl.write.*

def groovyUtils = new com.eviware.soapui.support.GroovyUtils( context )
def holder = groovyUtils.getXmlHolder("Add#Response") 

log.info holder.getXml()  

WritableWorkbook workbook = Workbook.createWorkbook(new File("F:\\Usersdata\\output4.xls"))
WritableSheet sheet = workbook.createSheet("Worksheet 1", 0)

log.info(sheet.isHidden())

xPath1 = "//*:AddResult/text()"     

log.info holder.getNodeValue(xPath1)


Label label = new Label(0, 1, holder.getNodeValue(xPath1)); 
sheet.addCell(label);



workbook.write();
workbook.close();
soapui groovy
1 Answers

You will have to loop through the tests, even if it is just one test for now. Look at this example. Call the WS from inside the loop as well as the part where you write to Excel. In pseudo code:

--set up your environment, spreadsheet handle etc.
--for every test case:
    --call web service
    --get result
    --write result
--close off and clean up, save Excel
user_33558600
Related