基於JAVA操作Excel圖表

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 colorChartFormat 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();}}