Search in sources :

Example 6 with CTLineChart

use of org.openxmlformats.schemas.drawingml.x2006.chart.CTLineChart in project oc-explorer by devgateway.

the class XSSFLineChartData method createNewSerie.

@Override
protected CustomChartSeries createNewSerie(final int id, final int order, final ChartDataSource<?> categories, final ChartDataSource<? extends Number> values) {
    return new AbstractSeries(id, order, categories, values) {

        @Override
        public void addToChart(final XmlObject ctChart) {
            final CTLineChart ctLineChart = (CTLineChart) ctChart;
            final CTLineSer ctLineSer = ctLineChart.addNewSer();
            ctLineSer.addNewIdx().setVal(this.id);
            ctLineSer.addNewOrder().setVal(this.order);
            // No marker symbol on the chart line.
            ctLineSer.addNewMarker().addNewSymbol().setVal(STMarkerStyle.CIRCLE);
            final CTAxDataSource catDS = ctLineSer.addNewCat();
            XSSFChartUtil.buildAxDataSource(catDS, this.categories);
            final CTNumDataSource valueDS = ctLineSer.addNewVal();
            XSSFChartUtil.buildNumDataSource(valueDS, this.values);
            if (isTitleSet()) {
                ctLineSer.setTx(getCTSerTx());
            }
        }
    };
}
Also used : CTLineChart(org.openxmlformats.schemas.drawingml.x2006.chart.CTLineChart) CTNumDataSource(org.openxmlformats.schemas.drawingml.x2006.chart.CTNumDataSource) CTLineSer(org.openxmlformats.schemas.drawingml.x2006.chart.CTLineSer) XmlObject(org.apache.xmlbeans.XmlObject) CTAxDataSource(org.openxmlformats.schemas.drawingml.x2006.chart.CTAxDataSource)

Example 7 with CTLineChart

use of org.openxmlformats.schemas.drawingml.x2006.chart.CTLineChart in project oc-explorer by devgateway.

the class XSSFLineChartData method fillChart.

@Override
public void fillChart(final Chart chart, final ChartAxis... axis) {
    if (!(chart instanceof XSSFChart)) {
        throw new IllegalArgumentException("Chart must be instance of XSSFChart");
    }
    final XSSFChart xssfChart = (XSSFChart) chart;
    final CTPlotArea plotArea = xssfChart.getCTChart().getPlotArea();
    final CTLineChart lineChart = plotArea.addNewLineChart();
    lineChart.addNewVaryColors().setVal(false);
    for (CustomChartSeries s : series) {
        s.addToChart(lineChart);
    }
    for (ChartAxis ax : axis) {
        lineChart.addNewAxId().setVal(ax.getId());
    }
    xssfChart.setTitleText(this.title);
    // add grid lines
    CTCatAx[] ctCatAx = plotArea.getCatAxArray();
    if (ctCatAx.length != 0) {
        ctCatAx[0].addNewMajorGridlines().addNewSpPr().addNewSolidFill();
    }
    CTValAx[] ctValAx = plotArea.getValAxArray();
    if (ctValAx.length != 0) {
        ctValAx[0].addNewMajorGridlines().addNewSpPr().addNewSolidFill();
    }
}
Also used : XSSFChart(org.apache.poi.xssf.usermodel.XSSFChart) CTLineChart(org.openxmlformats.schemas.drawingml.x2006.chart.CTLineChart) CustomChartSeries(org.devgateway.toolkit.web.excelcharts.CustomChartSeries) ChartAxis(org.apache.poi.ss.usermodel.charts.ChartAxis) CTValAx(org.openxmlformats.schemas.drawingml.x2006.chart.CTValAx) CTPlotArea(org.openxmlformats.schemas.drawingml.x2006.chart.CTPlotArea) CTCatAx(org.openxmlformats.schemas.drawingml.x2006.chart.CTCatAx)

Aggregations

CTLineChart (org.openxmlformats.schemas.drawingml.x2006.chart.CTLineChart)7 XSSFChart (org.apache.poi.xssf.usermodel.XSSFChart)5 CTAxDataSource (org.openxmlformats.schemas.drawingml.x2006.chart.CTAxDataSource)4 CTLineSer (org.openxmlformats.schemas.drawingml.x2006.chart.CTLineSer)4 CTNumDataSource (org.openxmlformats.schemas.drawingml.x2006.chart.CTNumDataSource)4 ChartAxis (org.apache.poi.ss.usermodel.charts.ChartAxis)3 CTPlotArea (org.openxmlformats.schemas.drawingml.x2006.chart.CTPlotArea)3 Sheet (org.apache.poi.ss.usermodel.Sheet)2 Workbook (org.apache.poi.ss.usermodel.Workbook)2 XSSFDrawing (org.apache.poi.xssf.usermodel.XSSFDrawing)2 XSSFCategoryAxis (org.apache.poi.xssf.usermodel.charts.XSSFCategoryAxis)2 XSSFValueAxis (org.apache.poi.xssf.usermodel.charts.XSSFValueAxis)2 XmlObject (org.apache.xmlbeans.XmlObject)2 CustomChartSeries (org.devgateway.toolkit.web.excelcharts.CustomChartSeries)2 Test (org.junit.Test)2 CTCatAx (org.openxmlformats.schemas.drawingml.x2006.chart.CTCatAx)2 CTChart (org.openxmlformats.schemas.drawingml.x2006.chart.CTChart)2 CTValAx (org.openxmlformats.schemas.drawingml.x2006.chart.CTValAx)2 LineChartSeries (org.apache.poi.ss.usermodel.charts.LineChartSeries)1