poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Avik Sengupta <avik.sengu...@itellix.com>
Subject Re: Making Charts in Excel
Date Thu, 17 Feb 2005 11:31:38 GMT
>1. the size of data is not predifenend and is variable

Create a chart with a named range, and modify the range via POI. Search
the archives for some discussions on this.

>2. the chart has to be a part of an excel file which is generated ....

?? Whats the problem with that? Just have a chart,and some dummy source
data in your template, and add the other sheets via POI. 



On Thu, 2005-02-17 at 17:01 +0530, Kamal Upadhyay wrote:
> Hi,
> I am trying to make charts using excel.
> One alternative that i came across was to read an excel which already
> has a chart associated with a table and modify the data of the table
> and hence that of the chart.
> This however posses two problems:
> 1. the size of data is not predifenend and is variable
> 2. the chart has to be a part of an excel file which is generated on
> the fly and has many other sheets which has plain data, so how do we
> add this chart element
> 
> i have read that 2.5 has some other advanced features for making
> charts, came across the function insertChartRecord() of HSSFWorkBook
> but did not getting any idea how to proceed.
> any help is appreciated.
-- 


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/


Mime
View raw message