public class WordAreaChart 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}));
// 样式线
XDDFLineProperties line = new XDDFLineProperties();
line.setFillProperties(new XDDFSolidFillProperties(XDDFColor.from(new byte[] {(byte)228,(byte)231,(byte)237})));
line.setWidth(0.5);
XDDFLineProperties noLine = new XDDFLineProperties();
noLine.setFillProperties(new XDDFNoFillProperties());
// 图例
if(options.isShowLegend()) {
XDDFChartLegend legend = chart.getOrAddLegend();
legend.setPosition(options.getLegendPosition());
}
// X轴
XDDFCategoryAxis xAxis = chart.createCategoryAxis(AxisPosition.BOTTOM);
if(!options.isShowXAxis()) {
xAxis.setVisible(false);// X轴不显示
}
xAxis.setMajorTickMark(AxisTickMark.NONE);// 轴刻度线
// 标签样式
XDDFRunProperties xTextProperties = xAxis.getOrAddTextProperties();
xTextProperties.setFillProperties(fontColor);
// 轴线样式
XDDFShapeProperties xAxisLineProperties = xAxis.getOrAddShapeProperties();
if(options.isShowXAxisLine()) {
xAxisLineProperties.setLineProperties(line);
} else {
xAxisLineProperties.setLineProperties(noLine);
}
// 网格线
if(options.isShowXGrid()) {
XDDFShapeProperties xGridProperties = xAxis.getOrAddMajorGridProperties();
xGridProperties.setLineProperties(line);
}
// Y轴
XDDFValueAxis yAxis = chart.createValueAxis(AxisPosition.LEFT);
if(!options.isShowYAxis()) {
yAxis.setVisible(false);// Y轴不显示
}
yAxis.setMajorTickMark(AxisTickMark.NONE);// 轴刻度线
// 标签样式
XDDFRunProperties yTextProperties = yAxis.getOrAddTextProperties();
yTextProperties.setFillProperties(fontColor);
// 轴线样式
XDDFShapeProperties yAxisLineProperties = yAxis.getOrAddShapeProperties();
if(options.isShowYAxisLine()) {
yAxisLineProperties.setLineProperties(line);
} else {
yAxisLineProperties.setLineProperties(noLine);
}
// 网格线
if(options.isShowYGrid()) {
XDDFShapeProperties yGridProperties = yAxis.getOrAddMajorGridProperties();
yGridProperties.setLineProperties(line);
}
XDDFAreaChartData area = (XDDFAreaChartData) chart.createData(ChartTypes.AREA, xAxis, yAxis);
XDDFCategoryDataSource xAxisSource = XDDFDataSourcesFactory.fromStringCellRange(sheet,new CellRangeAddress(1, rowIndex - 1, 0, 0));
CTAreaChart c = chart.getCTChart().getPlotArea().getAreaChartArray(0);
for (int i = 1; i < dimensions.length; i++) {
XDDFNumericalDataSource<Double> yAxisSource = XDDFDataSourcesFactory.fromNumericCellRange(sheet,new CellRangeAddress(1, rowIndex - 1, i, i));
XDDFAreaChartData.Series series = (XDDFAreaChartData.Series) area.addSeries(xAxisSource, yAxisSource);
//XDDFSolidFillProperties seriesProperties = new XDDFSolidFillProperties(XDDFColor.from(options.getColor(i-1)));
//series.setFillProperties(seriesProperties);
String name = dimensions[i];
series.setTitle(name, new CellReference(sheetName, 0, i, true, true));
CTAreaSer ser = c.getSerArray(i-1);
CTShapeProperties s = ser.addNewSpPr();
CTSolidColorFillProperties p = s.addNewSolidFill();
CTSRgbColor rgb = p.addNewSrgbClr();
rgb.setVal(options.getColor(i-1));
rgb.addNewAlpha().setVal(options.getDiaphaneity()); // 透明度 0- 100000
}
chart.plot(area);
}
}
效果如下:
本功能所有代码实现,摘自开源项目demo-ureport: 基于spring boot + Vue2 + Element UI + Echarts 重构ureport2中国式复杂报表设计器开源项目目录src/main/java/com/bstek/ureport/export/word/chart下