Summary: | Automatically create new sheet when row count exceeds 1048576. | ||
---|---|---|---|
Product: | POI | Reporter: | Nilesh <nileshwani.vit> |
Component: | SXSSF | Assignee: | POI Developers List <dev> |
Status: | RESOLVED WONTFIX | ||
Severity: | enhancement | ||
Priority: | P2 | ||
Version: | unspecified | ||
Target Milestone: | --- | ||
Hardware: | PC | ||
OS: | All |
Description
Nilesh
2019-09-13 10:30:28 UTC
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). |