POI WORD生成饼图

最新推荐文章于 2024-10-11 19:46:11 发布

huoyingrenzheas

最新推荐文章于 2024-10-11 19:46:11 发布

阅读量487

点赞数

文章标签： word python 开发语言

本文链接：https://blog.csdn.net/huoyingrenzheas/article/details/130384656

版权

该代码示例展示了如何在Java中使用ApachePOI库的5.2.2版本创建Word文档中的饼图。方法`bulider`接收一个`XWPFChart`对象和`ChartOption`，从工作簿获取工作表，设置图例位置，创建饼图数据源，并自定义饼图的颜色。

摘要由CSDN通过智能技术生成

poi版本5.2.2

public class WordPieChart 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);
		
		// 图例
		if(options.isShowLegend()) {
			XDDFChartLegend legend = chart.getOrAddLegend();
			legend.setPosition(options.getLegendPosition());
		}
				
		XDDFPieChartData pie = (XDDFPieChartData) chart.createData(ChartTypes.PIE, null, null);
		XDDFCategoryDataSource categorySource = XDDFDataSourcesFactory.fromStringCellRange(sheet,new CellRangeAddress(1, rowIndex - 1, 0, 0));
		XDDFNumericalDataSource<Double> valueSource = XDDFDataSourcesFactory.fromNumericCellRange(sheet,new CellRangeAddress(1, rowIndex - 1, 1, 1));
		XDDFChartData.Series series = pie.addSeries(categorySource, valueSource);
		
		chart.plot(pie);
		// 自定义饼图颜色
		CTChart c = chart.getCTChart();
		if (c.getAutoTitleDeleted() == null) {
			c.addNewAutoTitleDeleted();
		} 
	    c.getAutoTitleDeleted().setVal(false);
	    int pointCount = series.getCategoryData().getPointCount();
        CTPieSer ser = c.getPlotArea().getPieChartArray(0).getSerArray(0);
        for (int p = 0; p < pointCount; p++) {
    	  ser.addNewDPt().addNewIdx().setVal(p);
    	  ser.getDPtArray(p).addNewSpPr().addNewSolidFill().addNewSrgbClr().setVal(options.getColor(p));
        }
	}
}

效果如下