We use the Aspose.Cells libraries for Excel. They offer manipulation of any
sized Excel sheet and a lot more features.
Aspose.Total is a good grab bag of file format support that is under constant
development.
Karl
On 2010-11-19, at 12:34 AM, Paula Loehr wrote:
> 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/kgretton%40mac.com
>
> This email sent to [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]
