Forum Discussion

plaidshirt's avatar
plaidshirt
Contributor
7 years ago

Groovy to get values from xlsx with Apache POI

I try to read values from a xlsx file to properties in SoapUI 5.4.0. import org.apache.poi.ss.usermodel.*; import org.apache.poi.hssf.usermodel.*; import org.apache.poi.xssf.usermodel.*; import or...
nmrao's avatar
nmrao
Icon for Champion Level 1 rankChampion Level 1
7 years ago
Does your data in multiple sheets of xlsx?
If the data is simple, then you can easily deal with in groovy with or without any additional libraries.
if you use below library it is **bleep** simple to read it. Also sample available there.
https://github.com/xlson/groovycsv
plaidshirt's avatar
plaidshirt
Contributor
7 years ago

Apache Ivy jar is imported, but groovycsv throws noclassdef error message.

Could you offer me a native solution please?

  • nmrao's avatar
    nmrao
    Icon for Champion Level 1 rankChampion Level 1
    7 years ago
    plaidshirt,

    You can download the groovy-csv jar file (available in github) along with dependencies, then copy thenm under SOAPUI_HOME/bin/ext and restart soapUI.

    Then try the given samples. You might have already observiced how simple to access the data from the sample.
      • nmrao's avatar
        nmrao
        Icon for Champion Level 1 rankChampion Level 1
        7 years ago
        What files did you copy under ext directory? And the script please