I think it would be more safer and API compliant to do something like the attached code.
But, it is far from complete - one main problem is that there is no way to copy over Workbook styles.
Seems like in BIFF all styles are kept at workbook level and not at sheet level.
On 8/25/06, Sebastian Frehmel <
[EMAIL PROTECTED]> wrote:
I'm sorry, but I dont't think I will be able to post code here within
the next 3 weeks because I've got other, way more important stuff to do.
But what came in to my mind is the cloneSheet method.
This method is used to clone a sheet within a workbook But if someone
looked into the source code a little deeper, this someone might probably
find a way to return the sheet to another workbook.
Do you have time and knowledge for this?
Cheenu schrieb:
> Sebastian,
> Seems like there is no way to do this than copying cell by cell.
> JExcelApi does not provide a way as well -
> http://groups.yahoo.com/group/JExcelApi/message/8069
>
> Can we exchange code to get the best possible way to do this?
> I will code something up and post it here.
>
> Cheenu
>
> On 8/24/06, Sebastian Frehmel <[EMAIL PROTECTED]> wrote:
>>
>> This is a feature I miss, too.
>> Just the possibility to say something like:
>> wb.addSheet(HSSFSheet a)
>>
>> Until now I had to copy all cells manually....
>> Does anyone know how?
>>
>> Cheenu schrieb:
>> > I have two HSSFWorkbook objects, each having one HSSFSheet.
>> > I want to create a third HSSFWorkbook containing two sheets (one from
>> > each
>> > of the workbooks).
>> >
>> > I could not find a way to do this from the API - am I missing
>> something.
>> >
>> > A code snippet to explain the same:
>> >
>> > HSSFWorkbook hrWorkBook = getDepartmentDetails("HR");
>> > HSSFWorkbook financeWorkBook = getDepartmentDetails("Finance");
>> >
>> > HSSFWorkbook finalWorkBook = ???; // I want to somehow create this
>> > finalWorkBook with the one sheet from the hr and finance workbook
>> >
>> > Thanks
>> > Cheenu
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: [EMAIL PROTECTED]
>> Mailing List: http://jakarta.apache.org/site/mail2.html#poi
>> The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
