Hi there,
because the creation of workbook instances is pretty costly (about 200ms
to 15 seconds for the workbooks we are dealing with) we implemented a
pooling of workbook instances which seems to work pretty well.
Since we are only performing limited write-operations on the workbook
instances (basically only calling Cell.setCellType() and
Cell.setCellValue()) we need a way of "cloning" the original workbook
values when retrieving a workbook instance from the pool, remembering
them and "reseting" the workbook instance when returning it to the pool
by setting all those remembered values to the workbook instance.
I'm wondering if there is already a functionality like this in poi or if
somebody already did sth. similar? Otherwhise I'll have to write sth. by
my own (which shouldn't be too hard) - but I thought that I'll ask
anyway.
Performing a deep clone of the complete workbook is not an option as
this would make the whole pooling idea pointless.
Best Regards
Kai
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
