You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Benjamin Elbirt <sa...@yahoo.com> on 2010/07/12 23:24:47 UTC
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
RE: Newbie with Column Count Problems
Posted by Benjamin Elbirt <sa...@yahoo.com>.
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:kalpesh.modi@plateau.com]
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:sarq_6669@yahoo.com]
Sent: Monday, July 12, 2010 5:25 PM
To: user@poi.apache.org
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
.
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
RE: Newbie with Column Count Problems
Posted by Kalpesh Modi <ka...@plateau.com>.
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:sarq_6669@yahoo.com]
Sent: Monday, July 12, 2010 5:25 PM
To: user@poi.apache.org
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
.
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org