Re: [Excel] - Maximum column with EGSimpleTableCreator
Re: [Excel] - Maximum column with EGSimpleTableCreator
- Subject: Re: [Excel] - Maximum column with EGSimpleTableCreator
- From: Theodore Petrosky <email@hidden>
- Date: Fri, 05 Apr 2013 07:25:00 -0700 (PDT)
JasperReports uses POI and I seem to recall when I tried to update it to the current version, there were all kinds of problems.
Let's not break anything by updating POI here.
Ted
--- On Wed, 4/3/13, Tobias Janz <email@hidden> wrote:
From: Tobias Janz <email@hidden>
Subject: Re: [Excel] - Maximum column with EGSimpleTableCreator
To: "email@hidden Development" <email@hidden>
Date: Wednesday, April 3, 2013, 5:43 PM
Hi,
looks like nobody has used the ExcelGenerator-Framework with more than 255 Columns or a bit abstract with the xlsx-Format.
Maybe you could write an extension?
Also the version of the poi-jar is out of date, 3.9 is the latest stable version (3.6 is 3 years old).
Looks like the SS Usermodel is a good idea.
Tobias
2013/4/3 Dev WO <email@hidden>
I'm sure I won't be able to fit more than 255 columns in this one either;)
Xavier
On 3 avr. 2013, at 19:21, Alan Ward <email@hidden> wrote:
>
> What's Excel? I thought it was a car :)
>
> http://en.wikipedia.org/wiki/Lotus_Excel
>
> Alan
>
>
> On Apr 3, 2013, at 11:09 AM, Dev WO <email@hidden> wrote:
>
>> I don't want to believe I'm the only one on this list to have to deal with Excel;)
>> Any pointer/recommendation regarding the Excel generation column limit?
>>
>> Thanks,
>>
>> Xavier
>>
>> On 28 mars 2013, at 20:54, Dev WO <email@hidden> wrote:
>>
>>> Hello list,
>>>
>>> I found a thread from 2010 about this, mentioning the the pre-2007 Excel limitation regarding the number of columns.
>>> I looked at the code from EGSimpleTableParser and EGSimpleTableCreator and related Properties' file but didn't find anything in them related to this limitation.
>>> It looks like the only way to get more than 255 columns in Excel is using the xlsx format through org.apache.poi.ss.usermodel instead of the org.apache.poi.hssf.usermodel.
>>>
>>> I'm wondering how people creating Excel export on this list are handling that, are you all using Aspose or did I overlooked something in Wonder?
>>>
>>> Thanks,
>>>
>>> Xavier
>>>
>>>
>>> _______________________________________________
>>> 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
>>>
>>>
>>
>>
>> _______________________________________________
>> 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
>
>
>
_______________________________________________
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
-----Inline Attachment Follows-----
_______________________________________________
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
_______________________________________________
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