Forum Discussion

plaidshirt's avatar
plaidshirt
Contributor
6 years ago

Groovy to get values from xlsx with Apache POI

I try to read values from a xlsx file to properties in SoapUI 5.4.0. import org.apache.poi.ss.usermodel.*; import org.apache.poi.hssf.usermodel.*; import org.apache.poi.xssf.usermodel.*; import or...
  • plaidshirt's avatar
    plaidshirt
    Contributor
    6 years ago

    I try that code, but got same error:


    org.apache.poi.ooxml.POIXMLException: org.apache.xmlbeans.XmlOptions.setEntityExpansionLimit(I)Lorg/apache/xmlbeans/XmlOptions;

     

    Currently imported dependencies:

    commons-collections4-4.2-javadoc.jar
    commons-collections4-4.2.jar
    commons-compress-1.18.jar
    dom4j-1.6.1.jar
    ooxml-schemas-1.4.jar
    ooxml-security-1.1.jar
    openxml4j-1.0-beta.jar
    poi-4.0.1.jar
    poi-contrib-3.6.jar
    poi-examples-4.0.1.jar
    poi-excelant-4.0.1.jar
    poi-ooxml-4.0.1.jar
    poi-ooxml-schemas-4.0.1.jar
    poi-scratchpad-4.0.1.jar
    xmlbeans-3.0.2.jar