Thank you so much! Apparently I forgot to load all the secondary jar files into my library path. Problem solved!
Ben -----Original Message----- From: Kalpesh Modi [mailto:[email protected]] Sent: Monday, July 12, 2010 6:12 PM To: POI Users List Subject: RE: Newbie with Column Count Problems It seems like you are missing org.apache.xmlbeans.XmlException on your class path. Have you included xbean.jar? Thanks and regards, -Kalpesh -----Original Message----- From: Benjamin Elbirt [mailto:[email protected]] Sent: Monday, July 12, 2010 5:25 PM To: [email protected] Subject: Newbie with Column Count Problems Hello Everyone and thanks for taking the time to read/respond to my issues. I am new with POI so please excuse the newbie question. Ok, so I started with HSSF and was able to write an XLS file; however (as expected) I ran into the problem of having too many columns (> 255). So, I switched all the HSSF commands to XSSF commands and tried again. The results were: Exception in thread "Thread-4" java.lang.NoClassDefFoundError: org/apache/xmlbeans/XmlException Caused by: java.lang.ClassNotFoundException: org.apache.xmlbeans.XmlException at java.net.URLClassLoader$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) The code it refers to reads: XSSFWorkbook wb = new XSSFWorkbook(); In a nutshell, I am trying to create an XLSX file because this format allows for column counts > 256; which is the most important thing I need. Otherwise, Excel 2007 is no better than 97 for my purposes. Any help achieving this goal would be greatly appreciated. Ben --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] . The information contained in this e-mail message is intended only for the personal and confidential use of the recipient(s) named above. This message is privileged and confidential. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. --------------------------------------------------------------------- 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]
