后端导出excel【后端不保存文件】

最新推荐文章于 2024-09-16 09:47:29 发布

代码的修行

最新推荐文章于 2024-09-16 09:47:29 发布

阅读量79

点赞数 2

文章标签： excel

本文链接：https://blog.csdn.net/qq_28887189/article/details/139060116

版权

Workbook workbook = ExcelExportUtil.exportExcel(exportParams, DeviceExcelModel.class, list);

// 设置响应头信息
response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
response.setHeader("Content-Disposition", "attachment;");

// 将Excel文档写入输出流
ServletOutputStream outputStream = response.getOutputStream();
workbook.write(outputStream);

// 清理资源
workbook.close();
outputStream.close();

多级

public class DeviceExcelModel implements Serializable {

    private Long level1Id;

    @Excel(name = "一级类别", width = 30, needMerge = true)
    private String level1;

    @ExcelCollection(name = "", type = DeviceExcelModelNode.class)
    private List<DeviceExcelModelNode>  node2List = new ArrayList<>();

}

public class DeviceExcelModelNode implements Serializable {

    private Long level2Id;

    @Excel(name = "二级（名称）", width = 50, needMerge = true)
    private String level2;

    @ExcelCollection(name = "", type = DeviceExcelModelNode.class)
    private List<DeviceExcelModelNode2>  node3List = new ArrayList<>();

}

public class DeviceExcelModelNode2 implements Serializable {

    private Long level3Id;

    @Excel(name = "三级（型号）", width = 50)
    private String level3;

    @Excel(name = "说明书", width = 15)
    private String instructions = "未上传";


}