Java Uso da biblioteca Apache POI

[dcm50]

Olá,

Preciso alterar somente a primeira e a última barra para que ambas não ficam aparecendo só a metade.

 

Segue o código que gera o gráfico acima

 

    private ByteArrayInputStream generateFileDetails(List<ClientDataRequest> clientDataRequest, String metricName){

        ByteArrayOutputStream file = new ByteArrayOutputStream();

        try{
            try(XSSFWorkbook workbook = new XSSFWorkbook()){
                XSSFSheet sheet = workbook.createSheet(metricName);
                Font headerFont = workbook.createFont();
                headerFont.setBold(true);
                headerFont.setUnderline(Font.U_SINGLE);
                CellStyle headerCellStyle = workbook.createCellStyle();
                headerCellStyle.setFillBackgroundColor(IndexedColors.GREY_40_PERCENT.getIndex());
                headerCellStyle.setFont(headerFont);

                XSSFDrawing drawing = sheet.createDrawingPatriarch();
                XSSFClientAnchor anchor = drawing.createAnchor(0, 0, 0, 0, 5, 1, 14, 10 + clientDataRequest.size());

                Row headerRow = sheet.createRow(anchor.getRow2()+1);
                headerRow.createCell(0).setCellValue("Client Name");
                headerRow.createCell(1).setCellValue("Value");

                for (int i = 0; i < headerRow.getLastCellNum(); i++) {
                    headerRow.getCell(i).setCellStyle(headerCellStyle);
                }

                for (int i = 0; i < clientDataRequest.size(); i++) {
                    Row row = sheet.createRow(anchor.getRow2() + 2 + i);
                    row.createCell(0).setCellValue(clientDataRequest.get(i).getClientName());
                    sheet.autoSizeColumn(0);
                    row.createCell(1).setCellValue(clientDataRequest.get(i).getValue());
                    sheet.autoSizeColumn(1);
                }

                XSSFChart chart = drawing.createChart(anchor);
                chart.setTitleText(metricName);
                chart.setTitleOverlay(false);

                //XDDFChartLegend legend = chart.getOrAddLegend();
                //legend.setPosition(LegendPosition.TOP_RIGHT);

                XDDFCategoryAxis bottomAxis = chart.createCategoryAxis(AxisPosition.BOTTOM);
                bottomAxis.setTitle("Client Name");
                XDDFValueAxis leftAxis = chart.createValueAxis(AxisPosition.LEFT);
                leftAxis.setTitle("Value");
                leftAxis.setCrosses(AxisCrosses.AUTO_ZERO);

                XDDFDataSource<String> clientNames = XDDFDataSourcesFactory.fromStringCellRange(sheet,
                        new CellRangeAddress(anchor.getRow2() + 2, anchor.getRow2() + 1 + clientDataRequest.size(), 0, 0));

                XDDFNumericalDataSource<Double> values = XDDFDataSourcesFactory.fromNumericCellRange(sheet,
                        new CellRangeAddress(anchor.getRow2() + 2, anchor.getRow2() +1 + clientDataRequest.size(), 1, 1));

                XDDFChartData data = chart.createData(ChartTypes.BAR, bottomAxis, leftAxis);
                XDDFChartData.Series series = data.addSeries(clientNames, values);
                series.setTitle(metricName, null);
                data.setVaryColors(false);
                chart.plot(data);

                XDDFBarChartData bar = (XDDFBarChartData) data;
                bar.setBarDirection(BarDirection.BAR);

                workbook.write(file);
            }
        } catch (Exception e){

        }

        return new ByteArrayInputStream(file.toByteArray());

    }

 

[dcm50]

Consegui resolver.

Basta adicionar essa linha

 

leftAxis.setCrossBetween(AxisCrossBetween.BETWEEN);