cancel
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

Testing\\Cognizant\\Tibco_Migration_PCF\\6.Insurance\\PhysicalRecords\\Data\\TestData.xls")
4. def workbook1= Workbook.getWorkbook(f)
5. def sheet1=workbook1.getSheet(0)
6. def rc= sheet1.getRows()
7. log.info rc

 

error message-

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

 

1 REPLY 1
Highlighted
Community Leader

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
February News
Top Kudoed Authors