import jxl.*
def f = new File("E:\\xyz\\data.xls")
def wk = Workbook.getWorkbook(f)
def s1 = wk.getSheet(0)
def rows = s1.getRows()
the below error is being dispalyed
groovy:lang.MissingPropertyException:No such property: Workbook for class: Script3 error at line:3
I'd suggest you to use apache poi jar files inside SOAPUI HOME/bin/ext .. And use below code to get the rows:-
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.usermodel.WorkbookFactory;
import org.apache.poi.ss.usermodel.CellStyle;
def projectPath = context.expand('${projectDir}') //Where your project resides main project properties
def path = projectPath + "/userInput.xls" //your inputsheet name
FileInputStream inputStream = new FileInputStream(path)
Workbook wb = WorkbookFactory.create(inputStream)
Sheet sheet1 = wb.getSheet("Sheet Name")
int rows = sheet1.getLastRowNum();
log.info(rows)
It should print you the number of rows.Hope, it works for you.
Check that the extension jar file JXL or Apache POI was copied to SoapUI\Bin\ext
https://community.smartbear.com/t5/SoapUI-Pro/Get-xls-data-in-loop-in-groovy-script/td-p/27864
