You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Subodh Damle <su...@mahindrabt.com> on 2004/07/26 09:33:01 UTC

Copying contents from one sheet to other ?

Hi all,
How can we copy rows/cells read from one HSSFSheet to another sheet ?

In 2.5 final docs , there is no method in HSSFSheet class like
addRow(HSSFRow row). 
So do I have to create a new row using createRow and manually put all
the contents ?

Thanks,
Subodh


*********************************************************
Disclaimer:          

This message (including any attachments) contains 
confidential information intended for a specific 
individual and purpose, and is protected by law. 
If you are not the intended recipient, you should 
delete this message and are hereby notified that 
any disclosure, copying, or distribution of this
message, or the taking of any action based on it, 
is strictly prohibited.

*********************************************************
Visit us at http://www.mahindrabt.com




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


Re: Copying contents from one sheet to other ?

Posted by Clint Brubakken <ca...@cssgroup.com>.
The only way I found to do it was to copy each individual cell, and cell 
style. I did write a code that copied from one sheet to the other.

If anyone is interested in it I can look into submiting it to the  poi. 
project.


Subodh Damle wrote:

>Hi all,
>How can we copy rows/cells read from one HSSFSheet to another sheet ?
>
>In 2.5 final docs , there is no method in HSSFSheet class like
>addRow(HSSFRow row). 
>So do I have to create a new row using createRow and manually put all
>the contents ?
>
>Thanks,
>Subodh
>
>
>*********************************************************
>Disclaimer:          
>
>This message (including any attachments) contains 
>confidential information intended for a specific 
>individual and purpose, and is protected by law. 
>If you are not the intended recipient, you should 
>delete this message and are hereby notified that 
>any disclosure, copying, or distribution of this
>message, or the taking of any action based on it, 
>is strictly prohibited.
>
>*********************************************************
>Visit us at http://www.mahindrabt.com
>
>
>
>
>---------------------------------------------------------------------
>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