Forum Discussion

Anson1000's avatar
Anson1000
Occasional Contributor
7 years ago

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

8 Replies