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 2018/04/26 17:53:54 UTC

[Bug 62328] Add support for blind cloning elements from XSSF that are not directly supported

https://bz.apache.org/bugzilla/show_bug.cgi?id=62328

Greg Woolsey <gr...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |NEEDINFO
                 OS|                            |All

--- Comment #1 from Greg Woolsey <gr...@gmail.com> ---
I'm curious why you need the streaming API?  Are you adding a million rows to a
thousand sheets?  If you open the template using the XSSF API, you can then
just update the first row of data with real values, then insert all the
additional rows, set their style references to match the corresponding cell
from the first row, and write it out to a new destination.

I've done that for years, with up to a million total rows of data.  Are you
needing to process a large amount in parallel or with much more data than that?
 Those are the only cases I can think of where the memory savings for the
streaming API would be particularly important.

The XSSF API is very good at leaving well enough alone for elements it doesn't
know about or has poor support for.  With this method no object copying is
needed, as you read the template directly but write the modified result
somewhere else.

-- 
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