导出excel

//导出用户信息为excel文件
    @RequestMapping("export")
    public void export(HttpServletRequest request,HttpServletResponse resp){
        List<User> users = userService.selectAll();
        users.forEach(user->user.setPhoto(request.getServletContext().getRealPath("back/user/image/")+user.getPhoto()));
        Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams("用户信息","用户"), User.class, users);
        String fileName = "用户表("+new SimpleDateFormat("yyyy-MM-dd").format(new Date())+").xls";
        //处理中文下载名乱码
        try {
            fileName = new String(fileName.getBytes("gbk"),"iso-8859-1");
            //设置 response
            resp.setContentType("application/vnd.ms-excel");
            resp.setHeader("content-disposition","attachment;filename="+fileName);
            workbook.write(resp.getOutputStream());
            workbook.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }