In SoapUI, how can we do the reading of data from excel spreadsheet us

1.	In SoapUI, how can we do the reading of data from excel spreadsheet using a Groovy Script?
Answer» The DataSource and DataSource Loop functionalities are not present in the unpaid version of SOAPUI. For the DataSource and DataSource Loop functionality, one can USE the Ready API licensed version. One more way to read data from EXCEL using the Groovy Script in SoapUI is as follows: A library can be imported to SOAPUI for the management of the excel file - JXL.jar. We can download it from the following website- http://sourceforge.net/projects/jexcelapi/files/jexcelapi/2.6.12/jexcelapi_2_6_12.zip/download After that, the unzipping of the JAR file needs to be done followed by the COPYING of the JXL.jar file to the SOAPUI installation folder.

In SoapUI, how can we do the reading of data from excel spreadsheet using a Groovy Script?

Answer»

The DataSource and DataSource Loop functionalities are not present in the unpaid version of SOAPUI. For the DataSource and DataSource Loop functionality, one can USE the Ready API licensed version. One more way to read data from EXCEL using the Groovy Script in SoapUI is as follows:

A library can be imported to SOAPUI for the management of the excel file - JXL.jar. We can download it from the following website- http://sourceforge.net/projects/jexcelapi/files/jexcelapi/2.6.12/jexcelapi_2_6_12.zip/download
After that, the unzipping of the JAR file needs to be done followed by the COPYING of the JXL.jar file to the SOAPUI installation folder.

Discussion

No Comment Found

Related InterviewSolutions

Write a few differences for the following: SoapUI vs Postman.
What do you understand by API Testing? Why is it needed?
What are the options to debug Groovy Scripts in SoapUI?
Can we classify SOAP as a RPC (Remote Procedure Call)?
Which service in SoapUI helps us to call the SoapUI mock service from Java?
How can we use SoapUI to import an XSD (XML Schema Definition) file?
Using Groovy Script, get the test case name in SoapUI.
How can we set a property value in SoapUI using Groovy Script?
How to stop a Groovy Script in SoapUI?
Write a Groovy Script to save request and response in SoapUI?

In SoapUI, how can we do the reading of data from excel spreadsheet using a Groovy Script?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment