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
6 years ago

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.