I¹m trying to create an Excel spreadsheet that has > 255 columns.
The ExcelGenerator throws an exception . We use poi-3.6-20091214.jar and I
have Excel 2008 for Mac which allows up to 16k columns.
com.webobjects.foundation.NSForwardException:
java.lang.IllegalArgumentException: Invalid column index (256). Allowable
column range for BIFF8 is (0..255) or ('A'..'IV')
java.lang.IllegalArgumentException: Invalid column index (256). Allowable
column range for BIFF8 is (0..255) or ('A'..'IV')
Do5zXbOhkHWrEn9yRYcfqM Thu, 18 Nov 2010 14:07:13
I found this:
http://stackoverflow.com/questions/2326668/how-to-get-more-than-255-columns-
in-an-excel-sheet-using-apache-poi-3-6
One of the responders said that they: had to switch from the
org.apache.poi.hssf.usermodel to the org.apache.poi.ss.usermodel
The only place I see org.apache.poi.hssf.usermodel imported is in
EGSimpleTableCreator and EGSimpleTableParser.java.
Just switching out the packages in those two classes gives LOTS of errors
because org.apache.poi.ss.usermodel doesn¹t have all the classes that
org.apache.poi.hssf.usermodel has, so I¹m wondering is there another way I
can switch out these two packages? OR is this not the solution?
Thanks in advance.
Paula
--
Paula Loehr
K12 Inc
719-460-4350
[email protected]
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
