I am trying to fetch data from datasource excel sheet in soap UI using below code but getting error-
1. import jxl.*2. import jxl.write.*
3. def f= new File("\\Entsserver85\\usisqaqc\\Group\\QA
Testing\\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
grrovy.lang.missingPropertyException: No Such Property: Workbook for Class: Script 59 error alt line: 5
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 :
Click "Accept as Solution" if my answer has helped, and remember to give "kudos" 🙂 ↓↓↓↓↓