Examples of com.extentech.ExtenXLS.ChartHandle

com.extentech.ExtenXLS.ChartHandle

Chart Handle allows for manipulation of Charts within a WorkBook.
Allows for run-time modification of Chart titles, labels, categories, and data Cells.
Modification of Chart data cells allows you to completely modify the data shown on the Chart.

To create a new chart and add to a worksheet, use: ChartHandle.createNewChart(sheet, charttype, chartoptions).

To Obtain an array of existing chart handles, use
WorkBookHandle.getCharts()
or WorkBookHandle.getCharts(chart title) @see WorkBookHandle

          if (charts.size()>0) {
             // for each chart, create a chart.xml + trap references for drawingX.xml.rels 
             for (int i= 0; i < charts.size(); i++) {             
                 try {   // obtain image OOXML + write image file to ZIP
                   Chart c= (Chart) charts.get(i);
                 drawing.append(getChartDrawingOOXML(new ChartHandle(c, bk)));  
                 drawing.append("\r\n");            
                 if (c instanceof OOXMLChart) {
                   ArrayList chartEmbeds= ((OOXMLChart)charts.get(i)).getChartEmbeds();
                   if (chartEmbeds!=null) {
                       int origDrawingId= drawingId;       // id for THIS CURRENT DRAWING ML describing this chart(s), etc.

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.

Examples of com.extentech.ExtenXLS.ChartHandle

Related Classes of com.extentech.ExtenXLS.ChartHandle