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

  

posted @ 2011-09-02 09:17  tqsummer  阅读(2477)  评论(0编辑  收藏  举报