https://bz.apache.org/bugzilla/show_bug.cgi?id=57882
Bug ID: 57882
Summary: allow appending to large workbooks without reading
Product: POI
Version: 3.10-FINAL
Hardware: PC
Status: NEW
Severity: major
Priority: P2
Component: XSSF
Assignee: [email protected]
Reporter: [email protected]
As a developer and POI user I want to be able to append sheets to an existing
very large workbook as quickly as possible so that I can allow my application
users to update existing workbooks easily
Specifically I am looking for the ability to point POI at a very large workbook
and say 'add these sheets to it' without having to deal with any of the already
existing content in that workbook. If you would humor a little bit of feature
creep and speculative development: I suspect many users would appreciate a mode
whereby they can append rows to an existing sheet.
Currently the only method (given a small heap space) to do this would be to use
the XSSF workbook with a SAX driver and lazy reading scheme, streaming its
content to 'the front' of an SXSSF workbook, such that all the contents of the
existing workbook can be put into the SXSSF instances file buffer. Once that
(long running) task is finished, I can append any new data to the back of that
SXSSF workbook.
Worth noting, that while I'm pretty sure this strategy would work, after a 20
minute implementation I haven't got it working: creating my XSSF workbook with
the package object in READ mode appears to do some amount of fairly aggressive
prefetching, which is causing heap space errors.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
