You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by dhwanipatel <dh...@monumental-i.com> on 2012/03/08 18:14:00 UTC
POI-3.8-beta5 SXSSFWorkbook sheet blank lines
Hello,
I am using POI-3.8-beta5 SXSSFWorkbook to generate a .xlsx sheet of about
50K lines in a for loop of Info A, B, C and D lines.
It works great but when I see generated file into OpenOffice / MS Excel - It
displays Info A, B, C and D lines correctly until 32769 lines. After that
line I can only see Info A and D and the lines where should be B and C info
are displayed empty. (In debug it should have written the info there).
Workbook wb = new SXSSFWorkbook(100); // Auto flush for previous to 100
lines
((SXSSFWorkbook)wb).setCompressTempFiles(true); // with or without it
produce same result
I wonder if this is the bug to the API - do we have certain limit on number
of lines ?
Any help would be helpful.
Thanks,
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/POI-3-8-beta5-SXSSFWorkbook-sheet-blank-lines-tp5548164p5548164.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: POI-3.8-beta5 SXSSFWorkbook sheet blank lines
Posted by dhwanipatel <dh...@monumental-i.com>.
Newer build from trunk solved the issue...
Thank you so much for the help!
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/POI-3-8-beta5-SXSSFWorkbook-sheet-blank-lines-tp5548164p5562002.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: POI-3.8-beta5 SXSSFWorkbook sheet blank lines
Posted by Yegor Kozlov <ye...@dinom.ru>.
Checkout the source code from svn (
http://svn.apache.org/repos/asf/poi/trunk/ ) and then run "ant jar".
This will build all poi artifacts.
Yegor
On Mon, Mar 12, 2012 at 10:39 PM, dhwanipatel <dh...@monumental-i.com> wrote:
> Hello,
>
> Thanks for the reply!
>
> How would I exactly get the latest build of trunk that can be used in my src
> program too. (I mean the import for java code is valid).
>
> Thanks,
>
> --
> View this message in context: http://apache-poi.1045710.n5.nabble.com/POI-3-8-beta5-SXSSFWorkbook-sheet-blank-lines-tp5548164p5558695.html
> Sent from the POI - User mailing list archive at Nabble.com.
>
> ---------------------------------------------------------------------
> 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: POI-3.8-beta5 SXSSFWorkbook sheet blank lines
Posted by dhwanipatel <dh...@monumental-i.com>.
Hello,
Thanks for the reply!
How would I exactly get the latest build of trunk that can be used in my src
program too. (I mean the import for java code is valid).
Thanks,
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/POI-3-8-beta5-SXSSFWorkbook-sheet-blank-lines-tp5548164p5558695.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: POI-3.8-beta5 SXSSFWorkbook sheet blank lines
Posted by Yegor Kozlov <ye...@dinom.ru>.
Firstly, please try the latest build from trunk. There have been many
changes in SXSSF since 3.8-beta5 and there is a good chance your
problem is already fixed.
If the problem is still there, please try to write an isolated test
program that demonstrates it and post its source code. It might be a
bug or you are doing something wrong or both. In any case we need more
information to help you.
Yegor
On Thu, Mar 8, 2012 at 9:14 PM, dhwanipatel <dh...@monumental-i.com> wrote:
> Hello,
>
> I am using POI-3.8-beta5 SXSSFWorkbook to generate a .xlsx sheet of about
> 50K lines in a for loop of Info A, B, C and D lines.
>
> It works great but when I see generated file into OpenOffice / MS Excel - It
> displays Info A, B, C and D lines correctly until 32769 lines. After that
> line I can only see Info A and D and the lines where should be B and C info
> are displayed empty. (In debug it should have written the info there).
>
> Workbook wb = new SXSSFWorkbook(100); // Auto flush for previous to 100
> lines
> ((SXSSFWorkbook)wb).setCompressTempFiles(true); // with or without it
> produce same result
>
> I wonder if this is the bug to the API - do we have certain limit on number
> of lines ?
>
> Any help would be helpful.
>
> Thanks,
>
>
> --
> View this message in context: http://apache-poi.1045710.n5.nabble.com/POI-3-8-beta5-SXSSFWorkbook-sheet-blank-lines-tp5548164p5548164.html
> Sent from the POI - User mailing list archive at Nabble.com.
>
> ---------------------------------------------------------------------
> 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