You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Viswanath Sundaram <Vi...@macquarie.com> on 2011/05/16 04:29:30 UTC
Excel sheets merging?
Hi,
Is there a way I can merge two excel sheets from 2 different workbooks
into 1 new workbook or just add a sheet from workbook1 to workbook2?
Thanks & Regards,
Viswanath
NOTICE
This e-mail and any attachments are confidential and may contain copyright material of Macquarie Group Limited or third parties. If you are not the intended recipient of this email you should not read, print, re-transmit, store or act in reliance on this e-mail or any attachments, and should destroy all copies of them. Macquarie Group Limited does not guarantee the integrity of any emails or any attached files. The views or opinions expressed are the author's own and may not reflect the views or opinions of Macquarie Group Limited.
RE: Excel sheets merging?
Posted by Mahesh Ganapathy <mg...@gmail.com>.
Yep...unless something has radically changed since 3.5
On May 15, 2011 10:08 PM, "Viswanath Sundaram" <
Viswanath.Sundaram@macquarie.com> wrote:
> Hi Mahesh,
>
> Thanks for the reply. So are you saying we have to go and iterate by
> each row and cell and then copy it or is there a much smarter way? If it
> is by rows and cells, does that iteration actually copy my cell style as
> well?
>
> Thanks,
> Viswa
>
> -----Original Message-----
> From: Mahesh Ganapathy [mailto:mganapa@gmail.com]
> Sent: Monday, 16 May 2011 1:01 PM
> To: POI Users List
> Subject: Re: Excel sheets merging?
>
> I don't believe there is a simple set of apostle to do that the fastest
> and
> mist efficient way would probably be to use the as model.
> On May 15, 2011 9:30 PM, "Viswanath Sundaram" <
> Viswanath.Sundaram@macquarie.com> wrote:
>> Hi,
>>
>>
>>
>> Is there a way I can merge two excel sheets from 2 different workbooks
>> into 1 new workbook or just add a sheet from workbook1 to workbook2?
>>
>>
>>
>> Thanks & Regards,
>>
>> Viswanath
>>
>>
>>
>>
>> NOTICE
>> This e-mail and any attachments are confidential and may contain
> copyright
> material of Macquarie Group Limited or third parties. If you are not the
> intended recipient of this email you should not read, print,
> re-transmit,
> store or act in reliance on this e-mail or any attachments, and should
> destroy all copies of them. Macquarie Group Limited does not guarantee
> the
> integrity of any emails or any attached files. The views or opinions
> expressed are the author's own and may not reflect the views or opinions
> of
> Macquarie Group Limited.
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
RE: Excel sheets merging?
Posted by Viswanath Sundaram <Vi...@macquarie.com>.
Hi Mahesh,
Thanks for the reply. So are you saying we have to go and iterate by
each row and cell and then copy it or is there a much smarter way? If it
is by rows and cells, does that iteration actually copy my cell style as
well?
Thanks,
Viswa
-----Original Message-----
From: Mahesh Ganapathy [mailto:mganapa@gmail.com]
Sent: Monday, 16 May 2011 1:01 PM
To: POI Users List
Subject: Re: Excel sheets merging?
I don't believe there is a simple set of apostle to do that the fastest
and
mist efficient way would probably be to use the as model.
On May 15, 2011 9:30 PM, "Viswanath Sundaram" <
Viswanath.Sundaram@macquarie.com> wrote:
> Hi,
>
>
>
> Is there a way I can merge two excel sheets from 2 different workbooks
> into 1 new workbook or just add a sheet from workbook1 to workbook2?
>
>
>
> Thanks & Regards,
>
> Viswanath
>
>
>
>
> NOTICE
> This e-mail and any attachments are confidential and may contain
copyright
material of Macquarie Group Limited or third parties. If you are not the
intended recipient of this email you should not read, print,
re-transmit,
store or act in reliance on this e-mail or any attachments, and should
destroy all copies of them. Macquarie Group Limited does not guarantee
the
integrity of any emails or any attached files. The views or opinions
expressed are the author's own and may not reflect the views or opinions
of
Macquarie Group Limited.
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Excel sheets merging?
Posted by Mahesh Ganapathy <mg...@gmail.com>.
I don't believe there is a simple set of apostle to do that the fastest and
mist efficient way would probably be to use the as model.
On May 15, 2011 9:30 PM, "Viswanath Sundaram" <
Viswanath.Sundaram@macquarie.com> wrote:
> Hi,
>
>
>
> Is there a way I can merge two excel sheets from 2 different workbooks
> into 1 new workbook or just add a sheet from workbook1 to workbook2?
>
>
>
> Thanks & Regards,
>
> Viswanath
>
>
>
>
> NOTICE
> This e-mail and any attachments are confidential and may contain copyright
material of Macquarie Group Limited or third parties. If you are not the
intended recipient of this email you should not read, print, re-transmit,
store or act in reliance on this e-mail or any attachments, and should
destroy all copies of them. Macquarie Group Limited does not guarantee the
integrity of any emails or any attached files. The views or opinions
expressed are the author's own and may not reflect the views or opinions of
Macquarie Group Limited.
>