Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Working with Excel in Jython by using apache.poi.xssf lib

H_WwDec 15 2016 — edited Dec 15 2016

Hello,

I am trying to import apache.poi.xssf or hssf lib so that i can work with excel in event script.

I saw this post and it mentioned we need to "extend the Jython classpath to include any JAR files that you're comfortable working with in Jython."

FDMEE generate Excel report

So i used the same code that he had as below:

from sys import path

path.append("C:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\lib\poi-3.8-20120326.jar")

path.append("C:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\lib\poi-ooxml-3.8-20120326.jar")

I did a bit search and most of them says it cause by missing the xmlbean file or POI schema file. After i download and load them to lib, still get this:

java.lang.NoClassDefFoundError: java.lang.NoClassDefFoundError: org/openxmlformats/schemas/spreadsheetml/x2006/main/CTDataValidation

Here is all my lib:

pastedImage_11.png

Did anybody work with this before? Is this because the wrong version of any jar file?

CantBeImport.jpg

Thanks!!
This post has been answered by H_Ww on Dec 15 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 12 2017
Added on Dec 15 2016
#business-intelligence-applications, #financial-data-management, #performance-management-applications
1 comment
653 views