Bug 22735 - [RFE] Copy HSSFSheet Between HSSFWorkbooks
Summary: [RFE] Copy HSSFSheet Between HSSFWorkbooks
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 1.5.1
Hardware: Sun Solaris
: P3 enhancement with 4 votes (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2003-08-26 19:31 UTC by Dennis Trask
Modified: 2008-05-10 20:07 UTC (History)
0 users

Ignore this (4 bytes, text/plain)
2007-03-29 06:13 UTC, Dharma
Please ignore (13.50 KB, application/octet-stream)
2007-03-29 06:15 UTC, Dharma

Note You need to log in before you can comment on or make changes to this bug.
Description Dennis Trask 2003-08-26 19:31:45 UTC
The ability to retrieve a HSSFSheet object from one HSSFWorkbook and add it to 
another HSSFWorkbook seems like an invaluable feature.
Comment 1 Avik Sengupta 2003-08-30 10:48:38 UTC
Given the nature of bidirectional references, the simplest way to achieve this
would be to copy each cell one at a time. So this would make a nice utility
method, there doesnt seem to any nice internal magic that will make this happen
without  a bit FOR loop !
Comment 2 Dharma 2007-03-29 06:13:50 UTC
Created attachment 19841 [details]
Ignore this

Comment 3 Dharma 2007-03-29 06:15:14 UTC
Created attachment 19842 [details]
Please ignore

werwerwerwerwerwe werwe
Comment 4 Dharma 2007-03-29 06:19:25 UTC
Comment on attachment 19841 [details]
Ignore this

Ignore this
Comment 5 Josh Micich 2008-05-10 20:07:40 UTC
The work-around suggested by Avik seems reasonable.  If such operations were really common, they could be encapsulated in a class for addition to POI.