cancel
Showing results for 
Search instead for 
Did you mean: 

soap UI Open source- groovy code

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
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
Share Your Stories
Read Latest News
Top Kudoed Authors