You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by chandra <ch...@polarisft.com> on 2013/01/15 10:50:35 UTC
How to update Legend Series name for charts dynamically
Hi,
My requirement is to create charts in Excel using POI, i am able to
generate charts dynamically.But there is another req came up i.e to update
the legend series value and axis label value dynamically using apache poi
codebase.Can you help any one who knows or any idea to update legend series
and axis label value dynamically.
regards,
Chandra shekar.K
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/How-to-update-Legend-Series-name-for-charts-dynamically-tp5711881.html
Sent from the POI - Dev mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
Re: How to update Legend Series name for charts dynamically
Posted by Guillaume de GENTILE <gd...@finbox-solutions.com>.
Hi Chandra,
Thanks for your answer, I am also using the same approach.
The limitations I found is that it is not possible to rename a sheet
which contains a graph whithout corrupting the graph. It is also not
possible to clone a sheet which contains a graph.
I have recently fixed these 2 issues on my side and created a new case
in bugzilla with the proposal.
Regards,
Guillaume
Le 23/01/2013 15:43, chandra a écrit :
> Hi Guillaume,
> Yes POI directly does not support chart dynamically from scratch.
> But i created using template approach found in below url
> http://www.programming-free.com/2012/12/create-charts-in-excel-using-java.html#.UP_16B0qYbD
> regards,
> Chandra shekar.k
>
> -----"Guillaume de GENTILE [via Apache POI]" <ml...@n5.nabble.com> wrote: -----
> To: chandra <ch...@polarisft.com>
> From: "Guillaume de GENTILE [via Apache POI]" <ml...@n5.nabble.com>
> Date: 01/23/2013 03:44AM
> Subject: Re: How to update Legend Series name for charts dynamically
>
> Hi Chandra,
>
> As far as I know, the current POI does not support the creation of Chart
> from scratch.
> Can you please explain how do you generate charts dynamically?
>
> Thanks,
> Guillaume
>
>
> Le 15/01/2013 10:50, chandra a écrit :
>
>> Hi,
>>
>> My requirement is to create charts in Excel using POI, i am able to
>> generate charts dynamically.But there is another req came up i.e to update
>> the legend series value and axis label value dynamically using apache poi
>> codebase.Can you help any one who knows or any idea to update legend series
>> and axis label value dynamically.
>>
>> regards,
>> Chandra shekar.K
>>
>>
>>
>> --
>> View this message in context: http://apache-poi.1045710.n5.nabble.com/How-to-update-Legend-Series-name-for-charts-dynamically-tp5711881.html
>> Sent from the POI - Dev mailing list archive at Nabble.com.
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: [hidden email]
>> For additional commands, e-mail: [hidden email]
>>
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [hidden email]
> For additional commands, e-mail: [hidden email]
>
>
>
> If you reply to this email, your message will be added to the discussion below:
> http://apache-poi.1045710.n5.nabble.com/How-to-update-Legend-Series-name-for-charts-dynamically-tp5711881p5711946.html
> To unsubscribe from How to update Legend Series name for charts dynamically, click here.
> NAML
>
>
> This e-Mail may contain proprietary and confidential information and is sent for the intended recipient(s) only. If by an addressing or transmission error this mail has been misdirected to you, you are requested to delete this mail immediately. You are also hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail message, contents or its attachment other than by its intended recipient/s is strictly prohibited.
>
> Visit us at http://www.polarisFT.com
>
>
>
>
> --
> View this message in context: http://apache-poi.1045710.n5.nabble.com/How-to-update-Legend-Series-name-for-charts-dynamically-tp5711881p5711960.html
> Sent from the POI - Dev mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
Re: How to update Legend Series name for charts dynamically
Posted by chandra <ch...@polarisft.com>.
Hi Guillaume,
Yes POI directly does not support chart dynamically from scratch.
But i created using template approach found in below url
http://www.programming-free.com/2012/12/create-charts-in-excel-using-java.html#.UP_16B0qYbD
regards,
Chandra shekar.k
-----"Guillaume de GENTILE [via Apache POI]" <ml...@n5.nabble.com> wrote: -----
To: chandra <ch...@polarisft.com>
From: "Guillaume de GENTILE [via Apache POI]" <ml...@n5.nabble.com>
Date: 01/23/2013 03:44AM
Subject: Re: How to update Legend Series name for charts dynamically
Hi Chandra,
As far as I know, the current POI does not support the creation of Chart
from scratch.
Can you please explain how do you generate charts dynamically?
Thanks,
Guillaume
Le 15/01/2013 10:50, chandra a écrit :
> Hi,
>
> My requirement is to create charts in Excel using POI, i am able to
> generate charts dynamically.But there is another req came up i.e to update
> the legend series value and axis label value dynamically using apache poi
> codebase.Can you help any one who knows or any idea to update legend series
> and axis label value dynamically.
>
> regards,
> Chandra shekar.K
>
>
>
> --
> View this message in context: http://apache-poi.1045710.n5.nabble.com/How-to-update-Legend-Series-name-for-charts-dynamically-tp5711881.html
> Sent from the POI - Dev mailing list archive at Nabble.com.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [hidden email]
> For additional commands, e-mail: [hidden email]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]
If you reply to this email, your message will be added to the discussion below:
http://apache-poi.1045710.n5.nabble.com/How-to-update-Legend-Series-name-for-charts-dynamically-tp5711881p5711946.html
To unsubscribe from How to update Legend Series name for charts dynamically, click here.
NAML
This e-Mail may contain proprietary and confidential information and is sent for the intended recipient(s) only. If by an addressing or transmission error this mail has been misdirected to you, you are requested to delete this mail immediately. You are also hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail message, contents or its attachment other than by its intended recipient/s is strictly prohibited.
Visit us at http://www.polarisFT.com
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/How-to-update-Legend-Series-name-for-charts-dynamically-tp5711881p5711960.html
Sent from the POI - Dev mailing list archive at Nabble.com.
Re: How to update Legend Series name for charts dynamically
Posted by Guillaume de GENTILE <gd...@finbox-solutions.com>.
Hi Chandra,
As far as I know, the current POI does not support the creation of Chart
from scratch.
Can you please explain how do you generate charts dynamically?
Thanks,
Guillaume
Le 15/01/2013 10:50, chandra a écrit :
> Hi,
>
> My requirement is to create charts in Excel using POI, i am able to
> generate charts dynamically.But there is another req came up i.e to update
> the legend series value and axis label value dynamically using apache poi
> codebase.Can you help any one who knows or any idea to update legend series
> and axis label value dynamically.
>
> regards,
> Chandra shekar.K
>
>
>
> --
> View this message in context: http://apache-poi.1045710.n5.nabble.com/How-to-update-Legend-Series-name-for-charts-dynamically-tp5711881.html
> Sent from the POI - Dev mailing list archive at Nabble.com.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
> For additional commands, e-mail: dev-help@poi.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org