You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by JagadeeshK <kj...@gmail.com> on 2011/05/28 08:01:35 UTC
Unable to Excel 2007 documents using XSSF
Hi,
I am unable to open Excel 2007 documents using XSSF.
I am using following jars,
poi-3.7-20101029.jar
poi-ooxml-3.7-20101029.jar
poi-ooxml-schemas-3.7-20101029.jar
dom4j-1.6.1.jar
xmlbeans-2.3.0.jar
Error stack trace:
java.lang.reflect.InvocationTargetException
org.apache.poi.POIXMLException: java.lang.reflect.InvocationTargetException
at
org.apache.poi.xssf.usermodel.XSSFFactory.createDocumentPart(XSSFFactory.java:61)
at org.apache.poi.POIXMLDocumentPart.read(POIXMLDocumentPart.java:277)
at org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:186)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:189)
at com.xxx.rfid.util.Util.uploadFromXLSX(Util.java:350)
at com.xxxx.rfid.util.Util.modifyExcelFileAndUploadData(Util.java:168)
at com.xxxx.rfid.util.Util.uploadFile(Util.java:132)
at
pageflows.fileupload.FileuploadController.upload(FileuploadController.java:114)
at
jrockit.reflect.VirtualNativeMethodInvoker.invoke(Ljava.lang.Object;[Ljava.lang.Object;)Ljava.lang.Object;(Unknown
Source)
at
java.lang.reflect.Method.invoke(Ljava.lang.Object;[Ljava.lang.Object;I)Ljava.lang.Object;(Unknown
Source)
at
org.apache.beehive.netui.pageflow.FlowController.invokeActionMethod(FlowController.java:869)
at
org.apache.beehive.netui.pageflow.FlowController.getActionMethodForward(FlowController.java:808)
at
org.apache.beehive.netui.pageflow.FlowController.internalExecute(FlowController.java:477)
at
org.apache.beehive.netui.pageflow.PageFlowController.internalExecute(PageFlowController.java:305)
at
org.apache.beehive.netui.pageflow.FlowController.execute(FlowController.java:335)
at
org.apache.beehive.netui.pageflow.internal.FlowControllerAction.execute(FlowControllerAction.java:51)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
at
org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.access$201(PageFlowRequestProcessor.java:95)
at
org.apache.beehive.netui.pageflow.PageFlowRequestProcessor$ActionRunner.execute(PageFlowRequestProcessor.java:2042)
at
org.apache.beehive.netui.pageflow.interceptor.action.internal.ActionInterceptors.wrapAction(ActionInterceptors.java:90)
at
org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.processActionPerform(PageFlowRequestProcessor.java:2114)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at
org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.processInternal(PageFlowRequestProcessor.java:554)
at
org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.process(PageFlowRequestProcessor.java:851)
at
org.apache.beehive.netui.pageflow.AutoRegisterActionServlet.process(AutoRegisterActionServlet.java:630)
at
org.apache.beehive.netui.pageflow.PageFlowActionServlet.process(PageFlowActionServlet.java:157)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
Caused by: java.lang.reflect.InvocationTargetException
at
jrockit.reflect.NativeConstructorInvoker.newInstance([Ljava.lang.Object;)Ljava.lang.Object;(Unknown
Source)
at
jrockit.reflect.InitialConstructorInvoker.newInstance([Ljava.lang.Object;)Ljava.lang.Object;(Unknown
Source)
at
java.lang.reflect.Constructor.newInstance([Ljava.lang.Object;I)Ljava.lang.Object;(Unknown
Source)
at
org.apache.poi.xssf.usermodel.XSSFFactory.createDocumentPart(XSSFFactory.java:59)
at org.apache.poi.POIXMLDocumentPart.read(POIXMLDocumentPart.java:277)
at org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:186)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:189)
at com.xxx.rfid.util.Util.uploadFromXLSX(Util.java:350)
at com.xxxx.rfid.util.Util.modifyExcelFileAndUploadData(Util.java:168)
at com.xxxx.rfid.util.Util.uploadFile(Util.java:132)
at
pageflows.fileupload.FileuploadController.upload(FileuploadController.java:114)
at
jrockit.reflect.VirtualNativeMethodInvoker.invoke(Ljava.lang.Object;[Ljava.lang.Object;)Ljava.lang.Object;(Unknown
Source)
at
java.lang.reflect.Method.invoke(Ljava.lang.Object;[Ljava.lang.Object;I)Ljava.lang.Object;(Unknown
Source)
at
org.apache.beehive.netui.pageflow.FlowController.invokeActionMethod(FlowController.java:869)
at
org.apache.beehive.netui.pageflow.FlowController.getActionMethodForward(FlowController.java:808)
at
org.apache.beehive.netui.pageflow.FlowController.internalExecute(FlowController.java:477)
at
org.apache.beehive.netui.pageflow.PageFlowController.internalExecute(PageFlowController.java:305)
at
org.apache.beehive.netui.pageflow.FlowController.execute(FlowController.java:335)
at
org.apache.beehive.netui.pageflow.internal.FlowControllerAction.execute(FlowControllerAction.java:51)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
at
org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.access$201(PageFlowRequestProcessor.java:95)
at
org.apache.beehive.netui.pageflow.PageFlowRequestProcessor$ActionRunner.execute(PageFlowRequestProcessor.java:2042)
at
org.apache.beehive.netui.pageflow.interceptor.action.internal.ActionInterceptors.wrapAction(ActionInterceptors.java:90)
at
org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.processActionPerform(PageFlowRequestProcessor.java:2114)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at
org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.processInternal(PageFlowRequestProcessor.java:554)
at
org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.process(PageFlowRequestProcessor.java:851)
at
org.apache.beehive.netui.pageflow.AutoRegisterActionServlet.process(AutoRegisterActionServlet.java:630)
Caused by: java.lang.ExceptionInInitializerError
at
jrockit.reflect.MemberAccess.newFieldAccessor(Ljava.lang.reflect.Field;Z)Ljrockit.reflect.FieldAccessor;(Unknown
Source)
at
java.lang.reflect.Field.acquireFieldAccessor(Z)Ljrockit.reflect.FieldAccessor;(Unknown
Source)
at
java.lang.reflect.Field.getAccessor(Ljava.lang.Object;I)Ljrockit.reflect.FieldAccessor;(Unknown
Source)
at
java.lang.reflect.Field.get(Ljava.lang.Object;I)Ljava.lang.Object;(Unknown
Source)
at org.apache.xmlbeans.XmlBeans.typeSystemForClassLoader(XmlBeans.java:770)
at
org.openxmlformats.schemas.drawingml.x2006.main.ThemeDocument.<clinit>()V(Unknown
Source)
at
org.openxmlformats.schemas.drawingml.x2006.main.ThemeDocument$Factory.parse(Ljava.io.InputStream;)Lorg.openxmlformats.schemas.drawingml.x2006.main.ThemeDocument;(Unknown
Source)
at org.apache.poi.xssf.model.ThemesTable.<init>(ThemesTable.java:39)
at
jrockit.reflect.NativeConstructorInvoker.newInstance([Ljava.lang.Object;)Ljava.lang.Object;(Unknown
Source)
at
jrockit.reflect.InitialConstructorInvoker.newInstance([Ljava.lang.Object;)Ljava.lang.Object;(Unknown
Source)
at
java.lang.reflect.Constructor.newInstance([Ljava.lang.Object;I)Ljava.lang.Object;(Unknown
Source)
at
org.apache.poi.xssf.usermodel.XSSFFactory.createDocumentPart(XSSFFactory.java:59)
at org.apache.poi.POIXMLDocumentPart.read(POIXMLDocumentPart.java:277)
at org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:186)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:189)
at com.citibank.rfid.util.Util.uploadFromXLSX(Util.java:350)
at com.citibank.rfid.util.Util.modifyExcelFileAndUploadData(Util.java:168)
at com.citibank.rfid.util.Util.uploadFile(Util.java:132)
at
pageflows.fileupload.FileuploadController.upload(FileuploadController.java:114)
at
jrockit.reflect.VirtualNativeMethodInvoker.invoke(Ljava.lang.Object;[Ljava.lang.Object;)Ljava.lang.Object;(Unknown
Source)
at
java.lang.reflect.Method.invoke(Ljava.lang.Object;[Ljava.lang.Object;I)Ljava.lang.Object;(Unknown
Source)
at
org.apache.beehive.netui.pageflow.FlowController.invokeActionMethod(FlowController.java:869)
at
org.apache.beehive.netui.pageflow.FlowController.getActionMethodForward(FlowController.java:808)
Caused by: java.lang.RuntimeException: Could not instantiate
SchemaTypeSystemImpl (java.lang.reflect.InvocationTargetException): is the
version of xbean.jar correct?
at
schemaorg_apache_xmlbeans.system.sE130CAA0A01A7CDE5A2B4FEB8B311707.TypeSystemHolder.loadTypeSystem()Lorg.apache.xmlbeans.SchemaTypeSystem;(Unknown
Source)
at
schemaorg_apache_xmlbeans.system.sE130CAA0A01A7CDE5A2B4FEB8B311707.TypeSystemHolder.<clinit>()V(Unknown
Source)
at
jrockit.reflect.MemberAccess.newFieldAccessor(Ljava.lang.reflect.Field;Z)Ljrockit.reflect.FieldAccessor;(Unknown
Source)
at
java.lang.reflect.Field.acquireFieldAccessor(Z)Ljrockit.reflect.FieldAccessor;(Unknown
Source)
at
java.lang.reflect.Field.getAccessor(Ljava.lang.Object;I)Ljrockit.reflect.FieldAccessor;(Unknown
Source)
at
java.lang.reflect.Field.get(Ljava.lang.Object;I)Ljava.lang.Object;(Unknown
Source)
at org.apache.xmlbeans.XmlBeans.typeSystemForClassLoader(XmlBeans.java:770)
at
org.openxmlformats.schemas.drawingml.x2006.main.ThemeDocument.<clinit>()V(Unknown
Source)
at
org.openxmlformats.schemas.drawingml.x2006.main.ThemeDocument$Factory.parse(Ljava.io.InputStream;)Lorg.openxmlformats.schemas.drawingml.x2006.main.ThemeDocument;(Unknown
Source)
at org.apache.poi.xssf.model.ThemesTable.<init>(ThemesTable.java:39)
at
jrockit.reflect.NativeConstructorInvoker.newInstance([Ljava.lang.Object;)Ljava.lang.Object;(Unknown
Source)
at
jrockit.reflect.InitialConstructorInvoker.newInstance([Ljava.lang.Object;)Ljava.lang.Object;(Unknown
Source)
at
java.lang.reflect.Constructor.newInstance([Ljava.lang.Object;I)Ljava.lang.Object;(Unknown
Source)
at
org.apache.poi.xssf.usermodel.XSSFFactory.createDocumentPart(XSSFFactory.java:59)
at org.apache.poi.POIXMLDocumentPart.read(POIXMLDocumentPart.java:277)
at org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:186)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:189)
at com.xxxx.rfid.util.Util.uploadFromXLSX(Util.java:350)
at com.xxxx.rfid.util.Util.modifyExcelFileAndUploadData(Util.java:168)
at com.xxxx.rfid.util.Util.uploadFile(Util.java:132)
at
pageflows.fileupload.FileuploadController.upload(FileuploadController.java:114)
at
jrockit.reflect.VirtualNativeMethodInvoker.invoke(Ljava.lang.Object;[Ljava.lang.Object;)Ljava.lang.Object;(Unknown
Source)
Caused by: java.lang.reflect.InvocationTargetException
at
jrockit.reflect.NativeConstructorInvoker.newInstance([Ljava.lang.Object;)Ljava.lang.Object;(Unknown
Source)
at
java.lang.reflect.Constructor.newInstance([Ljava.lang.Object;I)Ljava.lang.Object;(Unknown
Source)
at
schemaorg_apache_xmlbeans.system.sE130CAA0A01A7CDE5A2B4FEB8B311707.TypeSystemHolder.loadTypeSystem()Lorg.apache.xmlbeans.SchemaTypeSystem;(Unknown
Source)
at
schemaorg_apache_xmlbeans.system.sE130CAA0A01A7CDE5A2B4FEB8B311707.TypeSystemHolder.<clinit>()V(Unknown
Source)
at
jrockit.reflect.MemberAccess.newFieldAccessor(Ljava.lang.reflect.Field;Z)Ljrockit.reflect.FieldAccessor;(Unknown
Source)
at
java.lang.reflect.Field.acquireFieldAccessor(Z)Ljrockit.reflect.FieldAccessor;(Unknown
Source)
at
java.lang.reflect.Field.getAccessor(Ljava.lang.Object;I)Ljrockit.reflect.FieldAccessor;(Unknown
Source)
at
java.lang.reflect.Field.get(Ljava.lang.Object;I)Ljava.lang.Object;(Unknown
Source)
at org.apache.xmlbeans.XmlBeans.typeSystemForClassLoader(XmlBeans.java:770)
at
org.openxmlformats.schemas.drawingml.x2006.main.ThemeDocument.<clinit>()V(Unknown
Source)
at
org.openxmlformats.schemas.drawingml.x2006.main.ThemeDocument$Factory.parse(Ljava.io.InputStream;)Lorg.openxmlformats.schemas.drawingml.x2006.main.ThemeDocument;(Unknown
Source)
at org.apache.poi.xssf.model.ThemesTable.<init>(ThemesTable.java:39)
at
jrockit.reflect.NativeConstructorInvoker.newInstance([Ljava.lang.Object;)Ljava.lang.Object;(Unknown
Source)
at
jrockit.reflect.InitialConstructorInvoker.newInstance([Ljava.lang.Object;)Ljava.lang.Object;(Unknown
Source)
at
java.lang.reflect.Constructor.newInstance([Ljava.lang.Object;I)Ljava.lang.Object;(Unknown
Source)
at
org.apache.poi.xssf.usermodel.XSSFFactory.createDocumentPart(XSSFFactory.java:59)
at org.apache.poi.POIXMLDocumentPart.read(POIXMLDocumentPart.java:277)
at org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:186)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:189)
at com.xxx.rfid.util.Util.uploadFromXLSX(Util.java:350)
at com.xxxx.rfid.util.Util.modifyExcelFileAndUploadData(Util.java:168)
at com.xxxx.rfid.util.Util.uploadFile(Util.java:132)
at
pageflows.fileupload.FileuploadController.upload(FileuploadController.java:114)
Caused by: org.apache.xmlbeans.SchemaTypeLoaderException: XML-BEANS compiled
schema: Incompatible minor version - expecting up to 23, got 24
(schemaorg_apache_xmlbeans.system.sE130CAA0A01A7CDE5A2B4FEB8B311707.index) -
code 3
at
org.apache.xmlbeans.impl.schema.SchemaTypeSystemImpl$XsbReader.<init>(SchemaTypeSystemImpl.java:1522)
at
org.apache.xmlbeans.impl.schema.SchemaTypeSystemImpl.initFromHeader(SchemaTypeSystemImpl.java:260)
at
org.apache.xmlbeans.impl.schema.SchemaTypeSystemImpl.<init>(SchemaTypeSystemImpl.java:183)
at
jrockit.reflect.NativeConstructorInvoker.newInstance([Ljava.lang.Object;)Ljava.lang.Object;(Unknown
Source)
at
java.lang.reflect.Constructor.newInstance([Ljava.lang.Object;I)Ljava.lang.Object;(Unknown
Source)
at
schemaorg_apache_xmlbeans.system.sE130CAA0A01A7CDE5A2B4FEB8B311707.TypeSystemHolder.loadTypeSystem()Lorg.apache.xmlbeans.SchemaTypeSystem;(Unknown
Source)
at
schemaorg_apache_xmlbeans.system.sE130CAA0A01A7CDE5A2B4FEB8B311707.TypeSystemHolder.<clinit>()V(Unknown
Source)
at
jrockit.reflect.MemberAccess.newFieldAccessor(Ljava.lang.reflect.Field;Z)Ljrockit.reflect.FieldAccessor;(Unknown
Source)
at
java.lang.reflect.Field.acquireFieldAccessor(Z)Ljrockit.reflect.FieldAccessor;(Unknown
Source)
at
java.lang.reflect.Field.getAccessor(Ljava.lang.Object;I)Ljrockit.reflect.FieldAccessor;(Unknown
Source)
at
java.lang.reflect.Field.get(Ljava.lang.Object;I)Ljava.lang.Object;(Unknown
Source)
at org.apache.xmlbeans.XmlBeans.typeSystemForClassLoader(XmlBeans.java:770)
at
org.openxmlformats.schemas.drawingml.x2006.main.ThemeDocument.<clinit>()V(Unknown
Source)
at
org.openxmlformats.schemas.drawingml.x2006.main.ThemeDocument$Factory.parse(Ljava.io.InputStream;)Lorg.openxmlformats.schemas.drawingml.x2006.main.ThemeDocument;(Unknown
Source)
at org.apache.poi.xssf.model.ThemesTable.<init>(ThemesTable.java:39)
at
jrockit.reflect.NativeConstructorInvoker.newInstance([Ljava.lang.Object;)Ljava.lang.Object;(Unknown
Source)
at
jrockit.reflect.InitialConstructorInvoker.newInstance([Ljava.lang.Object;)Ljava.lang.Object;(Unknown
Source)
at
java.lang.reflect.Constructor.newInstance([Ljava.lang.Object;I)Ljava.lang.Object;(Unknown
Source)
at
org.apache.poi.xssf.usermodel.XSSFFactory.createDocumentPart(XSSFFactory.java:59)
at org.apache.poi.POIXMLDocumentPart.read(POIXMLDocumentPart.java:277)
at org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:186)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:189)
at com.XXX.rfid.util.Util.uploadFromXLSX(Util.java:350)
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Unable-to-Excel-2007-documents-using-XSSF-tp4434263p4434263.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Unable to Excel 2007 documents using XSSF
Posted by Nick Burch <ni...@alfresco.com>.
On Thu, 16 Feb 2012, pavanvusirika wrote:
> Can you please tell me the exact *maven dependency to be added* i have
> added below dependency in my maven project but getting the same error
>
> <dependency>
> <groupId>org.apache.xmlbeans</groupId>
> <artifactId>xmlbeans</artifactId>
> <version>2.3.0</version>
> </dependency>
If that's your only xmlbeans version then you should be fine. However, if
you still get the error, then you've also go another version from
somewhere - remove that older one and you should be fine
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Unable to Excel 2007 documents using XSSF
Posted by pavanvusirika <pa...@gmail.com>.
Can you please tell me the exact *maven dependency to be added* i have added
below dependency in my maven project but getting the same error
<dependency>
<groupId>org.apache.xmlbeans</groupId>
<artifactId>xmlbeans</artifactId>
<version>2.3.0</version>
</dependency>
Thanks,
Pavan
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Unable-to-Excel-2007-documents-using-XSSF-tp4434263p5489120.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Unable to Excel 2007 documents using XSSF
Posted by Nick Burch <ni...@alfresco.com>.
On Sun, 29 May 2011, JagadeeshK wrote:
> Now, removed that reference and used xmlbeans-2.3.0.jar. But, still iam
> getting following error.
Looks to be the same error about xmlbeans, even the bit about incorrect
schema versions is still there. You're still running on an older xmlbeans
jar...
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Unable to Excel 2007 documents using XSSF
Posted by JagadeeshK <kj...@gmail.com>.
Hi Nick,
I am using Weblogic Server 9.2. So, there was a apache_xbean.jar referenced
in my Weblogic platform.
Now, removed that reference and used xmlbeans-2.3.0.jar. But, still iam
getting following error.
Please explain me how to solve this, as i am new to this.
Error Stack trace:
java.lang.reflect.InvocationTargetException
org.apache.poi.POIXMLException: java.lang.reflect.InvocationTargetException
at
org.apache.poi.xssf.usermodel.XSSFFactory.createDocumentPart(XSSFFactory.java:61)
at org.apache.poi.POIXMLDocumentPart.read(POIXMLDocumentPart.java:277)
at org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:186)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:189)
at com.xxxx.rfid.util.Util.uploadFromXLSX(Util.java:350)
at com.xxxx.rfid.util.Util.modifyExcelFileAndUploadData(Util.java:168)
at com.xxxx.rfid.util.Util.uploadFile(Util.java:132)
at
pageflows.fileupload.FileuploadController.upload(FileuploadController.java:114)
at
jrockit.reflect.VirtualNativeMethodInvoker.invoke(Ljava.lang.Object;[Ljava.lang.Object;)Ljava.lang.Object;(Unknown
Source)
at
java.lang.reflect.Method.invoke(Ljava.lang.Object;[Ljava.lang.Object;I)Ljava.lang.Object;(Unknown
Source)
at
org.apache.beehive.netui.pageflow.FlowController.invokeActionMethod(FlowController.java:869)
at
org.apache.beehive.netui.pageflow.FlowController.getActionMethodForward(FlowController.java:808)
at
org.apache.beehive.netui.pageflow.FlowController.internalExecute(FlowController.java:477)
at
org.apache.beehive.netui.pageflow.PageFlowController.internalExecute(PageFlowController.java:305)
at
org.apache.beehive.netui.pageflow.FlowController.execute(FlowController.java:335)
at
org.apache.beehive.netui.pageflow.internal.FlowControllerAction.execute(FlowControllerAction.java:51)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
at
org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.access$201(PageFlowRequestProcessor.java:95)
at
org.apache.beehive.netui.pageflow.PageFlowRequestProcessor$ActionRunner.execute(PageFlowRequestProcessor.java:2042)
at
org.apache.beehive.netui.pageflow.interceptor.action.internal.ActionInterceptors.wrapAction(ActionInterceptors.java:90)
at
org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.processActionPerform(PageFlowRequestProcessor.java:2114)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at
org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.processInternal(PageFlowRequestProcessor.java:554)
at
org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.process(PageFlowRequestProcessor.java:851)
at
org.apache.beehive.netui.pageflow.AutoRegisterActionServlet.process(AutoRegisterActionServlet.java:630)
at
org.apache.beehive.netui.pageflow.PageFlowActionServlet.process(PageFlowActionServlet.java:157)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
Caused by: java.lang.reflect.InvocationTargetException
at
jrockit.reflect.NativeConstructorInvoker.newInstance([Ljava.lang.Object;)Ljava.lang.Object;(Unknown
Source)
at
jrockit.reflect.InitialConstructorInvoker.newInstance([Ljava.lang.Object;)Ljava.lang.Object;(Unknown
Source)
at
java.lang.reflect.Constructor.newInstance([Ljava.lang.Object;I)Ljava.lang.Object;(Unknown
Source)
at
org.apache.poi.xssf.usermodel.XSSFFactory.createDocumentPart(XSSFFactory.java:59)
at org.apache.poi.POIXMLDocumentPart.read(POIXMLDocumentPart.java:277)
at org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:186)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:189)
at com.xxxx.rfid.util.Util.uploadFromXLSX(Util.java:350)
at com.xxxx.rfid.util.Util.modifyExcelFileAndUploadData(Util.java:168)
at com.xxxx.rfid.util.Util.uploadFile(Util.java:132)
at
pageflows.fileupload.FileuploadController.upload(FileuploadController.java:114)
at
jrockit.reflect.VirtualNativeMethodInvoker.invoke(Ljava.lang.Object;[Ljava.lang.Object;)Ljava.lang.Object;(Unknown
Source)
at
java.lang.reflect.Method.invoke(Ljava.lang.Object;[Ljava.lang.Object;I)Ljava.lang.Object;(Unknown
Source)
at
org.apache.beehive.netui.pageflow.FlowController.invokeActionMethod(FlowController.java:869)
at
org.apache.beehive.netui.pageflow.FlowController.getActionMethodForward(FlowController.java:808)
at
org.apache.beehive.netui.pageflow.FlowController.internalExecute(FlowController.java:477)
at
org.apache.beehive.netui.pageflow.PageFlowController.internalExecute(PageFlowController.java:305)
at
org.apache.beehive.netui.pageflow.FlowController.execute(FlowController.java:335)
at
org.apache.beehive.netui.pageflow.internal.FlowControllerAction.execute(FlowControllerAction.java:51)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
at
org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.access$201(PageFlowRequestProcessor.java:95)
at
org.apache.beehive.netui.pageflow.PageFlowRequestProcessor$ActionRunner.execute(PageFlowRequestProcessor.java:2042)
at
org.apache.beehive.netui.pageflow.interceptor.action.internal.ActionInterceptors.wrapAction(ActionInterceptors.java:90)
at
org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.processActionPerform(PageFlowRequestProcessor.java:2114)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at
org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.processInternal(PageFlowRequestProcessor.java:554)
at
org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.process(PageFlowRequestProcessor.java:851)
at
org.apache.beehive.netui.pageflow.AutoRegisterActionServlet.process(AutoRegisterActionServlet.java:630)
Caused by: java.lang.ExceptionInInitializerError
at
jrockit.reflect.MemberAccess.newFieldAccessor(Ljava.lang.reflect.Field;Z)Ljrockit.reflect.FieldAccessor;(Unknown
Source)
at
java.lang.reflect.Field.acquireFieldAccessor(Z)Ljrockit.reflect.FieldAccessor;(Unknown
Source)
at
java.lang.reflect.Field.getAccessor(Ljava.lang.Object;I)Ljrockit.reflect.FieldAccessor;(Unknown
Source)
at
java.lang.reflect.Field.get(Ljava.lang.Object;I)Ljava.lang.Object;(Unknown
Source)
at org.apache.xmlbeans.XmlBeans.typeSystemForClassLoader(XmlBeans.java:770)
at
org.openxmlformats.schemas.drawingml.x2006.main.ThemeDocument.<clinit>()V(Unknown
Source)
at
org.openxmlformats.schemas.drawingml.x2006.main.ThemeDocument$Factory.parse(Ljava.io.InputStream;)Lorg.openxmlformats.schemas.drawingml.x2006.main.ThemeDocument;(Unknown
Source)
at org.apache.poi.xssf.model.ThemesTable.<init>(ThemesTable.java:39)
at
jrockit.reflect.NativeConstructorInvoker.newInstance([Ljava.lang.Object;)Ljava.lang.Object;(Unknown
Source)
at
jrockit.reflect.InitialConstructorInvoker.newInstance([Ljava.lang.Object;)Ljava.lang.Object;(Unknown
Source)
at
java.lang.reflect.Constructor.newInstance([Ljava.lang.Object;I)Ljava.lang.Object;(Unknown
Source)
at
org.apache.poi.xssf.usermodel.XSSFFactory.createDocumentPart(XSSFFactory.java:59)
at org.apache.poi.POIXMLDocumentPart.read(POIXMLDocumentPart.java:277)
at org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:186)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:189)
at com.citibank.rfid.util.Util.uploadFromXLSX(Util.java:350)
at com.citibank.rfid.util.Util.modifyExcelFileAndUploadData(Util.java:168)
at com.citibank.rfid.util.Util.uploadFile(Util.java:132)
at
pageflows.fileupload.FileuploadController.upload(FileuploadController.java:114)
at
jrockit.reflect.VirtualNativeMethodInvoker.invoke(Ljava.lang.Object;[Ljava.lang.Object;)Ljava.lang.Object;(Unknown
Source)
at
java.lang.reflect.Method.invoke(Ljava.lang.Object;[Ljava.lang.Object;I)Ljava.lang.Object;(Unknown
Source)
at
org.apache.beehive.netui.pageflow.FlowController.invokeActionMethod(FlowController.java:869)
at
org.apache.beehive.netui.pageflow.FlowController.getActionMethodForward(FlowController.java:808)
Caused by: java.lang.RuntimeException: Could not instantiate
SchemaTypeSystemImpl (java.lang.reflect.InvocationTargetException): is the
version of xbean.jar correct?
at
schemaorg_apache_xmlbeans.system.sE130CAA0A01A7CDE5A2B4FEB8B311707.TypeSystemHolder.loadTypeSystem()Lorg.apache.xmlbeans.SchemaTypeSystem;(Unknown
Source)
at
schemaorg_apache_xmlbeans.system.sE130CAA0A01A7CDE5A2B4FEB8B311707.TypeSystemHolder.<clinit>()V(Unknown
Source)
at
jrockit.reflect.MemberAccess.newFieldAccessor(Ljava.lang.reflect.Field;Z)Ljrockit.reflect.FieldAccessor;(Unknown
Source)
at
java.lang.reflect.Field.acquireFieldAccessor(Z)Ljrockit.reflect.FieldAccessor;(Unknown
Source)
at
java.lang.reflect.Field.getAccessor(Ljava.lang.Object;I)Ljrockit.reflect.FieldAccessor;(Unknown
Source)
at
java.lang.reflect.Field.get(Ljava.lang.Object;I)Ljava.lang.Object;(Unknown
Source)
at org.apache.xmlbeans.XmlBeans.typeSystemForClassLoader(XmlBeans.java:770)
at
org.openxmlformats.schemas.drawingml.x2006.main.ThemeDocument.<clinit>()V(Unknown
Source)
at
org.openxmlformats.schemas.drawingml.x2006.main.ThemeDocument$Factory.parse(Ljava.io.InputStream;)Lorg.openxmlformats.schemas.drawingml.x2006.main.ThemeDocument;(Unknown
Source)
at org.apache.poi.xssf.model.ThemesTable.<init>(ThemesTable.java:39)
at
jrockit.reflect.NativeConstructorInvoker.newInstance([Ljava.lang.Object;)Ljava.lang.Object;(Unknown
Source)
at
jrockit.reflect.InitialConstructorInvoker.newInstance([Ljava.lang.Object;)Ljava.lang.Object;(Unknown
Source)
at
java.lang.reflect.Constructor.newInstance([Ljava.lang.Object;I)Ljava.lang.Object;(Unknown
Source)
at
org.apache.poi.xssf.usermodel.XSSFFactory.createDocumentPart(XSSFFactory.java:59)
at org.apache.poi.POIXMLDocumentPart.read(POIXMLDocumentPart.java:277)
at org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:186)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:189)
at com.xxxx.rfid.util.Util.uploadFromXLSX(Util.java:350)
at com.xxxx.rfid.util.Util.modifyExcelFileAndUploadData(Util.java:168)
at com.xxxx.rfid.util.Util.uploadFile(Util.java:132)
at
pageflows.fileupload.FileuploadController.upload(FileuploadController.java:114)
at
jrockit.reflect.VirtualNativeMethodInvoker.invoke(Ljava.lang.Object;[Ljava.lang.Object;)Ljava.lang.Object;(Unknown
Source)
Caused by: java.lang.reflect.InvocationTargetException
at
jrockit.reflect.NativeConstructorInvoker.newInstance([Ljava.lang.Object;)Ljava.lang.Object;(Unknown
Source)
at
java.lang.reflect.Constructor.newInstance([Ljava.lang.Object;I)Ljava.lang.Object;(Unknown
Source)
at
schemaorg_apache_xmlbeans.system.sE130CAA0A01A7CDE5A2B4FEB8B311707.TypeSystemHolder.loadTypeSystem()Lorg.apache.xmlbeans.SchemaTypeSystem;(Unknown
Source)
at
schemaorg_apache_xmlbeans.system.sE130CAA0A01A7CDE5A2B4FEB8B311707.TypeSystemHolder.<clinit>()V(Unknown
Source)
at
jrockit.reflect.MemberAccess.newFieldAccessor(Ljava.lang.reflect.Field;Z)Ljrockit.reflect.FieldAccessor;(Unknown
Source)
at
java.lang.reflect.Field.acquireFieldAccessor(Z)Ljrockit.reflect.FieldAccessor;(Unknown
Source)
at
java.lang.reflect.Field.getAccessor(Ljava.lang.Object;I)Ljrockit.reflect.FieldAccessor;(Unknown
Source)
at
java.lang.reflect.Field.get(Ljava.lang.Object;I)Ljava.lang.Object;(Unknown
Source)
at org.apache.xmlbeans.XmlBeans.typeSystemForClassLoader(XmlBeans.java:770)
at
org.openxmlformats.schemas.drawingml.x2006.main.ThemeDocument.<clinit>()V(Unknown
Source)
at
org.openxmlformats.schemas.drawingml.x2006.main.ThemeDocument$Factory.parse(Ljava.io.InputStream;)Lorg.openxmlformats.schemas.drawingml.x2006.main.ThemeDocument;(Unknown
Source)
at org.apache.poi.xssf.model.ThemesTable.<init>(ThemesTable.java:39)
at
jrockit.reflect.NativeConstructorInvoker.newInstance([Ljava.lang.Object;)Ljava.lang.Object;(Unknown
Source)
at
jrockit.reflect.InitialConstructorInvoker.newInstance([Ljava.lang.Object;)Ljava.lang.Object;(Unknown
Source)
at
java.lang.reflect.Constructor.newInstance([Ljava.lang.Object;I)Ljava.lang.Object;(Unknown
Source)
at
org.apache.poi.xssf.usermodel.XSSFFactory.createDocumentPart(XSSFFactory.java:59)
at org.apache.poi.POIXMLDocumentPart.read(POIXMLDocumentPart.java:277)
at org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:186)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:189)
at com.xxxx.rfid.util.Util.uploadFromXLSX(Util.java:350)
at com.xxxx.rfid.util.Util.modifyExcelFileAndUploadData(Util.java:168)
at com.xxxx.rfid.util.Util.uploadFile(Util.java:132)
at
pageflows.fileupload.FileuploadController.upload(FileuploadController.java:114)
Caused by: org.apache.xmlbeans.SchemaTypeLoaderException: XML-BEANS compiled
schema: Incompatible minor version - expecting up to 23, got 24
(schemaorg_apache_xmlbeans.system.sE130CAA0A01A7CDE5A2B4FEB8B311707.index) -
code 3
at
org.apache.xmlbeans.impl.schema.SchemaTypeSystemImpl$XsbReader.<init>(SchemaTypeSystemImpl.java:1522)
at
org.apache.xmlbeans.impl.schema.SchemaTypeSystemImpl.initFromHeader(SchemaTypeSystemImpl.java:260)
at
org.apache.xmlbeans.impl.schema.SchemaTypeSystemImpl.<init>(SchemaTypeSystemImpl.java:183)
at
jrockit.reflect.NativeConstructorInvoker.newInstance([Ljava.lang.Object;)Ljava.lang.Object;(Unknown
Source)
at
java.lang.reflect.Constructor.newInstance([Ljava.lang.Object;I)Ljava.lang.Object;(Unknown
Source)
at
schemaorg_apache_xmlbeans.system.sE130CAA0A01A7CDE5A2B4FEB8B311707.TypeSystemHolder.loadTypeSystem()Lorg.apache.xmlbeans.SchemaTypeSystem;(Unknown
Source)
at
schemaorg_apache_xmlbeans.system.sE130CAA0A01A7CDE5A2B4FEB8B311707.TypeSystemHolder.<clinit>()V(Unknown
Source)
at
jrockit.reflect.MemberAccess.newFieldAccessor(Ljava.lang.reflect.Field;Z)Ljrockit.reflect.FieldAccessor;(Unknown
Source)
at
java.lang.reflect.Field.acquireFieldAccessor(Z)Ljrockit.reflect.FieldAccessor;(Unknown
Source)
at
java.lang.reflect.Field.getAccessor(Ljava.lang.Object;I)Ljrockit.reflect.FieldAccessor;(Unknown
Source)
at
java.lang.reflect.Field.get(Ljava.lang.Object;I)Ljava.lang.Object;(Unknown
Source)
at org.apache.xmlbeans.XmlBeans.typeSystemForClassLoader(XmlBeans.java:770)
at
org.openxmlformats.schemas.drawingml.x2006.main.ThemeDocument.<clinit>()V(Unknown
Source)
at
org.openxmlformats.schemas.drawingml.x2006.main.ThemeDocument$Factory.parse(Ljava.io.InputStream;)Lorg.openxmlformats.schemas.drawingml.x2006.main.ThemeDocument;(Unknown
Source)
at org.apache.poi.xssf.model.ThemesTable.<init>(ThemesTable.java:39)
at
jrockit.reflect.NativeConstructorInvoker.newInstance([Ljava.lang.Object;)Ljava.lang.Object;(Unknown
Source)
at
jrockit.reflect.InitialConstructorInvoker.newInstance([Ljava.lang.Object;)Ljava.lang.Object;(Unknown
Source)
at
java.lang.reflect.Constructor.newInstance([Ljava.lang.Object;I)Ljava.lang.Object;(Unknown
Source)
at
org.apache.poi.xssf.usermodel.XSSFFactory.createDocumentPart(XSSFFactory.java:59)
at org.apache.poi.POIXMLDocumentPart.read(POIXMLDocumentPart.java:277)
at org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:186)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:189)
at com.xxxx.rfid.util.Util.uploadFromXLSX(Util.java:350)
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Unable-to-Excel-2007-documents-using-XSSF-tp4434263p4438191.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Unable to Excel 2007 documents using XSSF
Posted by Nick Burch <ni...@alfresco.com>.
On Fri, 27 May 2011, JagadeeshK wrote:
> I am using following jars,
>
> poi-3.7-20101029.jar
> poi-ooxml-3.7-20101029.jar
> poi-ooxml-schemas-3.7-20101029.jar
> dom4j-1.6.1.jar
> xmlbeans-2.3.0.jar
Fairly sure you're not using xmlbeans 2.3, but you're instead using an
earlier version. Too key hints in your stacktrace for this:
> Caused by: java.lang.RuntimeException: Could not instantiate
> SchemaTypeSystemImpl (java.lang.reflect.InvocationTargetException): is the
> version of xbean.jar correct?
> Caused by: org.apache.xmlbeans.SchemaTypeLoaderException: XML-BEANS compiled
> schema: Incompatible minor version - expecting up to 23, got 24
> (schemaorg_apache_xmlbeans.system.sE130CAA0A01A7CDE5A2B4FEB8B311707.index) -
> code 3
You need to remove whatever older versions of xmlbeans you have kicking
around, and ensure you instead use 2.3 (or newer)
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org