java生成二值图,如何创建javapoi条形图，结合两个条形值，如给定的图像？

I want to create bar chart something like this with java poi , (Has two set of bars),Till now could find only for single type of bars, can anyone help me out with any reference??

Thanks.

解决方案

Not clear from your question what code for creating bar chart using apache poi you have found already. Until now apache poi does only supporting line chart and scatter chart but not bar chart directly. So creating a bar chart is only possible using the underlaying low level objects. For a reference do starting with org.openxmlformats.schemas.drawingml.x2006.chart.CTChart.

Example code which creates your example chart:

import java.io.FileOutputStream;

import org.apache.poi.ss.usermodel.*;

import org.apache.poi.ss.util.*;

import org.apache.poi.ss.SpreadsheetVersion;

import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import org.apache.poi.xssf.usermodel.XSSFChart;

import org.openxmlformats.schemas.drawingml.x2006.chart.CTChart;

import org.openxmlformats.schemas.drawingml.x2006.chart.CTPlotArea;

import org.openxmlformats.schemas.drawingml.x2006.chart.CTBarChart;

import org.openxmlformats.schemas.drawingml.x2006.chart.CTBoolean;

import org.openxmlformats.schemas.drawingml.x2006.chart.CTBarSer;

import org.openxmlformats.schemas.drawingml.x2006.chart.CTAxDataSource;

import org.openxmlformats.schemas.drawingml.x2006.chart.CTNumDataSource;

import org.openxmlformats.schemas.drawingml.x2006.chart.CTNumRef;

import org.openxmlformats.schemas.drawingml.x2006.chart.CTStrRef;

import org.openxmlformats.schemas.drawingml.x2006.chart.CTSerTx;

import org.openxmlformats.schemas.drawingml.x2006.chart.CTCatAx;

import org.openxmlformats.schemas.drawingml.x2006.chart.CTValAx;

import org.openxmlformats.schemas.drawingml.x2006.chart.CTScaling;

import org.openxmlformats.schemas.drawingml.x2006.chart.CTLegend;

import org.openxmlformats.schemas.drawingml.x2006.chart.STAxPos;

import org.openxmlformats.schemas.drawingml.x2006.chart.STBarDir;

import org.openxmlformats.schemas.drawingml.x2006.chart.STOrientation;

import org.openxmlformats.schemas.drawingml.x2006.chart.STLegendPos;

import org.openxmlformats.schemas.drawingml.x2006.chart.STTickLblPos;

public class BarChart {

private static CTChart createDefaultBarChart(Chart chart, CellReference firstDataCell, CellReference lastDataCell, boolean seriesInCols) {

CTChart ctChart &＃61; ((XSSFChart)chart).getCTChart();

CTPlotArea ctPlotArea &＃61; ctChart.getPlotArea();

CTBarChart ctBarChart &＃61; ctPlotArea.addNewBarChart();

CTBoolean ctBoolean &＃61; ctBarChart.addNewVaryColors();

ctBoolean.setVal(true);

ctBarChart.addNewBarDir().setVal(STBarDir.COL);

int firstDataRow &＃61; firstDataCell.getRow();

int lastDataRow &＃61; lastDataCell.getRow();

int firstDataCol &＃61; firstDataCell.getCol();

int lastDataCol &＃61; lastDataCell.getCol();

String dataSheet &＃61; firstDataCell.getSheetName();

int idx &＃61; 0;

if (seriesInCols) { //the series are in the columns of the data cells

for (int c &＃61; firstDataCol &＃43; 1; c

CTBarSer ctBarSer &＃61; ctBarChart.addNewSer();

CTSerTx ctSerTx &＃61; ctBarSer.addNewTx();

CTStrRef ctStrRef &＃61; ctSerTx.addNewStrRef();

ctStrRef.setF(new CellReference(dataSheet, firstDataRow, c, true, true).formatAsString());

ctBarSer.addNewIdx().setVal(idx&＃43;&＃43;);

CTAxDataSource cttAxDataSource &＃61; ctBarSer.addNewCat();

ctStrRef &＃61; cttAxDataSource.addNewStrRef();

ctStrRef.setF(new AreaReference(

new CellReference(dataSheet, firstDataRow &＃43; 1, firstDataCol, true, true),

new CellReference(dataSheet, lastDataRow, firstDataCol, true, true),

SpreadsheetVersion.EXCEL2007).formatAsString());

CTNumDataSource ctNumDataSource &＃61; ctBarSer.addNewVal();

CTNumRef ctNumRef &＃61; ctNumDataSource.addNewNumRef();

ctNumRef.setF(new AreaReference(

new CellReference(dataSheet, firstDataRow &＃43; 1, c, true, true),

new CellReference(dataSheet, lastDataRow, c, true, true),

SpreadsheetVersion.EXCEL2007).formatAsString());

//at least the border lines in Libreoffice Calc ;-)

ctBarSer.addNewSpPr().addNewLn().addNewSolidFill().addNewSrgbClr().setVal(new byte[] {0,0,0});

}

} else { //the series are in the rows of the data cells

for (int r &＃61; firstDataRow &＃43; 1; r

CTBarSer ctBarSer &＃61; ctBarChart.addNewSer();

CTSerTx ctSerTx &＃61; ctBarSer.addNewTx();

CTStrRef ctStrRef &＃61; ctSerTx.addNewStrRef();

ctStrRef.setF(new CellReference(dataSheet, r, firstDataCol, true, true).formatAsString());

ctBarSer.addNewIdx().setVal(idx&＃43;&＃43;);

CTAxDataSource cttAxDataSource &＃61; ctBarSer.addNewCat();

ctStrRef &＃61; cttAxDataSource.addNewStrRef();

ctStrRef.setF(new AreaReference(

new CellReference(dataSheet, firstDataRow, firstDataCol &＃43; 1, true, true),

new CellReference(dataSheet, firstDataRow, lastDataCol, true, true),

SpreadsheetVersion.EXCEL2007).formatAsString());

CTNumDataSource ctNumDataSource &＃61; ctBarSer.addNewVal();

CTNumRef ctNumRef &＃61; ctNumDataSource.addNewNumRef();

ctNumRef.setF(new AreaReference(

new CellReference(dataSheet, r, firstDataCol &＃43; 1, true, true),

new CellReference(dataSheet, r, lastDataCol, true, true),

SpreadsheetVersion.EXCEL2007).formatAsString());

//at least the border lines in Libreoffice Calc ;-)

ctBarSer.addNewSpPr().addNewLn().addNewSolidFill().addNewSrgbClr().setVal(new byte[] {0,0,0});

}

}

//telling the BarChart that it has axes and giving them Ids

ctBarChart.addNewAxId().setVal(123456);

ctBarChart.addNewAxId().setVal(123457);

//cat axis

CTCatAx ctCatAx &＃61; ctPlotArea.addNewCatAx();

ctCatAx.addNewAxId().setVal(123456); //id of the cat axis

CTScaling ctScaling &＃61; ctCatAx.addNewScaling();

ctScaling.addNewOrientation().setVal(STOrientation.MIN_MAX);

ctCatAx.addNewDelete().setVal(false);

ctCatAx.addNewAxPos().setVal(STAxPos.B);

ctCatAx.addNewCrossAx().setVal(123457); //id of the val axis

ctCatAx.addNewTickLblPos().setVal(STTickLblPos.NEXT_TO);

//val axis

CTValAx ctValAx &＃61; ctPlotArea.addNewValAx();

ctValAx.addNewAxId().setVal(123457); //id of the val axis

ctScaling &＃61; ctValAx.addNewScaling();

ctScaling.addNewOrientation().setVal(STOrientation.MIN_MAX);

ctValAx.addNewDelete().setVal(false);

ctValAx.addNewAxPos().setVal(STAxPos.L);

ctValAx.addNewCrossAx().setVal(123456); //id of the cat axis

ctValAx.addNewTickLblPos().setVal(STTickLblPos.NEXT_TO);

//legend

CTLegend ctLegend &＃61; ctChart.addNewLegend();

ctLegend.addNewLegendPos().setVal(STLegendPos.B);

ctLegend.addNewOverlay().setVal(false);

return ctChart;

}

public static void main(String[] args) throws Exception {

Workbook wb &＃61; new XSSFWorkbook();

Sheet sheet &＃61; wb.createSheet("Sheet1");

DataFormat format &＃61; wb.createDataFormat();

CellStyle oneDecimal &＃61; wb.createCellStyle();

oneDecimal.setDataFormat(format.getFormat("0.0"));

//put some data in the sheet

Row row;

Cell cell;

row &＃61; sheet.createRow(0);

row.createCell(0);

row.createCell(1).setCellValue("Male");

row.createCell(2).setCellValue("Female");

for (int r &＃61; 1; r <7; r&＃43;&＃43;) {

row &＃61; sheet.createRow(r);

cell &＃61; row.createCell(0);

cell.setCellValue(1975 &＃43; r*5);

cell &＃61; row.createCell(1);

cell.setCellValue(java.util.concurrent.ThreadLocalRandom.current().nextDouble(40.0, 70.0));

cell.setCellStyle(oneDecimal);

cell &＃61; row.createCell(2);

cell.setCellValue(java.util.concurrent.ThreadLocalRandom.current().nextDouble(40.0, 70.0));

cell.setCellStyle(oneDecimal);

}

//create empty chart in the sheet

Drawing drawing &＃61; sheet.createDrawingPatriarch();

ClientAnchor anchor &＃61; drawing.createAnchor(0, 0, 0, 0, 0, 7, 8, 20);

Chart chart &＃61; drawing.createChart(anchor);

//create the references to the chart data

CellReference firstDataCell &＃61; new CellReference(sheet.getSheetName(), 0, 0, true, true);

CellReference lastDataCell &＃61; new CellReference(sheet.getSheetName(), 6, 2, true, true);

//create a default bar chart from the data

CTChart ctBarChart &＃61; createDefaultBarChart(chart, firstDataCell, lastDataCell, true);

//now we can customizing the chart

//legend position:

ctBarChart.getLegend().unsetLegendPos();

ctBarChart.getLegend().addNewLegendPos().setVal(STLegendPos.R);

//data labels:

CTBoolean ctboolean &＃61; CTBoolean.Factory.newInstance();

ctboolean.setVal(true);

ctBarChart.getPlotArea().getBarChartArray(0).addNewDLbls().setShowVal(ctboolean);

ctboolean.setVal(false);

ctBarChart.getPlotArea().getBarChartArray(0).getDLbls().setShowSerName(ctboolean);

ctBarChart.getPlotArea().getBarChartArray(0).getDLbls().setShowPercent(ctboolean);

ctBarChart.getPlotArea().getBarChartArray(0).getDLbls().setShowLegendKey(ctboolean);

ctBarChart.getPlotArea().getBarChartArray(0).getDLbls().setShowCatName(ctboolean);

ctBarChart.getPlotArea().getBarChartArray(0).getDLbls().setShowLeaderLines(ctboolean);

ctBarChart.getPlotArea().getBarChartArray(0).getDLbls().setShowBubbleSize(ctboolean);

//val axis maximum:

ctBarChart.getPlotArea().getValAxArray(0).getScaling().addNewMax().setVal(100);

//cat axis title:

ctBarChart.getPlotArea().getCatAxArray(0).addNewTitle().addNewOverlay().setVal(false);

ctBarChart.getPlotArea().getCatAxArray(0).getTitle().addNewTx().addNewRich().addNewBodyPr();

ctBarChart.getPlotArea().getCatAxArray(0).getTitle().getTx().getRich().addNewP().addNewR().setT("School Year");

//series colors:

ctBarChart.getPlotArea().getBarChartArray(0).getSerArray(0).getSpPr().addNewSolidFill().addNewSrgbClr().setVal(new byte[]{0,0,(byte)255});

ctBarChart.getPlotArea().getBarChartArray(0).getSerArray(1).getSpPr().addNewSolidFill().addNewSrgbClr().setVal(new byte[]{0,(byte)255,0});

FileOutputStream fileOut &＃61; new FileOutputStream("BarChart.xlsx");

wb.write(fileOut);

wb.close();

}

}

This example needs the full jar of all of the schemas ooxml-schemas-1.3.jar as mentioned in the FAQ-N10025.