Forum Discussion

swap377's avatar
11 years ago

Reading and writing to excel

Hi All,

I need some inputs where i need to pass on values to request using excel and gather the response details into another excel but using GROOVY scripting as I am using free version of SOAPUI.
For eg:

My request is :
<soap:Body>
<weat:GetCityForecastByZIP>
<weat:ZIP>?</weat:ZIP>
</weat:GetCityForecastByZIP>
</soap:Body>

I want to pass the value for ? using excel sheet.

My response is :
ForecastResult>
<Forecast>
<Date>2013-01-03T00:00:00</Date>
<WeatherID>4</WeatherID>
<Description>Sunny</Desciption>
<Temperatures>
<MorningLow/>
<DaytimeHigh>54</DaytimeHigh>
</Temperatures>
<ProbabilityOfPrecipiation>
<Nighttime/>
<Daytime>00</Daytime>
</ProbabilityOfPrecipiation>
</Forecast>

I want to gather the values of all nodes in another excel.

Can i do it and if YES can i get a sample code for it ? Please help.

Thanks.