You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by mihaela olteanu <mi...@yahoo.com> on 2012/10/31 13:19:26 UTC
Corrupted Excels in 2007 format with large number of rows and columns produced with Apache POI Streaming Usermodel API
Hello,
I have taken the example from page: http://poi.apache.org/spreadsheet/how-to.html#sxssf and tried to create an Excel with 900 000 rows and 255 columns.
When I try opening the generated file with Microsoft Excel 2007 I get an exception that it has found "unreadable content" and the file is opened only after the repairing phase.
This doesn't happen when I keep the number of rows but I decrease the number of columns to 70, or when I decrease the number of rows and have a larger value for the columns.
Is this a bug? I don't see what could be wrong with the code.
Please find attach the project that I have created.
Thank you in advance!
Mihaela
Re: Corrupted Excels in 2007 format produced with Apache POI
Streaming Usermodel API
Posted by Yegor Kozlov <ye...@dinom.ru>.
Please try with the latest buiuld from trunk, many bugs have been
fixed since POI-3.8.
the link to nightly builds is on http://poi.apache.org/
On Mon, Nov 12, 2012 at 2:47 PM, mihaela olteanu <mi...@yahoo.com> wrote:
> Yes, I'm using that code and apache poi 3.8. Please see the attached code.
>
> Thanks!
>
> ________________________________
> From: Yegor Kozlov <ye...@dinom.ru>
> To: POI Users List <us...@poi.apache.org>; mihaela olteanu
> <mi...@yahoo.com>
> Sent: Monday, November 12, 2012 5:24 AM
> Subject: Re: Corrupted Excels in 2007 format produced with Apache POI
> Streaming Usermodel API
>
> Are you using the exact code from the example? It works OK for me.
>
> On Mon, Nov 12, 2012 at 12:45 PM, mihaela olteanu <mi...@yahoo.com>
> wrote:
>> Hello,
>>
>> Has anyone bumped into this problem? Is it a problem with the code that
>> produces the Excel?
>>
>> Thanks!
>> Mihaela
>>
>>
>>
>>
>> ________________________________
>> From: mihaela<mi...@yahoo.com>
>> To: POI Users List <us...@poi.apache.org>
>> Sent: Wednesday, October 31, 2012 8:19 AM
>> Subject: Corrupted Excels in 2007 format with large number of rows and
>> columns produced with Apache POI Streaming Usermodel API
>>
>>
>> Hello,
>>
>>
>> I have taken the example from page:
>> http://poi.apache.org/spreadsheet/how-to.html#sxssf and tried to create an
>> Excel with 900 000 rows and 255 columns.
>>
>> When I try opening the generated file with Microsoft Excel 2007 I get an
>> exception that it has found "unreadable content" and the file is opened only
>> after the repairing phase.
>> This doesn't happen when I keep the number of rows but I decrease the
>> number of columns to 70, or when I decrease the number of rows and have a
>> larger value for the columns.
>>
>> Is this a bug? I don't see what could be wrong with the code.
>>
>>
>> Please find attach the project that I have created.
>>
>> Thank you in advance!
>> Mihaela
>
> ---------------------------------------------------------------------
> 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
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Corrupted Excels in 2007 format produced with Apache POI Streaming Usermodel API
Posted by mihaela olteanu <mi...@yahoo.com>.
Yes, I'm using that code and apache poi 3.8. Please see the attached code.
Thanks!
________________________________
From: Yegor Kozlov <ye...@dinom.ru>
To: POI Users List <us...@poi.apache.org>; mihaela olteanu <mi...@yahoo.com>
Sent: Monday, November 12, 2012 5:24 AM
Subject: Re: Corrupted Excels in 2007 format produced with Apache POI Streaming Usermodel API
Are you using the exact code from the example? It works OK for me.
On Mon, Nov 12, 2012 at 12:45 PM, mihaela olteanu <mi...@yahoo.com> wrote:
> Hello,
>
> Has anyone bumped into this problem? Is it a problem with the code that produces the Excel?
>
> Thanks!
> Mihaela
>
>
>
>
> ________________________________
> From: mihaela<mi...@yahoo.com>
> To: POI Users List <us...@poi.apache.org>
> Sent: Wednesday, October 31, 2012 8:19 AM
> Subject: Corrupted Excels in 2007 format with large number of rows and columns produced with Apache POI Streaming Usermodel API
>
>
> Hello,
>
>
> I have taken the example from page: http://poi.apache.org/spreadsheet/how-to.html#sxssf and tried to create an Excel with 900 000 rows and 255 columns.
>
> When I try opening the generated file with Microsoft Excel 2007 I get an exception that it has found "unreadable content" and the file is opened only after the repairing phase.
> This doesn't happen when I keep the number of rows but I decrease the number of columns to 70, or when I decrease the number of rows and have a larger value for the columns.
>
> Is this a bug? I don't see what could be wrong with the code.
>
>
> Please find attach the project that I have created.
>
> Thank you in advance!
> Mihaela
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Corrupted Excels in 2007 format produced with Apache POI
Streaming Usermodel API
Posted by Yegor Kozlov <ye...@dinom.ru>.
Are you using the exact code from the example? It works OK for me.
On Mon, Nov 12, 2012 at 12:45 PM, mihaela olteanu <mi...@yahoo.com> wrote:
> Hello,
>
> Has anyone bumped into this problem? Is it a problem with the code that produces the Excel?
>
> Thanks!
> Mihaela
>
>
>
>
> ________________________________
> From: mihaela<mi...@yahoo.com>
> To: POI Users List <us...@poi.apache.org>
> Sent: Wednesday, October 31, 2012 8:19 AM
> Subject: Corrupted Excels in 2007 format with large number of rows and columns produced with Apache POI Streaming Usermodel API
>
>
> Hello,
>
>
> I have taken the example from page: http://poi.apache.org/spreadsheet/how-to.html#sxssf and tried to create an Excel with 900 000 rows and 255 columns.
>
> When I try opening the generated file with Microsoft Excel 2007 I get an exception that it has found "unreadable content" and the file is opened only after the repairing phase.
> This doesn't happen when I keep the number of rows but I decrease the number of columns to 70, or when I decrease the number of rows and have a larger value for the columns.
>
> Is this a bug? I don't see what could be wrong with the code.
>
>
> Please find attach the project that I have created.
>
> Thank you in advance!
> Mihaela
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Corrupted Excels in 2007 format produced with Apache POI Streaming Usermodel API
Posted by mihaela olteanu <mi...@yahoo.com>.
Hello,
Has anyone bumped into this problem? Is it a problem with the code that produces the Excel?
Thanks!
Mihaela
________________________________
From: mihaela<mi...@yahoo.com>
To: POI Users List <us...@poi.apache.org>
Sent: Wednesday, October 31, 2012 8:19 AM
Subject: Corrupted Excels in 2007 format with large number of rows and columns produced with Apache POI Streaming Usermodel API
Hello,
I have taken the example from page: http://poi.apache.org/spreadsheet/how-to.html#sxssf and tried to create an Excel with 900 000 rows and 255 columns.
When I try opening the generated file with Microsoft Excel 2007 I get an exception that it has found "unreadable content" and the file is opened only after the repairing phase.
This doesn't happen when I keep the number of rows but I decrease the number of columns to 70, or when I decrease the number of rows and have a larger value for the columns.
Is this a bug? I don't see what could be wrong with the code.
Please find attach the project that I have created.
Thank you in advance!
Mihaela