Anson1000
8 years agoOccasional Contributor
SoapUI free version: error message when reading excel files with groovy code
I get error message when reading excel file
There is on one column in this file
the code is as the following:
import org.apache.poi.xssf.usermodel.*
def fs = new FileInputStream("C:\my file location\SoapUI_DataA.xlsx")
def wb = new XSSFWorkbook(fs)
def ws = wb.getSheet("Sheet1")
def r = ws.getPhysicalNumberOfRows()
for ( def i=0 ; i<r; i++) {
def row = ws.getRow(i)
log.infor cell.getStringCellValue()
I have parameter c_name (Country Name) and I would like to user excel file as input for this parameter
All files are in here:
https://drive.google.com/drive/folders/0B80gqU807MGTblc4WXNaNmY0ZVE?usp=sharing
Thank you for your help