RE: Cloning Sheet to New Workbook

["Singh, Arshi (Indsys)" <Ar...@geind.ge.com>]

Hi,
    I had posted a similar question about combining worksheets from
different workbooks into one workbook.
    I want to know whether the feature that was being discussed
below.....workbook.setSheet(..) method, has been implemented or wud i have
to copy each row one by one to the new workbook.

Thanks,
Arshi.

-----Original Message-----
From: Andrew C. Oliver [mailto:acoliver@apache.org]
Sent: Friday, August 01, 2003 1:03 AM
To: POI Users List
Subject: Re: Cloning Sheet to New Workbook


There is no technical reason why this feature can't be added (though not
"setSheet", that's very deceptive of what is really going on)... Its just a
lot of work.

On 7/31/03 3:17 PM, "Avik Sengupta" <av...@apache.org> wrote:

> I imagine not.. there isnt a workbook.setSheet(..) method.
> 
> I suppose the difficulty in implementing something like this is that in
> both the object model AND the fileformat, a sheet can contain references
> to global objects in the workbook.
> 
> On Fri, 2003-08-01 at 00:34, Trask, Dennis wrote:
>> My apologies if this has already been covered, but my cursory search of
the
>> archives did not provide results...
>> 
>> I would like to clone sheets from several workbooks and combine them into
a
>> new workbook. In other words, I want Sheet 1 from Workbook 1 to be Sheet
1
>> in the new workbook. Then, I want Sheet 1 from Workbook 2 to be Sheet 2
in
>> the new workbook. [And so on...]
>> 
>> Using POI, can I perform a wholesale clone of a sheet and place it into a
>> new workbook in this manner?
>> 
>> Thanks, in advance,
>> Dennis Trask
>> Nielsen Media Research
>> dennis.trask@nielsenmedia.com
>> 
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
>> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
>> 
>> 
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
> 

-- 
Andrew C. Oliver
http://www.superlinksoftware.com/poi.jsp
Custom enhancements and Commercial Implementation for Jakarta POI

http://jakarta.apache.org/poi
For Java and Excel, Got POI?


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org