import com.jxcell.*;
import com.jxcell.designer.Designer;

import java.io.IOException;

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