开源easyExcel应用

首先引入excel工具

<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>easyexcel</artifactId>
    <version>2.2.6</version>
</dependency>
入参需传入 HttpServletResponse response

定义文件名称

StringBuilder displayName = new StringBuilder();
displayName.append("AGY_AgentInfoReport");
displayName.append(agentInfoInVO.getUserCode());
displayName.append("_");
displayName.append(DateUtil.getCurrentDateTimeStr().replaceAll(":", "").replaceAll(" ", "_"));
displayName.append(".xlsx");

定义返回体

private void initResponse(HttpServletResponse response, String displayName){
    response.setContentType("application/vnd.ms-excel");
    response.setCharacterEncoding("utf-8");
    response.setHeader("Content-disposition", "attachment;filename="
            + displayName);
}
直接传入参数 进行excel生成 注：agentInfoExcelModelList為模板数据

initResponse(response, displayName.toString());

EasyExcel.write(response.getOutputStream(), AgentInfoExcelModel.class)
        .sheet()
        .doWrite(agentInfoExcelModelList);


参考网址：
https://www.yuque.com/easyexcel/doc/write#1bea3540

talk is cheap. show me the code.