Forum Discussion
avidCoder
8 years agoSuper Contributor
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.