You cannot have more than 255 columns in a given row when creating Excel spreadsheet
You cannot have more than 255 columns in a given row when creating Excel spreadsheet
- Subject: You cannot have more than 255 columns in a given row when creating Excel spreadsheet
- From: Paula Loehr <email@hidden>
- Date: Thu, 18 Nov 2010 14:34:54 -0700
- Thread-topic: You cannot have more than 255 columns in a given row when creating Excel spreadsheet
Title: You cannot have more than 255 columns in a given row when creating Excel spreadsheet
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@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden