poi导出word柱状图

以下是使用POI导出Word柱状图的步骤：

1. 导入POI库和相关依赖：

import org.apache.poi.xwpf.usermodel.*;
import org.apache.poi.xddf.usermodel.chart.*;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.*;

2. 创建一个新的Word文档：

XWPFDocument document = new XWPFDocument();

3. 创建一个柱状图数据集：

XSSFWorkbook workbook = new XSSFWorkbook();
XSSFSheet sheet = workbook.createSheet("Data");
Row row = sheet.createRow(0);
row.createCell(0).setCellValue("Category");
row.createCell(1).setCellValue("Value1");
row.createCell(2).setCellValue("Value2");

row = sheet.createRow(1);
row.createCell(0).setCellValue("Category 1");
row.createCell(1).setCellValue(10);
row.createCell(2).setCellValue(20);

row = sheet.createRow(2);
row.createCell(0).setCellValue("Category 2");
row.createCell(1).setCellValue(30);
row.createCell(2).setCellValue(40);

row = sheet.createRow(3);
row.createCell(0).setCellValue("Category 3");
row.createCell(1).setCellValue(50);
row.createCell(2).setCellValue(60);

XDDFDataSource<String> categories = XDDFDataSourcesFactory.fromStringCellRange(sheet, new CellRangeAddress(1, 3, 0, 0));
XDDFNumericalDataSource<Double> values1 = XDDFDataSourcesFactory.fromNumericCellRange(sheet, new CellRangeAddress(1, 3, 1, 1));
XDDFNumericalDataSource<Double> values2 = XDDFDataSourcesFactory.fromNumericCellRange(sheet, new CellRangeAddress(1, 3, 2, 2));

4. 创建一个柱状图：

XWPFChart chart = document.createChart(15, 15, 600, 400);
chart.setTitleText("Bar Chart");
chart.setTitleOverlay(false);

XDDFChartLegend legend = chart.getOrAddLegend();
legend.setPosition(LegendPosition.TOP_RIGHT);

XDDFCategoryAxis categoryAxis = chart.createCategoryAxis(AxisPosition.BOTTOM);
XDDFValueAxis valueAxis = chart.createValueAxis(AxisPosition.LEFT);
valueAxis.setCrosses(AxisCrosses.AUTO_ZERO);

XDDFChartData data = chart.createData(ChartTypes.BAR, categoryAxis, valueAxis);
data.setVaryColors(true);

XDDFChartData.Series series1 = data.addSeries(categories, values1);
series1.setTitle("Value1", null);
XDDFChartData.Series series2 = data.addSeries(categories, values2);
series2.setTitle("Value2", null);

chart.plot(data);

5. 将图表插入到Word文档中：

XWPFParagraph paragraph = document.createParagraph();
XWPFRun run = paragraph.createRun();
run.setText("Bar Chart:");
run.addBreak();

XDDFPicture picture = chart.getPreferredSize();
String id = document.addPictureData(picture.getData(), Document.PICTURE_TYPE_PNG);
document.createPicture(id, document.getNextPicNameNumber(Document.PICTURE_TYPE_PNG), picture.getWidth(), picture.getHeight());

6. 保存Word文档：

FileOutputStream out = new FileOutputStream("chart.docx");
document.write(out);
out.close();
document.close();