poi版本5.2.2
public class WordRadarChart implements WordChart {
public void bulider(XWPFChart chart, ChartOption options) {
String sheetName = "sheet0";
XSSFWorkbook workbook = null;
try {
workbook = chart.getWorkbook();
} catch (Exception e) {
e.printStackTrace();
return;
}
XSSFSheet sheet = workbook.getSheet(sheetName);
int rowIndex = this.refreshSheet(sheet, options);
String[] dimensions = options.getDimensions();
// 字体颜色
XDDFSolidFillProperties fontColor = new XDDFSolidFillProperties(XDDFColor.from(new byte[] {(byte)96,(byte)98,(byte)102}));
// 图例
if(options.isShowLegend()) {
XDDFChartLegend legend = chart.getOrAddLegend();
legend.setPosition(options.getLegendPosition());
}
// X轴
XDDFCategoryAxis xAxis = chart.createCategoryAxis(AxisPosition.BOTTOM);
// 标签样式
XDDFRunProperties xTextProperties = xAxis.getOrAddTextProperties();
xTextProperties.setFillProperties(fontColor);
// Y轴
XDDFValueAxis yAxis = chart.createValueAxis(AxisPosition.LEFT);
// 标签样式
XDDFRunProperties yTextProperties = yAxis.getOrAddTextProperties();
yTextProperties.setFillProperties(fontColor);
// 网格线
XDDFShapeProperties yGridProperties = yAxis.getOrAddMajorGridProperties();
XDDFLineProperties yGridLine = new XDDFLineProperties();
yGridLine.setFillProperties(new XDDFSolidFillProperties(XDDFColor.from(new byte[] {(byte)228,(byte)231,(byte)237})));
yGridLine.setWidth(0.5);
yGridProperties.setLineProperties(yGridLine);
XDDFRadarChartData radar = (XDDFRadarChartData) chart.createData(ChartTypes.RADAR, xAxis, yAxis);
radar.setStyle(RadarStyle.MARKER);
XDDFCategoryDataSource xAxisSource = XDDFDataSourcesFactory.fromStringCellRange(sheet,new CellRangeAddress(1, rowIndex - 1, 0, 0));
CTRadarChart c = chart.getCTChart().getPlotArea().getRadarChartArray(0);
for (int i = 1; i < dimensions.length; i++) {
XDDFNumericalDataSource<Double> yAxisSource = XDDFDataSourcesFactory.fromNumericCellRange(sheet,new CellRangeAddress(1, rowIndex - 1, i, i));
XDDFRadarChartData.Series series = (XDDFRadarChartData.Series) radar.addSeries(xAxisSource, yAxisSource);
XDDFLineProperties lineProperties = new XDDFLineProperties();
XDDFSolidFillProperties seriesProperties = new XDDFSolidFillProperties(XDDFColor.from(options.getColor(i-1)));
lineProperties.setWidth(1.5);
lineProperties.setFillProperties(seriesProperties);
series.setLineProperties(lineProperties);
// 设置标记颜色
CTRadarSer ser = c.getSerArray(i-1);
CTMarker marker = ser.addNewMarker();
setMarkerColor(marker, options.getColor(i-1));
String name = dimensions[i];
series.setTitle(name, new CellReference(sheetName, 0, i, true, true));
}
chart.plot(radar);
}
/**
* 设置标记点颜色
*/
private void setMarkerColor(CTMarker marker, byte[] color) {
marker.addNewSymbol().setVal(STMarkerStyle.CIRCLE);
CTShapeProperties shapeProperties = marker.addNewSpPr();
// 边框颜色
CTLineProperties borderProperties = shapeProperties.addNewLn();
CTSolidColorFillProperties borderColor = borderProperties.addNewSolidFill();
borderColor.addNewSrgbClr().setVal(color);
// 填充颜色
CTSolidColorFillProperties fillProperties = shapeProperties.addNewSolidFill();
fillProperties.addNewSrgbClr().setVal(color);
}
}
效果如下
本功能所有代码实现,摘自开源项目demo-ureport: 基于spring boot + Vue2 + Element UI + Echarts 重构ureport2中国式复杂报表设计器开源项目目录src/main/java/com/bstek/ureport/export/word/chart下