Solved
HOW TO READ EXCEL FILE IN GROOVY
I am reading an excel file like below using poi3.6 jars
commons-collections4-4.1.jar commons-collections4-4.1-javadoc.jar commons-compress-1.18.jar poi-3.16.jar poi-examples-3.16.jar poi-excel...
Forum Discussion
nmrao
Champion Level 2
Champion Level 2Not sure if there is any specific requirement to use only excel for the data.
But, if you can use csv file (this can be read from excel as well), it is pretty easy to deal with it in SoapUI with help of small library
Download below files and copy under SOAPUI_HOME/bin/ext directory and restart.
http://central.maven.org/maven2/com/xlson/groovycsv/groovycsv/1.0/groovycsv-1.0.jar
http://central.maven.org/maven2/com/opencsv/opencsv/3.1/opencsv-3.1.jar
And find sample code below:
https://github.com/xlson/groovycsv
But, if you can use csv file (this can be read from excel as well), it is pretty easy to deal with it in SoapUI with help of small library
Download below files and copy under SOAPUI_HOME/bin/ext directory and restart.
http://central.maven.org/maven2/com/xlson/groovycsv/groovycsv/1.0/groovycsv-1.0.jar
http://central.maven.org/maven2/com/opencsv/opencsv/3.1/opencsv-3.1.jar
And find sample code below:
https://github.com/xlson/groovycsv
I will try this also
