poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 60397] very slow Cell Merge for SXSSFWorkbook
Date Thu, 05 Jan 2017 09:53:46 GMT

--- Comment #4 from Javen O'Neal <onealj@apache.org> ---
It would probably be faster for us to read the merged regions into a java List
and discard the CTMergedRegions, operate on the Java List, and then recreate
the CTMergedRegions XML nodes when writing the workbook. Not sure whether this
would improve the speed here, but I'm guessing worksheet.getMergeCells() and
ctMergeCells.addNewMergeCell() are expensive calls since it's creating and
linking XML nodes in a DOM. This work could be deferred to when the workbook is
written out.

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

View raw message