Hello Community Members,
I am stuck at 1 point where i wan't to fetch excel data having formula, i am able to achieve this in Eclipse and tried using same jars in soapui but getting below error:
Getting error on below code:
ERROR:An error occurred [Could not initialize class org.apache.poi.ooxml.POIXMLTypeLoader], see error log for details
Using below jars in my ext folder.
Any Help on this..TIA
What does it mean, "I am able to achieve this in eclipse"?
I was doing in SoapUI since morning but wasn't getting any moving ahead so tried the same task with eclipse with Maven project and solve this.
Have you copy, pasted the same java program in Groovy Script test step?
Yes i have copy pasted same code
Hope all the dependencies copied under bin/ext directory and restarted the tool.
Yes copied all dependencies into bin/ext folder and restarted the tool.
Is java version in the eclipse and SoapUi the same?
Yes java version is same in both the tools
Have you checked if there any conflicting libraries ? I.e., Same library different versions between lib and bin/ext?
All Libraries are same as i have copied to ext from .m2 repository of Eclipse
If java program is working, then can you create a library and call it in test step?
How to achieve this?
What is the formulae in excel? Does it include special characters such as #$?
it's a simple refer below screenshot.
Is it possible to test by saving the data into CSV format and use this file to read data and see?
No i have very huge data.
Above screenshot is just to test
Screenshot of Eclipse
Thank you for the reply.
Refer below link where it has the details on how to create a library of java code and use it in Groovy script step.
Regarding excel to csv(when saved, there won't be any formulae in the csv data), it is simple. Refer export part of below link
And Reading csv's is simple in Groovy. Refer:
So you have two options.
Yes, My company have provided me SoapUI Pro license but we have only 1 license and we need this to give this to manual team for execution and they don't have Pro license that's the reason doing it on opensource so that they will be able to use this.
