csvcharttest.java

The jxcell allows any Java developer to automate any manual spreadsheet process within their organiz

import com.jxcell.*;

import java.io.IOException;

public class CsvChartTest {


    CsvChartTest()
    {
    }

    public static void main(String args[])
    {
        View m_view;
        try
        {
            m_view =new View();
            m_view.read(".\\book.csv");
            GRObject chart = m_view.addObject(com.jxcell.GRObject.eChart, (short)1, (short)9,(short)9, (short)22);
            ((GRChart)chart).initData(new RangeRef(1,0,7,4),true);     //Sheet1!$A$2:$E$8
            m_view.write(".\\columnChart.xls",View.eFileExcel);
            ((GRChart)chart).setChartType(GRChart.eChartBar);
            m_view.write(".\\barChart.xls",View.eFileExcel);
            ((GRChart)chart).setChartType(GRChart.eChartPie);
            m_view.write(".\\pieChart.xls",View.eFileExcel);
            ((GRChart)chart).setChartType(GRChart.eChartLine);
            m_view.write(".\\lineChart.xls",View.eFileExcel);
//            Designer.newDesigner(m_view);
        }
        catch (CellException e)
        {
            e.printStackTrace();
        } catch (IOException e)
        {
            e.printStackTrace();
        }
    }
}