I worked through all the java exceptions in my code and created a .xlsx document using poi-3.5-beta1. I can unzip the document and it appears to be a at least a great attempt at the OOXML format. The sheet1.xml file has the data in it that it should. Problem is, when I try to open the document in excel 2007, I get a message saying "The converter could not open the file." I have no idea how to troubleshoot it from here unless I manually dig through the OOXML specs. Is there some sort of validator I can use to find out what is wrong with the OOXML file? What is the best way to proceed?
Thanks, Paul Dobson -----Original Message----- From: Dobson, Paul L CTR USAF AFMC 416 SCMS/OBN [mailto:[EMAIL PROTECTED] Sent: Friday, July 25, 2008 11:09 AM To: POI Users List Subject: RE: poi-3.5-beta1 "new XSSFWorkbook();" Throws "org/openxml4j/exceptions/InvalidFormatException" I got past the error. Turns out, I didn't have openxml4j-bin-alpha-080407.jar in my classpath. Thanks for getting me to look at the stack trace. Below is the stack trace if you still care to see it: Stacktrace: at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServle tWrapper.java:524) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.ja va:417) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica tionFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt erChain.java:206) at org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFi lter.java:390) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica tionFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt erChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv e.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv e.java:175) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authenticator Base.java:525) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java :128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java :102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve. java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:2 63) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:84 4) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process( Http11Protocol.java:584) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Thread.java:619) Caused by: javax.servlet.ServletException: java.lang.NoClassDefFoundError: org/openxml4j/exceptions/InvalidFormatException at org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageCont extImpl.java:850) at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContex tImpl.java:779) at org.apache.jsp.BackOrderRaw_jsp._jspService(BackOrderRaw_jsp.java:668) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.ja va:393) ... 19 more Caused by: java.lang.NoClassDefFoundError: org/openxml4j/exceptions/InvalidFormatException at WebAppClasses.XexcelRpt.<init>(XexcelRpt.java:55) at org.apache.jsp.BackOrderRaw_jsp._jspService(BackOrderRaw_jsp.java:556) ... 22 more Paul Dobson -----Original Message----- From: Nick Burch [mailto:[EMAIL PROTECTED] Sent: Friday, July 25, 2008 10:24 AM To: POI Users List Subject: Re: poi-3.5-beta1 "new XSSFWorkbook();" Throws "org/openxml4j/exceptions/InvalidFormatException" On Fri, 25 Jul 2008, Dobson, Paul L CTR USAF AFMC 416 SCMS/OBN wrote: > I'm trying to get a head start migrating some POI code to use OOXML > using poi-3.5-beta1. Can you post the full stacktrace? I'm not sure what's up without that, as we have lots of tests that do the same thing which pass just fine Nick --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
