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.
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.