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

Community Hero

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
  Community Hero
  9 years ago
  What libraries have been copied under SOAPUI_HOME/bin/ext directory?
  - Anson1000
    Occasional Contributor
    9 years ago
    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?

Forum Discussion

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

Recent Discussions

Signature\Encryption tags missing in Security Header

CVE-2024-7565 and CVE-2017-16670 vulnabilities

Vulnerabilities found in SoapUI 5.9.1

Related Content

Need groovy script to read messages from kafka topic

Supported Chrome version

Unable to read Kafka received messages using MessageExchange