文件导出

最新推荐文章于 2025-02-20 17:36:05 发布

神也会困

最新推荐文章于 2025-02-20 17:36:05 发布

阅读量121

点赞数

CC 4.0 BY-SA版权

文章标签：文件导出

本文链接：https://blog.youkuaiyun.com/qq_42572245/article/details/98172178

jsp

<el-button><a href="/fileupload/export" style="text-decoration: none;color: #8c939d">导出</a></el-button>

controller

   @RequestMapping("export")
    @ResponseBody
    public AjaxResult export(ModelMap map, FileUploadQuery query, HttpServletResponse response) throws UnsupportedEncodingException {
        List<FileKeyin> uploads = service.searchByKeyin(query);
        //准备相应的表头
        String[] heads = {"编号", "标题", "类型", "存档点"};

        List<String[]> datas = new ArrayList<>();
        //2.遍历List<Employee>
        for (int i = 0; i < uploads.size(); i++) {
            FileKeyin upload = uploads.get(i);//拿到某一个员工
//每一行数据与头像长度一致
            String[] rowData = new String[heads.length];
            //设置数据
            rowData[0] = upload.getFileid().toString();
            rowData[1] = upload.getFiletitle();
            rowData[2] = upload.getFiiletype();
            rowData[3] = upload.getFilesave();
            datas.add(rowData);
        }
        String filename = new String("员工.xlsx".getBytes("UTF-8"), "ISO-8859-1");
        try {
            ExcelUtils.exportExcel(filename, heads, datas, response);
            return AjaxResult.me();
        } catch (Exception e) {
            e.printStackTrace();
            return AjaxResult.me().setSuccess(false).setMessage(e.getMessage());
        }
    }