You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Paul Hardiman <Pa...@syniverse.com> on 2004/12/27 21:43:30 UTC

Adding existing sheets to a book

Hi, 
I would like to copy existing sheets to a new book. The source sheets are
forms.
I haven't seen a Book.addSheet(Sheet) method.

I have tried creating a new sheet from the new target book. Using row and
cell iterators,
I create rows and cells. and copy the attributes of the source cells to the
tartget cells.
However, I seem to miss all of the formatting like backgrounds and column
spans.

Appreciate any assiot

Regards,
Paul Hardiman
813-273-3042

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

AW: Adding existing sheets to a book

Posted by "KHZ (SAW)" <ka...@sawag.com>.
Hi Paul.

Look at

http://jakarta.apache.org/poi/hssf/how-to.html

Read it exactly and there's a further link which contains that sample
HSSF class. It's an example about reading and writing.

There in the case of generating a new workbook you see how to create a
new sheet within the workbook.

Why do you want to generate it from the scratch? Loading a template,
changing some things and writing it using a different name can make a
lot of things quite easy which might be quite complex doing them by
foot.

Regards,	Karl-Heinz.


-----Ursprüngliche Nachricht-----
Von: Paul Hardiman [mailto:Paul.Hardiman@syniverse.com] 
Gesendet: Montag, 27. Dezember 2004 21:44
An: 'poi-user@jakarta.apache.org'
Betreff: Adding existing sheets to a book

Hi, 
I would like to copy existing sheets to a new book. The source sheets
are
forms.
I haven't seen a Book.addSheet(Sheet) method.

I have tried creating a new sheet from the new target book. Using row
and
cell iterators,
I create rows and cells. and copy the attributes of the source cells to
the
tartget cells.
However, I seem to miss all of the formatting like backgrounds and
column
spans.

Appreciate any assiot

Regards,
Paul Hardiman
813-273-3042

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




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