Java POI Excel数据生成Word折线图教程

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

import java.io.*;

public class WordChartExample {

public static void main(String[] args) {
    try {
        // 读取Excel文件
        FileInputStream fileIn = new FileInputStream('巴新EDEVU水库数据处理表.xlsx');
        XSSFWorkbook workbook = new XSSFWorkbook(fileIn);
        XSSFSheet sheet1 = workbook.getSheet('P9');
        XSSFSheet sheet2 = workbook.getSheet('P10');

        // 创建折线图
        XDDFChart chart = createChart(sheet1, sheet2);

        // 创建Word文档
        XWPFDocument document = new XWPFDocument();

        // 添加折线图到文档
        addChartToDocument(document, chart);

        // 保存Word文档
        FileOutputStream fileOut = new FileOutputStream('温度.docx');
        document.write(fileOut);
        fileOut.close();

        System.out.println('折线图已创建并保存到Word文档中。');

    } catch (IOException e) {
        e.printStackTrace();
    }
}

private static XDDFChart createChart(XSSFSheet sheet1, XSSFSheet sheet2) {
    // 创建折线图
    XSSFWorkbook workbook = sheet1.getWorkbook();
    XSSFDrawing drawing = sheet2.createDrawingPatriarch();
    XSSFClientAnchor anchor = drawing.createAnchor(0, 0, 0, 0, 3, 9, 9, 19);
    XSSFChart chart = drawing.createChart(anchor);
    chart.setTitleText('数据折线图');
    chart.setTitleOverlay(false);

    // 设置图例位置
    XDDFChartLegend legend = chart.getOrAddLegend();
    legend.setPosition(LegendPosition.BOTTOM);

    // 创建数据系列
    XDDFCategoryAxis bottomAxis = chart.createCategoryAxis(AxisPosition.BOTTOM);
    XDDFValueAxis leftAxis = chart.createValueAxis(AxisPosition.LEFT);
    leftAxis.setCrosses(AxisCrosses.AUTO_ZERO);

    // 创建数据源
    XDDFNumericalDataSource<Double> xs1 = XDDFDataSourcesFactory.fromNumericCellRange(sheet1, new CellRangeAddress(11, 85, 0, 0));
    XDDFNumericalDataSource<Double> ys1 = XDDFDataSourcesFactory.fromNumericCellRange(sheet1, new CellRangeAddress(11, 85, 2, 2));
    XDDFNumericalDataSource<Double> xs2 = XDDFDataSourcesFactory.fromNumericCellRange(sheet2, new CellRangeAddress(11, 139, 0, 0));
    XDDFNumericalDataSource<Double> ys2 = XDDFDataSourcesFactory.fromNumericCellRange(sheet2, new CellRangeAddress(11, 139, 2, 2));

    // 添加数据系列
    XDDFLineChartData data = (XDDFLineChartData) chart.createData(ChartTypes.LINE, bottomAxis, leftAxis);
    XDDFLineChartData.Series series1 = (XDDFLineChartData.Series) data.addSeries(xs1, ys1);
    series1.setTitle('P9数据折线图', null);
    XDDFLineChartData.Series series2 = (XDDFLineChartData.Series) data.addSeries(xs2, ys2);
    series2.setTitle('P10数据折线图', null);

    // 绘制图表
    chart.plot(data);

    return chart;
}

private static void addChartToDocument(XWPFDocument document, XDDFChart chart) throws IOException {
    // 创建一个空白段落
    XWPFParagraph paragraph = document.createParagraph();

    // 创建一个新的图表段落
    XWPFRun run = paragraph.createRun();
    run.addBreak();
    run.setText('数据折线图');
    run.addBreak();

    // 创建图表图片
    ByteArrayOutputStream chartOut = new ByteArrayOutputStream();
    chart.getWorkbook().write(chartOut);
    chartOut.close();

    // 将图表图片插入到Word文档中
    XWPFRun chartRun = paragraph.createRun();
    chartRun.addPicture(new ByteArrayInputStream(chartOut.toByteArray()), XWPFDocument.PICTURE_TYPE_PNG, 'chart.png', Units.toEMU(500), Units.toEMU(300));
}