SpringMVC实现导出Excel功能

 

    
    //1.在controller需要做excel下载的方法中增加HttpServletResponse入参
    public void export(HttpServletResponse response){

        //2.从response中获取输出流，并设置输出流的格式
        OutputStream output = response.getOutputStream();
        response.reset();
        response.setHeader("Content-disposition", "attachment; filename=abc.xlsx");
        response.setContentType("application/msexcel");

        //3.使用EasyExcel组织excel数据
        ExcelWriter writer = new ExcelWriter(output, ExcelTypeEnum.XLSX);
        Sheet sheet1 = new Sheet(1, 0, ExcelPropertyIndexModel.class);
        sheet1.setSheetName("sheet1");
        List<ExcelPropertyIndexModel> data = new ArrayList<>();
        writer.write(data, sheet1);
        writer.finish();

    }