使用Apache poi在一个excel工作表中绘制多个折线图。

<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi</artifactId>
    <version>4.1.2</version>
</dependency>

Workbook workbook = new XSSFWorkbook();

Sheet sheet = workbook.createSheet("折线图");

// 示例使用二维数组存储数据
String[][] data = {
        {"日期", "数值1", "数值2", "数值3"},
        {"1月1日", "10", "20", "30"},
        {"1月2日", "15", "25", "35"},
        // ...
};

Drawing drawing = sheet.createDrawingPatriarch();
ClientAnchor anchor = drawing.createAnchor(0, 0, 0, 0, 0, 5, 10, 15);
Chart chart = drawing.createChart(anchor);
chart.setChartTitle("折线图示例");

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

for (int i = 1; i < data.length; i++) {
    String category = data[i][0]; // 获取日期
    LineChartSeries series = data.addSeries(
            DataSources.fromStringCellRange(sheet, new CellRangeAddress(i, i, 1, data[i].length - 1)),
            DataSources.fromStringCellRange(sheet, new CellRangeAddress(i, i, 0, 0)),
            category);
    series.setTitle(data[i][0]); // 设置折线图系列标题
}

chart.plot(data, new ChartAxisPosition[]{ChartAxisPosition.BOTTOM, ChartAxisPosition.LEFT});

FileOutputStream fos = new FileOutputStream("折线图.xlsx");
workbook.write(fos);
fos.close();