您当前位置:设计在线网 >> JavaScript >> 浏览文章

基于JAVA操作Excel图表代码介绍

分享到:
本文章讲述了基于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();
        }

推荐阅读:
JAVA书籍推荐
基于JavaScript中的对象与函数和继承分析
《Java应该这么学》书本内容概要

相关文章:

推荐文章  
赞助商链接  
热门排行  
主题推广  
中国设计在线网 All Rights Reserved. 互联网违法和不良信息举报
信息产业部备案号:湘ICP备09001063号