Issue importing xslx file - ExcelWorkbook method

[rick.eddy]

I've tried multiple approaches but ultimately get an error using the ExcelWorkbook function in the svyExcelUtils scope.

the error snippet:

Code: Select all

RROR org.sablo.eventthread.EventDispatcher - [dispatch()] Exception happened in dispatch() java.lang.NoSuchFieldError: Factory
   at org.apache.poi.xssf.model.ThemesTable.readFrom(ThemesTable.java:119) ~[?:?]
   at org.apache.poi.xssf.model.ThemesTable.<init>(ThemesTable.java:87) ~[?:?]
   at org.apache.poi.ooxml.POIXMLFactory.createDocumentPart(POIXMLFactory.java:61) ~[?:?]
   at org.apache.poi.ooxml.POIXMLDocumentPart.read(POIXMLDocumentPart.java:661) ~[?:?]
   at org.apache.poi.ooxml.POIXMLDocument.load(POIXMLDocument.java:165) ~[?:?]
   at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:260) ~[?:?]
   at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:290) ~[?:?]
   at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:286) ~[?:?]
   at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:?]
   at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[?:?]
   at jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[?:?]
   at java.lang.reflect.Constructor.newInstanceWithCaller(Unknown Source) ~[?:?]
   at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[?:?]....

Every way I would come at the upload eventually fails with that message.

Any help would be greatly appreciated!

[mboegem]

Hi,

did you follow instructions to install the required jar files?
https://github.com/Servoy/svyUtils/wiki/ExcelUtils

Please look closely for the versions you need, as this depends on the version of Servoy you're running.

If you've got that all installed and checked and still have an error, please post the code that is responsible for the error.

[rick.eddy]

Thanks Marc,

Getting my jasper and poi file in sync with my current version of servoy fixed my issue.