java 雷达图_Java 创建Excel雷达图

要在Java中创建Excel雷达图，您可以使用Apache POI库。以下是一个简单的示例代码：

import java.io.FileOutputStream;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.*;

public class RadarChartExample {

    public static void main(String[] args) throws Exception {
        // 创建工作簿和工作表
        XSSFWorkbook workbook = new XSSFWorkbook();
        XSSFSheet sheet = workbook.createSheet("Radar Chart Example");

        // 创建数据
        Object[][] data = {
                {"Category", "Value 1", "Value 2", "Value 3", "Value 4", "Value 5"},
                {"Data Set 1", 90, 80, 70, 60, 50},
                {"Data Set 2", 60, 70, 80, 90, 100}
        };

        // 创建雷达图
        XSSFChart chart = RadarChart.createRadarChart(workbook, sheet, data, "Radar Chart", "Category", true);

        // 将图表插入工作表
        int chartStartRow = 0;
        int chartStartColumn = 0;
        int chartEndRow = 15;
        int chartEndColumn = 7;
        chart.setTopLeftPosition(new CellAddress(chartStartRow, chartStartColumn));
        chart.setBottomRightPosition(new CellAddress(chartEndRow, chartEndColumn));

        // 保存Excel文件
        FileOutputStream fileOut = new FileOutputStream("RadarChartExample.xlsx");
        workbook.write(fileOut);
        fileOut.close();
        workbook.close();
    }
}

其中，`RadarChart`是一个自定义类，用于创建雷达图。以下是该类的代码：

import java.util.Arrays;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xddf.usermodel.*;
import org.apache.poi.xssf.usermodel.*;

public class RadarChart {

    public static XSSFChart createRadarChart(XSSFWorkbook workbook, XSSFSheet sheet, Object[][] data, String title, String categoryAxisLabel, boolean legend) {
        // 创建图表
        XSSFDrawing drawing = sheet.createDrawingPatriarch();
        XSSFClientAnchor anchor = drawing.createAnchor(0, 0, 0, 0, 0, 5, 10, 20);
        XSSFChart chart = drawing.createChart(anchor);

        // 设置图表标题
        chart.setTitleText(title);
        chart.setTitleOverlay(false);

        // 创建轴
        XDDFCategoryAxis categoryAxis = chart.createCategoryAxis(AxisPosition.BOTTOM);
        categoryAxis.setTitle(categoryAxisLabel);

        XDDFValueAxis valueAxis = chart.createValueAxis(AxisPosition.LEFT);
        valueAxis.setTitle("Value");

        // 创建数据系列
        int numCategories = data.length - 1;
        int numValues = data[0].length - 1;

        XDDFChartData dataSeries = chart.createData(ChartTypes.RADAR, categoryAxis, valueAxis);
        for (int i = 1; i <= numValues; i++) {
            XDDFChartData.Series series = dataSeries.addSeries(categoryAxis.getCellReference(1, i), valueAxis.getCellReference(1, i));
            XDDFNumericalDataSource<Double> values = XDDFDataSourcesFactory.fromArray(Arrays.copyOfRange(data, 1, data.length), i, i);
            series.setValues(values);
            series.setTitle(data[0][i].toString(), null);
        }

        // 隐藏图例
        if (!legend) {
            chart.getOrAddLegend().setPosition(LegendPosition.NONE);
        }

        return chart;
    }
}

运行该代码，将会在当前目录下创建一个名为`RadarChartExample.xlsx`的Excel文件，其中包含一个雷达图。您可以根据需要调整数据和图表属性。