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
Replace backslash with double backslash
def fs = new FileInputStream("C:\\my file location\\SoapUI_DataA.xlsx")
or you can use this answer
then } is missing at the end of last line.
Hi Rao,
How to use (How to import it to Soapui open source 5.3)?
@nmrao wrote:
If I were you, I would use .csv instead of .xls file. And use below library which **bleep** simple, find example in below thread:
https://github.com/xlson/groovycsv
Thanks
I get an error message to read csv file
Hi Rao,
I copy groovycsv-1.1.jar to SOAPUI_HOME/bin/ext directory
@nmrao wrote:
What libraries have been copied under SOAPUI_HOME/bin/ext directory?
Hi , I have add all the jar file related to it still i am getting the same error message.
Subject | Author | Latest Post |
---|---|---|