SpringBoot实现Excel上传与下载

文件上传

@RequestMapping(value = "/doImportExcel", method = RequestMethod.POST)
    @ApiOperation(value = "上传excel")
    public Map<String, Object> doUpload(@RequestParam("file") MultipartFile file) {
        Map<String, Object> result = new HashMap<String, Object>();
        String fileName = "";
        try {
            if (file != null) {
                //获取上传文件名
                fileName = file.getOriginalFilename();
                //获取后缀名
                String sname = fileName.substring(fileName.lastIndexOf("."));
                //获取当前时间并作为时间戳
                String timeStamp = new SimpleDateFormat("yyyy-MM-ddHHmmssSSS").format(new Date());
                //指定上传文件的路径
                String path = "D:\\" + timeStamp + fileName + sname;
                //上传保存
                file.transferTo(new File(path));
            }
            result.put("statusCode", "200");
            result.put("message", "上传成功!");
            result.put("filename", fileName);
        } catch (Exception ex) {
            result.put("statusCode", "300");
            result.put("message", "上传失败:" + ex.getMessage());
        }
        return result;
    }

文件下载

 @RequestMapping(value = "/downloadTemplate", method = RequestMethod.GET)
    public String downLoad(HttpServletResponse response) throws UnsupportedEncodingException {
        String filename = "项目导入模板.xlsx";
        String filePath = "D:\\java\\workreport";
        File file = new File(filePath + "/" + filename);
        if (file.exists()) { //判断文件父目录是否存在
            response.setContentType("application/vnd.ms-excel;charset=UTF-8");
            response.setCharacterEncoding("UTF-8");
            // response.setContentType("application/force-download");
            response.setHeader("Content-Disposition", "attachment;fileName=" + java.net.URLEncoder.encode(filename, "UTF-8"));
            byte[] buffer = new byte[1024];
            FileInputStream fis = null; //文件输入流
            BufferedInputStream bis = null;

            OutputStream os = null; //输出流
            try {
                os = response.getOutputStream();
                fis = new FileInputStream(file);
                bis = new BufferedInputStream(fis);
                int i = bis.read(buffer);
                while (i != -1) {
                    os.write(buffer);
                    i = bis.read(buffer);
                }

            } catch (Exception e) {
                e.printStackTrace();
            }
            System.out.println("----------file download---" + filename);
            try {
                bis.close();
                fis.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
        return "success";
    }