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]
