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/
