Forum Discussion

lcordy's avatar
lcordy
Occasional Contributor
7 years ago

java.lang.NoClassDefFoundError with Apache POI

I was not getting this error in SoapUI 5.3 free version, exactly the same code reading Excel in ReadyAPI throws the error below. I copied the same jar files from bin/ext folder from SoapUI 5.3 to Rea...
lcordy's avatar
lcordy
Occasional Contributor
Yep, restarted. Using Poi 3.17 by the way.
nmrao's avatar
nmrao
Champion Level 3
7 years ago
Thanks for clarifying. Would you please list all the files under /bin/ext directory?
  • lcordy's avatar
    lcordy
    Occasional Contributor
    7 years ago

    Files in bin/ext attached.

    • ayonchoudhury's avatar
      ayonchoudhury
      New Contributor
      7 years ago

      This worked for me, incase you still have the issue.

      I downloaded the ooxml-schemas-1.3.jar file and placed it into bin/ext along with all the other poi jars.

      • ps4545's avatar
        ps4545
        New Contributor
        7 years ago

        def fs = new FileInputStream("D:/sample.xlsx")
        def wb = new XSSFWorkbook(fs)
        def ws = wb.getSheet("Sheet1")

        Executing ...Groovy script

        Which dependency is missing? - got this error SOAP UI 5.4 An error occurred [org/apache/commons/compress/archivers/zip/ZipFile], see error log for details

         

        Can any one help please!