java 雷达图_POI生成原生Excel-雷达图

使用POI结合Excel的行列生成雷达图

一、先放最后输出的结果图：

雷达图

二、代码

@Test

public void createRadar() throws IOException {

final String sheetName = "RadarChart";

try (XSSFWorkbook workbook = new XSSFWorkbook()) {

XSSFSheet sheet = workbook.createSheet(sheetName);

for (int i = 0; i < 16; i++) {

XSSFRow row = sheet.createRow(i);

XSSFCell cell = row.createCell(0);

cell.setCellValue(i + "行");

XSSFCell cell1 = row.createCell(1);

cell1.setCellValue(RandomUtils.nextInt(0, 20));

}

XSSFDrawing drawing = sheet.createDrawingPatriarch();

XSSFClientAnchor anchor = drawing.createAnchor(0, 0, 0, 0, 2, 0, 7, 16);

XSSFChart chart = drawing.createChart(anchor);

CTChart ctChart = chart.getCTChart();

ctChart.addNewAutoTitleDeleted().setVal(false);

// ctChart.addNewPlotVisOnly().setVal(true);

// ctChart.addNewDispBlanksAs().setVal(STDispBlanksAs.GAP);

// ctChart.addNewShowDLblsOverMax().setVal(false);

CTPlotArea ctPlotArea = ctChart.addNewPlotArea();

ctPlotArea.addNewLayout();