springboot对接poi实现导出excel并动态生成折线图

<dependencies>
    <!-- spring boot web 支持 -->
    <dependency>
        <groupid>org.springframework.boot</groupid>
        <artifactid>spring-boot-starter-web</artifactid>
    </dependency>
    <!-- apache poi 核心库 -->
    <dependency>
        <groupid>org.apache.poi</groupid>
        <artifactid>poi</artifactid>
        <version>5.2.3</version>
    </dependency>
    <!-- 处理 xlsx 格式的ooxml支持 -->
    <dependency>
        <groupid>org.apache.poi</groupid>
        <artifactid>poi-ooxml</artifactid>
        <version>5.2.3</version>
    </dependency>
    <!-- 可选的模式支持，某些图表功能需要 -->
    <dependency>
        <groupid>org.apache.poi</groupid>
        <artifactid>poi-ooxml-schemas</artifactid>
        <version>4.1.2</version>
    </dependency>
</dependencies>

@data
@accessors(chain = true)
public class linechart {
    /**
     * 图表的名称（主标题）
     */
    private string charttitle;
    /**
     * 每条折线的名称（图例）
     */
    private list<string> titlelist;
    /**
     * 每条折线对应的数据值
     */
    private list<list<double>> datalist;
    /**
     * x轴的数据点标签（如：月份、季度）
     */
    private list<object> xaxislist;
}

@data
@accessors(chain = true)
public class chartposition {
    /** 图表左上角所在的列索引（从0开始） */
    private int col1;
    /** 图表左上角所在的行索引（从0开始） */
    private int row1;
    /** 图表右下角所在的列索引 */
    private int col2;
    /** 图表右下角所在的行索引 */
    private int row2;
    // 以下偏移量通常可设为0
    private int dx1 = 0;
    private int dy1 = 0;
    private int dx2 = 0;
    private int dy2 = 0;
}

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

public class chartutils {
    
    public static void createline(xssfsheet sheet, chartposition chartposition, linechart linechart) {
        // 1. 获取数据
        list<object> xaxislist = linechart.getxaxislist();
        list<string> charttitlelist = linechart.gettitlelist();
        list<list<double>> chartdatalist = linechart.getdatalist();
        string charttitle = linechart.getcharttitle();

        // 2. 创建绘图对象和图表锚点
        xssfdrawing drawing = sheet.createdrawingpatriarch();
        xssfclientanchor anchor = drawing.createanchor(0, 0, 0, 0, 
                                                     chartposition.getcol1(), chartposition.getrow1(), 
                                                     chartposition.getcol2(), chartposition.getrow2());
        // 3. 创建图表并设置标题
        xssfchart chart = drawing.createchart(anchor);
        chart.settitletext(charttitle);
        chart.settitleoverlay(false);

        // 4. 设置图例位置
        xddfchartlegend legend = chart.getoraddlegend();
        legend.setposition(legendposition.top);

        // 5. 创建坐标轴
        xddfcategoryaxis bottomaxis = chart.createcategoryaxis(axisposition.bottom);
        xddfvalueaxis leftaxis = chart.createvalueaxis(axisposition.left);

        // 6. 准备数据源
        // 6.1 x轴数据（类别）
        xddfcategorydatasource countries = xddfdatasourcesfactory.fromarray(
                arrays.copyof(xaxislist.toarray(), xaxislist.size(), string[].class));
        // 6.2 创建折线图数据对象
        xddflinechartdata data = (xddflinechartdata) chart.createdata(charttypes.line, bottomaxis, leftaxis);

        // 7. 为每个数据系列创建折线
        for (int i = 0; i < chartdatalist.size(); i++) {
            list<double> values = chartdatalist.get(i);
            // 创建y轴数据源
            xddfnumericaldatasource<double> datasource = xddfdatasourcesfactory.fromarray(
                    values.toarray(new double[0]));
            
            // 将数据系列添加到图表
            xddflinechartdata.series series = (xddflinechartdata.series) data.addseries(countries, datasource);
            series.settitle(charttitlelist.get(i), null);
            series.setsmooth(false); // 设置为折线，非平滑曲线
            series.setmarkersize((short) 2); // 设置数据点标记的大小

            // （可选）特殊样式处理，例如为"警戒值"设置虚线
            if ("警戒值".equals(charttitlelist.get(i))) {
                xddflineproperties lineprops = new xddflineproperties();
                lineprops.setpresetdash(new xddfpresetlinedash(presetlinedash.dot));
                series.setlineproperties(lineprops);
            }
        }

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

@restcontroller
public class excelexportcontroller {

    @getmapping("/export/excel-with-chart")
    public void exportexcelwithchart(httpservletresponse response) throws ioexception {
        // 1. 设置响应头，告诉浏览器这是一个要下载的excel文件
        response.setcontenttype("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
        response.setheader("content-disposition", "attachment; filename="data_with_chart.xlsx"");
        
        // 2. 创建工作簿和工作表
        xssfworkbook workbook = new xssfworkbook();
        xssfsheet sheet = workbook.createsheet("数据报表");
        
        // 3. （可选）向工作表填充数据行...
        // 例如：createdatarows(sheet);
        
        // 4. 准备折线图数据
        linechart linechart = new linechart()
                .setcharttitle("销售趋势图")
                .setxaxislist(arrays.aslist("1月", "2月", "3月", "4月", "5月"))
                .settitlelist(arrays.aslist("产品a", "产品b", "警戒值"))
                .setdatalist(arrays.aslist(
                        arrays.aslist(120.0, 150.0, 180.0, 160.0, 200.0),
                        arrays.aslist(90.0, 120.0, 140.0, 130.0, 150.0),
                        arrays.aslist(150.0, 150.0, 150.0, 150.0, 150.0) // 警戒线
                ));
        
        // 5. 定义图表位置（例如：从第0行第0列开始，到第15行第10列结束）
        chartposition position = new chartposition()
                .setcol1(0).setrow1(10).setcol2(10).setrow2(25);
        
        // 6. 调用工具类创建折线图
        chartutils.createline(sheet, position, linechart);
        
        // 7. 将工作簿写入http响应流
        outputstream out = response.getoutputstream();
        workbook.write(out);
        workbook.close();
        out.flush();
    }
}