Java Apache POI Excel 折线图生成示例

import java.io.FileInputStream; import java.io.FileOutputStream; import java.io.IOException; import org.apache.poi.ss.usermodel.; import org.apache.poi.ss.util.CellRangeAddress; import org.apache.poi.xddf.usermodel.chart.; import org.apache.poi.xssf.usermodel.*;

public class ExcelChartExample04 { public static void main(String[] args) { String filePath = "input-1.xlsx"; String sheetName = "P1";

    try {
        // 读取Excel文件
        FileInputStream file = new FileInputStream(filePath);
        Workbook workbook = new XSSFWorkbook(file);
        Sheet sheet = workbook.getSheet(sheetName);

        // 创建折线图
        Drawing drawing = sheet.createDrawingPatriarch();
        ClientAnchor anchor = drawing.createAnchor(0, 0, 0, 0, 0, 5, 10, 15);
        Chart chart = drawing.createChart(anchor);
        ChartLegend legend = chart.getOrCreateLegend();
        legend.setPosition(LegendPosition.BOTTOM);

        LineChartData data = chart.getChartDataFactory().createLineChartData();

        // 设置横坐标轴
        ChartAxis bottomAxis = chart.getChartAxisFactory().createCategoryAxis(AxisPosition.BOTTOM);
        bottomAxis.setTitle("时间");
        bottomAxis.setCrosses(AxisCrosses.AUTO_ZERO);

        // 设置纵坐标轴
        ValueAxis leftAxis = chart.getChartAxisFactory().createValueAxis(AxisPosition.LEFT);
        leftAxis.setTitle("数值");
        leftAxis.setCrosses(AxisCrosses.AUTO_ZERO);

        // 读取数据并添加到折线图中
        Row row = sheet.getRow(0);
        for (int i = 0; i < 127; i++) {
            Cell xCell = row.getCell(i);
            Cell yCell = sheet.getRow(2).getCell(i);
            double xValue = xCell.getNumericCellValue();
            double yValue = yCell.getNumericCellValue();

            data.addSeries(
                    chart.getChartAxisFactory().createCategoryAxis(AxisPosition.BOTTOM),
                    chart.getChartAxisFactory().createValueAxis(AxisPosition.LEFT),
                    chart.getChartDataFactory().createCategoryDataSource(sheet, new CellRangeAddress(0, 0, i, i)),
                    chart.getChartDataFactory().createNumericDataSource(sheet, new CellRangeAddress(2, 2, i, i))
            );
        }

        chart.plot(data, bottomAxis, leftAxis);

        // 保存Excel文件
        FileOutputStream outFile = new FileOutputStream(filePath);
        workbook.write(outFile);
        outFile.close();

        System.out.println("折线图已生成并保存在P1工作表中。");

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

}