Search in sources :

Example 21 with CTPlotArea

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

the class XSSFScatterChartData 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 CTScatterChart scatterChart = plotArea.addNewScatterChart();
    addStyle(scatterChart);
    for (CustomChartSeries s : series) {
        s.addToChart(scatterChart);
    }
    for (ChartAxis ax : axis) {
        scatterChart.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) CTScatterChart(org.openxmlformats.schemas.drawingml.x2006.chart.CTScatterChart) 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)

Example 22 with CTPlotArea

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

the class XSSFStackedBarChartData 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 CTBarChart barChart = plotArea.addNewBarChart();
    barChart.addNewVaryColors().setVal(false);
    // create a stacked bar
    barChart.addNewGrouping().setVal(barGrouping);
    barChart.addNewOverlap().setVal((byte) OVERLAPPERCENTAGE);
    // set bars orientation
    barChart.addNewBarDir().setVal(barDir);
    xssfChart.setTitleText(this.title);
    CTValAx[] ctValAx = plotArea.getValAxArray();
    if (ctValAx.length != 0) {
        ctValAx[0].addNewMajorGridlines().addNewSpPr().addNewSolidFill();
        ctValAx[0].getCrossBetween().setVal(STCrossBetween.BETWEEN);
    }
    for (CustomChartSeries s : series) {
        s.addToChart(barChart);
    }
    for (ChartAxis ax : axis) {
        barChart.addNewAxId().setVal(ax.getId());
    }
}
Also used : XSSFChart(org.apache.poi.xssf.usermodel.XSSFChart) CTValAx(org.openxmlformats.schemas.drawingml.x2006.chart.CTValAx) CustomChartSeries(org.devgateway.toolkit.web.excelcharts.CustomChartSeries) ChartAxis(org.apache.poi.ss.usermodel.charts.ChartAxis) CTPlotArea(org.openxmlformats.schemas.drawingml.x2006.chart.CTPlotArea) CTBarChart(org.openxmlformats.schemas.drawingml.x2006.chart.CTBarChart)

Aggregations

CTPlotArea (org.openxmlformats.schemas.drawingml.x2006.chart.CTPlotArea)22 XSSFChart (org.apache.poi.xssf.usermodel.XSSFChart)18 ChartAxis (org.apache.poi.ss.usermodel.charts.ChartAxis)16 CustomChartSeries (org.devgateway.toolkit.web.excelcharts.CustomChartSeries)14 CTValAx (org.openxmlformats.schemas.drawingml.x2006.chart.CTValAx)10 CellRangeAddress (org.apache.poi.ss.util.CellRangeAddress)4 CTCatAx (org.openxmlformats.schemas.drawingml.x2006.chart.CTCatAx)4 CTChart (org.openxmlformats.schemas.drawingml.x2006.chart.CTChart)4 CTPieChart (org.openxmlformats.schemas.drawingml.x2006.chart.CTPieChart)4 CTBarChart (org.openxmlformats.schemas.drawingml.x2006.chart.CTBarChart)3 CTLineChart (org.openxmlformats.schemas.drawingml.x2006.chart.CTLineChart)3 CTScatterChart (org.openxmlformats.schemas.drawingml.x2006.chart.CTScatterChart)3 AddTrace (com.google.firebase.perf.metrics.AddTrace)2 SpreadsheetUtils.getCellRangeAddress (com.supercilex.robotscouter.data.client.spreadsheet.SpreadsheetUtils.getCellRangeAddress)2 SpreadsheetUtils.getMetricForChart (com.supercilex.robotscouter.data.client.spreadsheet.SpreadsheetUtils.getMetricForChart)2 SpreadsheetUtils.getStringForCell (com.supercilex.robotscouter.data.client.spreadsheet.SpreadsheetUtils.getStringForCell)2 PreferencesUtilsKt.setShouldShowExportHint (com.supercilex.robotscouter.util.PreferencesUtilsKt.setShouldShowExportHint)2 PreferencesUtilsKt.shouldShowExportHint (com.supercilex.robotscouter.util.PreferencesUtilsKt.shouldShowExportHint)2 OutputStream (java.io.OutputStream)2 POIXMLDocumentPart (org.apache.poi.POIXMLDocumentPart)2