Issue importing xslx file - ExcelWorkbook method

Questions and answers on developing, deploying and using plugins and JavaBeans

Issue importing xslx file - ExcelWorkbook method

Postby rick.eddy » Wed Jan 17, 2024 6:32 pm

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!
rick.eddy
 
Posts: 6
Joined: Tue Apr 11, 2023 7:12 pm

Re: Issue importing xslx file - ExcelWorkbook method

Postby mboegem » Wed Jan 17, 2024 6:52 pm

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.
Marc Boegem
Solutiative / JBS Group, Partner
Servoy Specialist
• Servoy Certified Developer
• Servoy Valued Professional
• Freelance Developer

Image
User avatar
mboegem
 
Posts: 1748
Joined: Sun Oct 14, 2007 1:34 pm
Location: Amsterdam

Re: Issue importing xslx file - ExcelWorkbook method

Postby rick.eddy » Wed Jan 17, 2024 8:38 pm

Thanks Marc,

Getting my jasper and poi file in sync with my current version of servoy fixed my issue.
rick.eddy
 
Posts: 6
Joined: Tue Apr 11, 2023 7:12 pm


Return to Plugins and Beans

Who is online

Users browsing this forum: No registered users and 4 guests

cron