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
Community Hero
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?