public static void main(String args[]) {
View m_view = new View();
RangeRef newRange = null;
try {
m_view.getLock();
m_view.setTextAsValue(1, 2, "Jan");
m_view.setTextAsValue(1, 3, "Feb");
m_view.setTextAsValue(1, 4, "Mar");
m_view.setTextAsValue(1, 5, "Apr");
m_view.setTextAsValue(2, 1, "Bananas");
m_view.setTextAsValue(3, 1, "Papaya");
m_view.setTextAsValue(4, 1, "Mango");
m_view.setTextAsValue(5, 1, "Lilikoi");
m_view.setTextAsValue(6, 1, "Comfrey");
m_view.setTextAsValue(7, 1, "Total");
m_view.setTextAsValue(1, 6, "time");
m_view.setNumber(2, 6, 1);
m_view.setNumber(3, 6, 2);
m_view.setNumber(4, 6, 3);
m_view.setNumber(5, 6, 4);
m_view.setNumber(6, 6, 5);
m_view.setNumber(7, 6, 6);
for (int col = 2; col <= 5; col++)
for (int row = 2; row <= 7; row++)
m_view.setFormula(row, col, "rand()");
m_view.setFormula(7, 2, "SUM(C3:C7)");
m_view.setSelection("C8:F8");
m_view.editCopyRight();
ChartShape chart = m_view.addChart(0, 9.1, 7, 20.4);
chart.setChartType(ChartShape.TypeLine);
// chart.setLinkRange("Sheet1!$C$2", false);
chart.addSeries();
chart.setSeriesName(0, "Sheet1!$C$2");
chart.setSeriesYValueFormula(0, "Sheet1!$C$3:$C$7");
chart.setCategoryFormula("Sheet1!$B$3:$B$7");
chart.addSeries();
chart.setSeriesName(1, "Sheet1!$D$2");
chart.setSeriesYValueFormula(1, "Sheet1!$D$3:$D$7");
chart.addSeries();
chart.setSeriesName(2, "Sheet1!$E$2");
chart.setSeriesYValueFormula(2, "Sheet1!$E$3:$E$7");
chart.addSeries();
chart.setSeriesName(3, "Sheet1!$F$2");
chart.setSeriesYValueFormula(3, "Sheet1!$F$3:$F$7");
// chart.getChart().validateData();
chart.setAxisTitle(ChartShape.XAxis, 0, "Category");
chart.setAxisTitle(ChartShape.YAxis, 0, "Amount");
// set fill color
ChartFormat cf = chart.getChartFormat();
cf.setPattern((short) 1);
cf.setPatternFG(Color.LIGHT_GRAY.getRGB());
chart.setChartFormat(cf);
cf = chart.getPlotFormat();
cf.setPattern((short) 1);
cf.setPatternFG(new Color(204, 255, 255).getRGB());
chart.setPlotFormat(cf);
cf = chart.getAxisFormat(ChartShape.XAxis, 0);
cf.setFontSizeInPoints(8.5);
chart.setAxisFormat(ChartShape.XAxis, 0, cf);
cf = chart.getAxisFormat(ChartShape.YAxis, 0);
cf.setFontSizeInPoints(8.5);
chart.setAxisFormat(ChartShape.YAxis, 0, cf);
cf = chart.getSeriesFormat(0);
cf.setLineStyle((short) 1);
cf.setLineWeight(3 * 20);
cf.setLineColor((new Color(0, 0, 128)).getRGB());
cf.setMarkerAuto(false);
cf.setMarkerStyle((short) 0);
chart.setSeriesFormat(0, cf);
cf = chart.getSeriesFormat(1);
cf.setLineStyle((short) 1);
cf.setLineWeight(3 * 20);
cf.setLineColor((new Color(255, 0, 255)).getRGB());
cf.setMarkerAuto(false);
cf.setMarkerStyle((short) 0);
chart.setSeriesFormat(1, cf);
cf = chart.getSeriesFormat(2);
cf.setLineStyle((short) 1);
cf.setLineWeight(3 * 20);
cf.setLineColor((new Color(255, 255, 0)).getRGB());
cf.setMarkerAuto(false);
cf.setMarkerStyle((short) 0);
chart.setSeriesFormat(2, cf);
cf = chart.getSeriesFormat(3);
cf.setLineStyle((short) 1);
cf.setLineWeight(3 * 20);
cf.setLineColor((new Color(0, 255, 255)).getRGB());
cf.setMarkerAuto(false);
cf.setMarkerStyle((short) 0);
chart.setSeriesFormat(3, cf);
cf = chart.getMajorGridFormat(ChartShape.YAxis, 0);
cf.setLineStyle((short) 2);
cf.setLineColor((new Color(255, 0, 0)).getRGB());
cf.setLineAuto();
chart.setMajorGridFormat(ChartShape.YAxis, 0, cf);
chart.setLegendPosition(ChartFormat.LegendPlacementTop);
cf = chart.getLegendFormat();
cf.setFontBold(true);
cf.setFontSizeInPoints(8);
chart.setLegendFormat(cf);
m_view.write("d:\\out.xls");
} catch (Exception e) {
System.out.println(e.getMessage());
} finally {
m_view.releaseLock();
}
}
