Bug 52973 - Enable some rows to be excluded from the stream so that they can be post processed
Summary: Enable some rows to be excluded from the stream so that they can be post proc...
Status: RESOLVED WORKSFORME
Alias: None
Product: POI
Classification: Unclassified
Component: SXSSF (show other bugs)
Version: unspecified
Hardware: PC All
: P2 enhancement (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-03-22 19:57 UTC by Jim Talbut
Modified: 2016-04-10 06:29 UTC (History)
0 users



Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Jim Talbut 2012-03-22 19:57:31 UTC
For my uses of POI I have to write a large number of cells to a worksheet and then go back and insert a small number of images.
I can't insert the images before the data because the insertion of the data may involve resizing the column widths, and that would break the aspect ratio on the images.

Current SXSSF doesn't allow me to go back to insert the images.

It would be useful if some rows could be flagged to be kept in memory.

This would obviously complicate the streaming - you'd have to stream a block of rows, then output a block from memory, then stream another block, etc.
Comment 1 Dominik Stadler 2015-03-23 20:58:15 UTC
SXSSF now has the constructor SXSSFWorkbook(int rowAccessWindowSize), which allows to keep a certain number of rows in memory, doesn't that allow you to do what you want?
Comment 2 Dominik Stadler 2016-04-10 06:29:30 UTC
Resolving this one for now, please report a new bug-issue if the current approach does not work for you.