Forum Discussion

Occasional Contributor

9 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 locat...

globalweather-soapui-project.xml23 KB

SoapUI_DataA.xlsx8 KB

SoapUI_Excel_Error.txt6 KB

nmrao

Champion Level 1

9 years ago

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

Anson1000
Occasional Contributor
9 years ago
Hi Rao,

How to use (How to import it to Soapui open source 5.3)?
groovycsv-1.1.jar
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
- Anson1000
  Occasional Contributor
  9 years ago
  
  I get an error message to read csv file
  - nmrao
    Champion Level 1
    9 years ago
    What libraries have been copied under SOAPUI_HOME/bin/ext directory?

Forum Discussion

SoapUI free version: error message when reading excel files with groovy code

Recent Discussions

WSS throwing NPE

Unable to Launch SoapUI 5.8 / any version after installation

Silently Uninstall

Related Content

Need groovy script to read messages from kafka topic

Advice on how to read multiple messages from queue

ERROR: java.net.SocketTimeoutException: Read timed out