You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by PeWK <sk...@gmx.de> on 2008/08/27 10:20:39 UTC
HSSFCell Join
Hi,
I am looking for a way to join two or more Cells together.
This should work for horizontal as well as for vertical joins.
I seached the poi.apache.ora documentation for a solution. If there is an
obvious way to join Cells which I missed pease just give me a hint.
Otherwise I would be glad to get some ideas.
Thanks for your answer.
--
View this message in context: http://www.nabble.com/HSSFCell-Join-tp19176664p19176664.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: HSSFCell Join
Posted by PeWK <sk...@gmx.de>.
Anthony Andrews wrote:
>
> What do you mean by 'join two or more cells together'?
>
> Do you mean to concatenate the cells contents together or to merge the
> cells to create a merged region?
>
> --- On Wed, 8/27/08, PeWK <sk...@gmx.de> wrote:
> From: PeWK <sk...@gmx.de>
> Subject: HSSFCell Join
> To: user@poi.apache.org
> Date: Wednesday, August 27, 2008, 1:20 AM
>
> Hi,
>
> I am looking for a way to join two or more Cells together.
> This should work for horizontal as well as for vertical joins.
> I seached the poi.apache.ora documentation for a solution. If there is an
> obvious way to join Cells which I missed pease just give me a hint.
> Otherwise I would be glad to get some ideas.
>
> Thanks for your answer.
>
> --
> View this message in context:
> http://www.nabble.com/HSSFCell-Join-tp19176664p19176664.html
> Sent from the POI - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>
>
>
>
>
--
View this message in context: http://www.nabble.com/HSSFCell-Join-tp19176664p19180559.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: HSSFCell Join
Posted by PeWK <sk...@gmx.de>.
Thanks for the answer. I try it this way.
Anthony Andrews wrote:
>
> I am going to assume that you want to merge cells together. If this is
> indeed the case, then you need to look at the addMergedRegion() method
> defined within the HSSFSheet class. You pass to this method an instance of
> the CellRangeAddress class that allows you to define the rows and columns
> that define the extent of the merged region.
>
> --- On Wed, 8/27/08, Anthony Andrews <py...@yahoo.com> wrote:
> From: Anthony Andrews <py...@yahoo.com>
> Subject: Re: HSSFCell Join
> To: "POI Users List" <us...@poi.apache.org>
> Date: Wednesday, August 27, 2008, 7:08 AM
>
> There is no message body in your email.
>
> --- On Wed, 8/27/08, PeWK <sk...@gmx.de> wrote:
> From: PeWK <sk...@gmx.de>
> Subject: Re: HSSFCell Join
> To: user@poi.apache.org
> Date: Wednesday, August 27, 2008, 6:08 AM
>
>
>
> Anthony Andrews wrote:
>>
>> What do you mean by 'join two or more cells together'?
>>
>> Do you mean to concatenate the cells contents together or to merge the
>> cells to create a merged region?
>>
>> --- On Wed, 8/27/08, PeWK <sk...@gmx.de> wrote:
>> From: PeWK <sk...@gmx.de>
>> Subject: HSSFCell Join
>> To: user@poi.apache.org
>> Date: Wednesday, August 27, 2008, 1:20 AM
>>
>> Hi,
>>
>> I am looking for a way to join two or more Cells together.
>> This should work for horizontal as well as for vertical joins.
>> I seached the poi.apache.ora documentation for a solution. If there is an
>> obvious way to join Cells which I missed pease just give me a hint.
>> Otherwise I would be glad to get some ideas.
>>
>> Thanks for your answer.
>>
>> --
>> View this message in context:
>> http://www.nabble.com/HSSFCell-Join-tp19176664p19176664.html
>> Sent from the POI - User mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
>> For additional commands, e-mail: user-help@poi.apache.org
>>
>>
>>
>>
>>
>>
>
> --
> View this message in context:
> http://www.nabble.com/HSSFCell-Join-tp19176664p19180560.html
> Sent from the POI - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>
>
>
>
>
>
>
>
--
View this message in context: http://www.nabble.com/HSSFCell-Join-tp19176664p19194546.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: HSSFCell Join
Posted by PeWK <sk...@gmx.de>.
That was exactly what I was looking for.
Thanks :-)
Anthony Andrews wrote:
>
> I am going to assume that you want to merge cells together. If this is
> indeed the case, then you need to look at the addMergedRegion() method
> defined within the HSSFSheet class. You pass to this method an instance of
> the CellRangeAddress class that allows you to define the rows and columns
> that define the extent of the merged region.
>
> --- On Wed, 8/27/08, Anthony Andrews <py...@yahoo.com> wrote:
> From: Anthony Andrews <py...@yahoo.com>
> Subject: Re: HSSFCell Join
> To: "POI Users List" <us...@poi.apache.org>
> Date: Wednesday, August 27, 2008, 7:08 AM
>
> There is no message body in your email.
>
> --- On Wed, 8/27/08, PeWK <sk...@gmx.de> wrote:
> From: PeWK <sk...@gmx.de>
> Subject: Re: HSSFCell Join
> To: user@poi.apache.org
> Date: Wednesday, August 27, 2008, 6:08 AM
>
>
>
> Anthony Andrews wrote:
>>
>> What do you mean by 'join two or more cells together'?
>>
>> Do you mean to concatenate the cells contents together or to merge the
>> cells to create a merged region?
>>
>> --- On Wed, 8/27/08, PeWK <sk...@gmx.de> wrote:
>> From: PeWK <sk...@gmx.de>
>> Subject: HSSFCell Join
>> To: user@poi.apache.org
>> Date: Wednesday, August 27, 2008, 1:20 AM
>>
>> Hi,
>>
>> I am looking for a way to join two or more Cells together.
>> This should work for horizontal as well as for vertical joins.
>> I seached the poi.apache.ora documentation for a solution. If there is an
>> obvious way to join Cells which I missed pease just give me a hint.
>> Otherwise I would be glad to get some ideas.
>>
>> Thanks for your answer.
>>
>> --
>> View this message in context:
>> http://www.nabble.com/HSSFCell-Join-tp19176664p19176664.html
>> Sent from the POI - User mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
>> For additional commands, e-mail: user-help@poi.apache.org
>>
>>
>>
>>
>>
>>
>
> --
> View this message in context:
> http://www.nabble.com/HSSFCell-Join-tp19176664p19180560.html
> Sent from the POI - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>
>
>
>
>
>
>
>
--
View this message in context: http://www.nabble.com/HSSFCell-Join-tp19176664p19194592.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: HSSFCell Join
Posted by Anthony Andrews <py...@yahoo.com>.
I am going to assume that you want to merge cells together. If this is indeed the case, then you need to look at the addMergedRegion() method defined within the HSSFSheet class. You pass to this method an instance of the CellRangeAddress class that allows you to define the rows and columns that define the extent of the merged region.
--- On Wed, 8/27/08, Anthony Andrews <py...@yahoo.com> wrote:
From: Anthony Andrews <py...@yahoo.com>
Subject: Re: HSSFCell Join
To: "POI Users List" <us...@poi.apache.org>
Date: Wednesday, August 27, 2008, 7:08 AM
There is no message body in your email.
--- On Wed, 8/27/08, PeWK <sk...@gmx.de> wrote:
From: PeWK <sk...@gmx.de>
Subject: Re: HSSFCell Join
To: user@poi.apache.org
Date: Wednesday, August 27, 2008, 6:08 AM
Anthony Andrews wrote:
>
> What do you mean by 'join two or more cells together'?
>
> Do you mean to concatenate the cells contents together or to merge the
> cells to create a merged region?
>
> --- On Wed, 8/27/08, PeWK <sk...@gmx.de> wrote:
> From: PeWK <sk...@gmx.de>
> Subject: HSSFCell Join
> To: user@poi.apache.org
> Date: Wednesday, August 27, 2008, 1:20 AM
>
> Hi,
>
> I am looking for a way to join two or more Cells together.
> This should work for horizontal as well as for vertical joins.
> I seached the poi.apache.ora documentation for a solution. If there is an
> obvious way to join Cells which I missed pease just give me a hint.
> Otherwise I would be glad to get some ideas.
>
> Thanks for your answer.
>
> --
> View this message in context:
> http://www.nabble.com/HSSFCell-Join-tp19176664p19176664.html
> Sent from the POI - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>
>
>
>
>
--
View this message in context:
http://www.nabble.com/HSSFCell-Join-tp19176664p19180560.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: HSSFCell Join
Posted by Anthony Andrews <py...@yahoo.com>.
There is no message body in your email.
--- On Wed, 8/27/08, PeWK <sk...@gmx.de> wrote:
From: PeWK <sk...@gmx.de>
Subject: Re: HSSFCell Join
To: user@poi.apache.org
Date: Wednesday, August 27, 2008, 6:08 AM
Anthony Andrews wrote:
>
> What do you mean by 'join two or more cells together'?
>
> Do you mean to concatenate the cells contents together or to merge the
> cells to create a merged region?
>
> --- On Wed, 8/27/08, PeWK <sk...@gmx.de> wrote:
> From: PeWK <sk...@gmx.de>
> Subject: HSSFCell Join
> To: user@poi.apache.org
> Date: Wednesday, August 27, 2008, 1:20 AM
>
> Hi,
>
> I am looking for a way to join two or more Cells together.
> This should work for horizontal as well as for vertical joins.
> I seached the poi.apache.ora documentation for a solution. If there is an
> obvious way to join Cells which I missed pease just give me a hint.
> Otherwise I would be glad to get some ideas.
>
> Thanks for your answer.
>
> --
> View this message in context:
> http://www.nabble.com/HSSFCell-Join-tp19176664p19176664.html
> Sent from the POI - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>
>
>
>
>
--
View this message in context:
http://www.nabble.com/HSSFCell-Join-tp19176664p19180560.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: HSSFCell Join
Posted by PeWK <sk...@gmx.de>.
Anthony Andrews wrote:
>
> What do you mean by 'join two or more cells together'?
>
> Do you mean to concatenate the cells contents together or to merge the
> cells to create a merged region?
>
> --- On Wed, 8/27/08, PeWK <sk...@gmx.de> wrote:
> From: PeWK <sk...@gmx.de>
> Subject: HSSFCell Join
> To: user@poi.apache.org
> Date: Wednesday, August 27, 2008, 1:20 AM
>
> Hi,
>
> I am looking for a way to join two or more Cells together.
> This should work for horizontal as well as for vertical joins.
> I seached the poi.apache.ora documentation for a solution. If there is an
> obvious way to join Cells which I missed pease just give me a hint.
> Otherwise I would be glad to get some ideas.
>
> Thanks for your answer.
>
> --
> View this message in context:
> http://www.nabble.com/HSSFCell-Join-tp19176664p19176664.html
> Sent from the POI - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>
>
>
>
>
--
View this message in context: http://www.nabble.com/HSSFCell-Join-tp19176664p19180560.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: HSSFCell Join
Posted by Anthony Andrews <py...@yahoo.com>.
What do you mean by 'join two or more cells together'?
Do you mean to concatenate the cells contents together or to merge the cells to create a merged region?
--- On Wed, 8/27/08, PeWK <sk...@gmx.de> wrote:
From: PeWK <sk...@gmx.de>
Subject: HSSFCell Join
To: user@poi.apache.org
Date: Wednesday, August 27, 2008, 1:20 AM
Hi,
I am looking for a way to join two or more Cells together.
This should work for horizontal as well as for vertical joins.
I seached the poi.apache.ora documentation for a solution. If there is an
obvious way to join Cells which I missed pease just give me a hint.
Otherwise I would be glad to get some ideas.
Thanks for your answer.
--
View this message in context:
http://www.nabble.com/HSSFCell-Join-tp19176664p19176664.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org