Instead of using groovy here. You can use Java code to get the values from xlsx with Apache POI. You can see several examples on internet for the same.
https://www.mkyong.com/java/apache-poi-reading-and-writing-excel-file-in-java/
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
