Forum Discussion

Nikita's avatar
Nikita
New Contributor
6 years ago

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\\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

Sort By
  • HimanshuTayal's avatar
    HimanshuTayal
    Community Hero
    6 years ago

    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