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: [email protected]
For additional commands, e-mail: [email protected]
