---

ExcelChart.java

Go to the documentation of this file.

package net.threebit.utils.sosc;

/*
        Copyright 2003 Shawn Deleurme
        Copyright 2003 Kevin O'Donnell

        This program is free software; you can redistribute it and/or modify
        it under the terms of the GNU General Public License as published by
        the Free Software Foundation; either version 2 of the License, or
        (at your option) any later version.

        This program is distributed in the hope that it will be useful,
        but WITHOUT ANY WARRANTY; without even the implied warranty of
        MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
        GNU General Public License for more details.

        You should have received a copy of the GNU General Public License
        along with this program; if not, write to the Free Software
        Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
*/

import javax.xml.transform.*;
import javax.xml.transform.stream.*;
import java.sql.*;
import java.io.*;
import java.util.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;

public class ExcelChart {

        public static final int Combo = -1  ;  
        public static final int ColumnClustered = 0  ;  
        public static final int ColumnStacked = 1  ;  
        public static final int ColumnStacked100 = 2  ;  
        public static final int BarClustered = 3  ;  
        public static final int BarStacked = 4  ;  
        public static final int BarStacked100 = 5  ;  
        public static final int Line = 6  ;  
        public static final int LineMarkers = 7  ;  
        public static final int LineStacked = 8  ;  
        public static final int LineStackedMarkers = 9  ;  
        public static final int LineStacked100 = 10  ;  
        public static final int LineStacked100Markers = 11  ;  
        public static final int SmoothLine = 12  ;  
        public static final int SmoothLineMarkers = 13  ;  
        public static final int SmoothLineStacked = 14  ;  
        public static final int SmoothLineStackedMarkers = 15  ;  
        public static final int SmoothLineStacked100 = 16  ;  
        public static final int SmoothLineStacked100Markers = 17  ;  
        public static final int Pie = 18  ;  
        public static final int PieExploded = 19  ;  
        public static final int PieStacked = 20  ;  
        public static final int ScatterMarkers = 21  ;  
        public static final int ScatterSmoothLineMarkers = 22  ;  
        public static final int ScatterSmoothLine = 23  ;  
        public static final int ScatterLineMarkers = 24  ;  
        public static final int ScatterLine = 25  ;  
        public static final int ScatterLineFilled = 26  ;  
        public static final int Bubble = 27  ;  
        public static final int BubbleLine = 28  ;  
        public static final int Area = 29  ;  
        public static final int AreaStacked = 30  ;  
        public static final int AreaStacked100 = 31  ;  
        public static final int Doughnut = 32  ;  
        public static final int DoughnutExploded = 33  ;  
        public static final int RadarLine = 34  ;  
        public static final int RadarLineMarkers = 35  ;  
        public static final int RadarLineFilled = 36  ;  
        public static final int RadarSmoothLine = 37  ;  
        public static final int RadarSmoothLineMarkers = 38  ;  
        public static final int StockHLC = 39  ;  
        public static final int StockOHLC = 40  ;  
        public static final int PolarMarkers = 41  ;  
        public static final int PolarLine = 42  ;  
        public static final int PolarLineMarkers = 43  ;  
        public static final int PolarSmoothLine = 44  ;  
        public static final int PolarSmoothLineMarkers = 45  ;  

        private StringWriter sw = new StringWriter();
        private PrintWriter out = new PrintWriter(sw);
        private String name = null;
        private List items = new ArrayList();
        private int instance = 0;
        public String width = "99%";
        public String height = "500px";
  
        public ExcelChart (String name) throws java.io.IOException {
                this(name,0);
        }

        public ExcelChart (String name, int instance) throws java.io.IOException {
                this.name = name; 
                this.instance = instance;
        }
        public void render (OutputStream out) throws Exception {
                PrintWriter ow = new PrintWriter(new OutputStreamWriter(out));
                ow.print("<object ");
                ow.print(" id=\""+name+"\" "); 
                ow.print(" classid=\"CLSID:0002E500-0000-0000-C000-000000000046\"");   
                ow.print(" style=\"width: "+width+"; height: "+height+";\">");
                ow.println("</object>");
                ow.println("");
                ow.println(sw.getBuffer().toString());
                ow.println("");
                ow.println("<script language=\"vbs\">");
                for (Iterator i = items.iterator(); i.hasNext(); ) {
                        ow.println("  " + i.next() + "()");
                }
                ow.println("</script>");
                ow.println("");
                ow.flush();
        }

        public void draw(String chartName, String dataSource, ArrayList series, int chartType) throws java.io.IOException { 
                items.add(chartName) ; 

                out.println("<script language=\"VBScript\">"); 
                out.println("Sub "+chartName+"()");  
                if (instance == 0 ) { out.println(name + ".Clear "); }
                out.println(name + ".Charts.Add ");
                out.println("Set c = " + name + ".Constants ");
                if (instance == 0 ) { out.println(name + ".DataSource = " + dataSource); }
                out.println(name+".Charts("+instance+").Type = " + chartType ); 

                int k = 0 ; 
                for (Iterator i = series.iterator(); i.hasNext();) {
                        out.println( name +  ".Charts("+instance+").SeriesCollection.Add" ); 
                        List o = (ArrayList) i.next() ; 
                        out.println(name + ".Charts("+instance+").SeriesCollection("+k+").SetData c.chDimSeriesNames, 0, \"" + o.get(0)+"\"" ); 
                        out.println(name + ".Charts("+instance+").SeriesCollection("+k+").SetData c.chDimCategories, 0, \""+ o.get(1)+ "\"" ); 
                        out.println(name + ".Charts("+instance+").SeriesCollection("+k+").SetData c.chDimValues, 0, \"" + o.get(2)+"\"" );
                        k++; 
                }
                out.println(name + ".Charts("+instance+").HasLegend = True "); 
                out.println("End Sub \n </script>"); 
        }

}

---