I agree there's something wrong with the latest poi version.
I use an old one: 3.13 version, but it works fine.
You can find it in attached files.
After searching about the error message in google i found i have missing common-collection jars file.
So i downloaded these files:
commons-codec-1.15.jar
jxl-2.6.8.jar
poi-5.0.0.jar
poi-ooxml-5.0.0.jar
poi-ooxml-schemas-4.1.2.jar
stax-api-1.0-2.jar
xmlbeans-4.0.0.jar
placed in : C:\Users\....\Programs\SmartBear\SoapUI-5.6.0\bin\ext and removed old files
I only have these jars and nothing else.
When i run the code it returns the same error:
org.codehaus.groovy.control.MultipleCompilationErrorsException: startup failed: General error during class generation: java.lang.NoClassDefFoundError: Unable to load class org.apache.poi.xssf.usermodel.XSSFWorkbook due to missing dependency org/apache/commons/collections4/ListValuedMap java.lang.RuntimeException: java.lang.NoClassDefFoundError: Unable to load class org.apache.poi.xssf.usermodel.XSSFWorkbook due to missing dependency org/apache/commons/collections4/ListValuedMap at
I agree there's something wrong with the latest poi version.
I use an old one: 3.13 version, but it works fine.
You can find it in attached files.
Wonderful.
I was trying one by one all versions then you gave the right version.
i confirm it works.
Thanks a lot.
