Sarvesh,
Copying the formats is also possible... in your case, it would
need a lot of work since you will have to first get..() the format / style
from the source, and then set..() it in the target..
look at following URLs:
http://jakarta.apache.org/poi/apidocs/org/apache/poi/hssf/usermodel/HSSFCellStyle.html
and
http://jakarta.apache.org/poi/apidocs/org/apache/poi/hssf/usermodel/HSSFDataFormat.html
getCellStyle(), setSCellStyle() methods can be used for Styles..
org.apache.poi.hssf.usermodel.HSSFCellStyle.getDataFormat() returns you
the DataFormat index.. which you can use to set to the target cell's
format.
hope this helps...
Regards,
Sumit Machwe
[EMAIL PROTECTED]
04/05/2006 09:45 AM
Please respond to
"POI Users List" <[email protected]>
To
<[email protected]>
cc
Subject
RE: FW: I am stuck
But is there a way to copy across cell format and formula which are
getting lost.
Regards
Sarvesh
-----Original Message-----
From: Kappe Sr [mailto:[EMAIL PROTECTED]
Sent: 05 April 2006 15:27
To: POI Users List
Subject: Re: FW: I am stuck
Cell by Cell is the only option.
On 4/5/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
>
> Hi,
>
>
> I have many excel file and i need to copy some worksheet from different
> excel files into one .
>
> I have gone through mailing list and bug database and saw this as open
> bug.
>
> But this being a must have functionality for application can anyone give
> some suggestion.
>
> I tried copying cell by cell to new workbook.Its slow and format and
> formulas are lost.
>
> Anyone reply to this SoS
>
> Cheers
> Sarvesh
>
> Visit our website at http://www.ubs.com
>
> This message contains confidential information and is intended only
> for the individual named. If you are not the named addressee you
> should not disseminate, distribute or copy this e-mail. Please
> notify the sender immediately by e-mail if you have received this
> e-mail by mistake and delete this e-mail from your system.
>
> E-mail transmission cannot be guaranteed to be secure or error-free
> as information could be intercepted, corrupted, lost, destroyed,
> arrive late or incomplete, or contain viruses. The sender therefore
> does not accept liability for any errors or omissions in the contents
> of this message which arise as a result of e-mail transmission. If
> verification is required please request a hard-copy version. This
> message is provided for informational purposes and should not be
> construed as a solicitation or offer to buy or sell any securities or
> related financial instruments.
>
>
> ---------------------------------------------------------------------
> 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/
>
>
Visit our website at http://www.ubs.com
This message contains confidential information and is intended only
for the individual named. If you are not the named addressee you
should not disseminate, distribute or copy this e-mail. Please
notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system.
E-mail transmission cannot be guaranteed to be secure or error-free
as information could be intercepted, corrupted, lost, destroyed,
arrive late or incomplete, or contain viruses. The sender therefore
does not accept liability for any errors or omissions in the contents
of this message which arise as a result of e-mail transmission. If
verification is required please request a hard-copy version. This
message is provided for informational purposes and should not be
construed as a solicitation or offer to buy or sell any securities or
related financial instruments.
---------------------------------------------------------------------
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/
+=========================================================+
This message may contain confidential and/or privileged
information. If you are not the addressee or authorized to
receive this for the addressee, you must not use, copy,
disclose or take any action based on this message or any
information herein. If you have received this message in
error, please advise the sender immediately by reply e-mail
and delete this message. Thank you for your cooperation.
+=========================================================+
