Forum Discussion

mk107's avatar
mk107
Occasional Contributor
6 years ago

Handling POIXML Exception in Groovy Scripting

We are trying to read data from xlsx file using apache POI, we have all the jars files placed under soap/bin/ext. It gives us below error when running our groovy script. org.apache.poi.ooxml.POIX...
excel
Groovy
POI
SOAP
mk107's avatar
mk107
Occasional Contributor
Poi version is 4.1.0
avidCoder's avatar
avidCoder
Super Contributor
6 years ago

Add this jar file also in bin/ext folder - ooxml-schemas-1.4.jar and then restart your soap ui. If you have already added some version of ooxml-schemas_version_name.jar.. Then remove that. for poi version 4.1.0 you have to use ooxml-schemas-1.4.jar.

  • mk107's avatar
    mk107
    Occasional Contributor
    6 years ago
    Adding ooxml-schemas 1.4 in bin does not work. Do we need to keep same copy of jar in soap/bin/ext.

    Restarted soap after placing jars but it gives same error.
    • avidCoder's avatar
      avidCoder
      Super Contributor
      6 years ago

      Yeah.. actually, you need to keep it in bin/ext folder.. please try again.

      • mk107's avatar
        mk107
        Occasional Contributor
        6 years ago

        It did not work by placing jar file in ext folder. We have added jars files in soap/bin/ext folder for us. We are using SOAP 5.5.0. Thanks

         

        activation-1.1.1

        commons-codec-1.12

        commons-collections4-4.3

        commons-compress-1.18

        commons-logging-1.2

        commons-math3-3.6.1

        curvesapi-1.06

        jaxb-api-2.3.0

        jaxb-core-2.3.0.1

        jaxb-impl-2.3.0.1

        junit-4.12

        log4j-1.2.17

        ooxml-schemas-1.4

        poi-4.1.0

        poi-examples-4.1.0

        poi-excelant-4.1.0

        poi-ooxml-4.1.0

        poi-scratchpad-4.1.0

        xmlbeans-3.1.0