使用Apache POI设置Excel工作表散点图标记图标的颜色

import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFChart;
import org.apache.poi.xssf.usermodel.XSSFChartLegend;
import org.apache.poi.xssf.usermodel.XSSFColor;
import org.apache.poi.xssf.usermodel.XSSFScatterChartData;
import org.apache.poi.xssf.usermodel.XSSFScatterChart;
import org.apache.poi.xssf.usermodel.XSSFChartAxis;
import org.apache.poi.xssf.usermodel.XSSFValueAxis;
import org.apache.poi.xssf.usermodel.XSSFCategoryAxis;
import org.apache.poi.xssf.usermodel.XSSFChartData;
import org.apache.poi.xssf.usermodel.XSSFChartLegend;

Workbook workbook = new XSSFWorkbook();
Sheet sheet = workbook.createSheet("Scatter Chart");

XSSFDrawing drawing = (XSSFDrawing) sheet.createDrawingPatriarch();
XSSFClientAnchor anchor = drawing.createAnchor(0, 0, 0, 0, 0, 5, 10, 15);
XSSFChart chart = drawing.createChart(anchor);
XSSFScatterChartData scatterChartData = chart.getChartDataFactory().createScatterChartData();

// 设置散点图的数据范围
ChartDataSource<Number> xData = DataSources.fromNumericCellRange(sheet, new CellRangeAddress(1, 10, 0, 0));
ChartDataSource<Number> yData = DataSources.fromNumericCellRange(sheet, new CellRangeAddress(1, 10, 1, 1));
scatterChartData.addSerie(xData, yData);

XSSFScatterChart scatterChart = (XSSFScatterChart) chart;
XSSFChartLegend legend = chart.getOrCreateLegend();
XSSFChartAxis xAxis = scatterChart.getAxes().get(0);
XSSFValueAxis yAxis = scatterChart.getAxes().get(1);

// 设置散点图标记的颜色
XSSFChartData.Series series = scatterChartData.getSeries().get(0);
XSSFShapeProperties shapeProperties = series.getShapeProperties();
XSSFColor color = new XSSFColor(new java.awt.Color(255, 0, 0)); // 设置为红色
shapeProperties.setLineColor(color);
shapeProperties.setFillColor(color);

chart.plot(scatterChartData);

FileOutputStream fileOut = new FileOutputStream("scatter_chart.xlsx");
workbook.write(fileOut);
fileOut.close();
workbook.close();