[Bug 61832] New: Unable to create a excel of 500,000 rows and 150 column using SXSSF workbook

classic Classic list List threaded Threaded
27 messages Options
12
Reply | Threaded
Open this post in threaded view
|

[Bug 61832] Unable to create a excel of 500,000 rows and 150 column using SXSSF workbook

Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=61832

--- Comment #20 from PJ Fanning <[hidden email]> ---
There is a Pull Request which uses temp files for constructing the shared
strings table.
https://github.com/apache/poi/pull/85

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 61832] Unable to create a excel of 500,000 rows and 150 column using SXSSF workbook

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=61832

--- Comment #21 from Thamodharan <[hidden email]> ---
Hi Fanning,

I went through the pull request in github, really great. Is there a chance to
expect complete code in upcoming version of apache poi ?

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 61832] Unable to create a excel of 500,000 rows and 150 column using SXSSF workbook

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=61832

--- Comment #22 from Marion <[hidden email]> ---
This is still an issue. Can anyone from the Apache team confirm this issue will
be resolved with the new release?

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 61832] Unable to create a excel of 500,000 rows and 150 column using SXSSF workbook

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=61832

--- Comment #23 from PJ Fanning <[hidden email]> ---
There have been no changes made to POI for this.
1. If you use inline strings, the issue appears to be that Excel itself baulks
at the large dataset (eg Comment 7 above).
2. Comment 16 above highlights a workaround where shared strings are used -
this workaround would require a manual build of my Poi branch or to wait until
Poi 4 is released so that I can release my extension.

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 61832] Unable to create a excel of 500,000 rows and 150 column using SXSSF workbook

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=61832

--- Comment #24 from Thamodharan <[hidden email]> ---
@Fanning,

In below link,

https://poi.apache.org/changes.html

under History of Changes
Version 4.0.0-SNAPSHOT (2018-08-??)

The change 61832 / Github-85 is not involved.

As you replied to marion, can we expect this in upcoming release ?

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 61832] Unable to create a excel of 500,000 rows and 150 column using SXSSF workbook

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=61832

--- Comment #25 from PJ Fanning <[hidden email]> ---
https://github.com/pjfanning/poi-shared-strings is an extension to poi that may
help - will be released as soon as POI 4.0.0 is released (it relies on changes
in POI 4.0.0).

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 61832] Unable to create a excel of 500,000 rows and 150 column using SXSSF workbook

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=61832

--- Comment #26 from PJ Fanning <[hidden email]> ---
POI 4.0.0 and poi-shared-strings 1.0.0 are now released.

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

12