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
avidCoder's avatar
avidCoder
Super Contributor

poi.jar version?

mk107's avatar
mk107
Occasional Contributor
6 years ago
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.