Showing results for 
Search instead for 
Did you mean: 

soap UI Open source- groovy code

Regular Visitor

soap UI Open source- groovy code

I am  trying to fetch data from datasource excel sheet in soap UI using below code but getting error-

 Groovy code-

1. import jxl.*
2. import jxl.write.*

3. def f= new File("\\Entsserver85\\usisqaqc\\Group\\QA

4. def workbook1= Workbook.getWorkbook(f)
5. def sheet1=workbook1.getSheet(0)
6. def rc= sheet1.getRows()
7. rc


error message-

grrovy.lang.missingPropertyException: No Such Property: Workbook for Class: Script 59 error alt line: 5


Regular Contributor

Re: soap UI Open source- groovy code

Hi @Nikita,


Your code looks fine to me, i think the issue is with jar file.


If you are using SoapUI(Free version), then you manually have to download the latest jar file and store it to :

C:\Program Files\SmartBear\SoapUI-version\lib



Click "Accept as Solution" if my answer has helped, and remember to give "kudos" Smiley Happy

Thanks and Regards,
Himanshu Tayal
New Here?
Join us and watch the welcome video:
Top Kudoed Authors