easyExcel导出

1.控制层

//导出数据字典接口
@GetMapping("exportData")
public void exportDict(HttpServletResponse response) {
    dictService.exportDictData(response);
}

2.业务层

@Override
public void exportDictData(HttpServletResponse response) {
    //设置下载信息
    response.setContentType("application/vnd.ms-excel");
    response.setCharacterEncoding("utf-8");
    String fileName = "dict";
    response.setHeader("Content-disposition", "attachment;filename="+ fileName + ".xlsx");
    //查询数据库
    List<Dict> dictList = baseMapper.selectList(null);
    //Dict -- DictEeVo
    List<DictEeVo> dictVoList = new ArrayList<>();
    for(Dict dict:dictList) {
        DictEeVo dictEeVo = new DictEeVo();
       // dictEeVo.setId(dict.getId());
        BeanUtils.copyProperties(dict,dictEeVo);
        dictVoList.add(dictEeVo);
    }
    //调用方法进行写操作
    try {
        EasyExcel.write(response.getOutputStream(), DictEeVo.class).sheet("dict")
                .doWrite(dictVoList);
    } catch (IOException e) {
        e.printStackTrace();
    }
}

3.bean

 

4.postman