You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2019/09/13 10:30:28 UTC
[Bug 63748] New: Automatically create new sheet when row count
exceeds 1048576.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63748
Bug ID: 63748
Summary: Automatically create new sheet when row count exceeds
1048576.
Product: POI
Version: unspecified
Hardware: PC
Status: NEW
Severity: enhancement
Priority: P2
Component: SXSSF
Assignee: dev@poi.apache.org
Reporter: nileshwani.vit@gmail.com
Target Milestone: ---
I have a requirement where i need to create a new sheet and write the
overflowing data(1048576+ rows) on that sheet.
I can do it by creating a code which keeps a counter each time before creating
a new row and create a new sheet and continue writing the remaining data on new
sheet.
I need to know is there any API that does the same or if any tried and tested
way available already ?
currently Using POI 3.16
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 63748] Automatically create new sheet when row count exceeds
1048576.
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63748
gallon.fizik@gmail.com <ga...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
OS| |All
--- Comment #1 from gallon.fizik@gmail.com <ga...@gmail.com> ---
Hello Nilesh,
unfortunately there's no such API call as it's not something Excel/POI does.
I suggest you to implement some Supplier<Row> which will track its position on
a sheet and create a new one, if necessary.
P.S. You probably don't need a counter, just hold a reference to the last/newly
created row and compare its index to the
SpreadsheetVersion.yourVersion().getMaxRowIndex() (may not remember the name
exactly).
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 63748] Automatically create new sheet when row count exceeds
1048576.
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=63748
PJ Fanning <fa...@yahoo.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |WONTFIX
Status|NEW |RESOLVED
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org