Forum Discussion

plaidshirt's avatar
plaidshirt
Contributor
6 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
Champion Level 3
6 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
    6 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
      Champion Level 3
      6 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.