You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Gernot Veith <ve...@pixel.de> on 2008/04/15 07:32:59 UTC
Q: Extending chart data section in a sheet ?
Hello all,
to create a chart from table data, you have to define a selection the
chart will be made of.
Is it possible to modify (increase or decrease) this selection via POI ?
Currently I don't see any possibility to do that.
You also can assign a XML schema to the sheet to import data from XML.
This assignment creates a selection as well.
Is it possible to modify this selection ?
TIA
Gernot
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Q: Extending chart data section in a sheet ?
Posted by Nick Burch <ni...@torchbox.com>.
On Tue, 15 Apr 2008, Gernot Veith wrote:
> thanks for your reply. As I'm new to POI, are there any HOWTOs or
> axamples, how I can manage this ?
Your best bet is probably:
http://poi.apache.org/hssf/quick-guide.html#NamedRanges
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Q: Extending chart data section in a sheet ?
Posted by Gernot Veith <ve...@pixel.de>.
hello Nick,
thanks for your reply. As I'm new to POI, are there any HOWTOs or
axamples, how I can manage this ?
TIA
Gernot
Nick Burch wrote:
> On Tue, 15 Apr 2008, Gernot Veith wrote:
>> to create a chart from table data, you have to define a selection the
>> chart will be made of.
>> Is it possible to modify (increase or decrease) this selection via POI ?
>
> The trick is to define your chart to use a named range for its data.
> You can then use poi to edit the named range, to point to the new data
> area, and your chart will then use the new data when you open in excel
>
> Nick
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>
>
.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Q: Extending chart data section in a sheet ?
Posted by Nick Burch <ni...@torchbox.com>.
On Tue, 15 Apr 2008, Gernot Veith wrote:
> to create a chart from table data, you have to define a selection the chart
> will be made of.
> Is it possible to modify (increase or decrease) this selection via POI ?
The trick is to define your chart to use a named range for its data. You
can then use poi to edit the named range, to point to the new data area,
and your chart will then use the new data when you open in excel
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org