springmvc下载excel模板示例代码

以下是通过springmvc下载项目中的excel模板文件示例代码：

    @ApiOperation("下载excel模板")
    @RequestMapping(value = "/download", method = RequestMethod.GET)
    public void download(HttpServletRequest request,
                         HttpServletResponse response) throws Exception {

        BufferedInputStream bis = null;
        BufferedOutputStream bos = null;
        request.setCharacterEncoding("UTF-8");
        String prefix=".xlsx";
        String fileName="excelTemplate";

        String filePath = "/template/" + fileName+prefix;
        ClassPathResource classPathResource = new ClassPathResource(filePath);
        InputStream inputStream =classPathResource.getInputStream();
        String userAgent = request.getHeader("User-Agent");
        String     downLoadPath = URLDecoder.decode(filePath, "UTF-8");
        System.out.println(downLoadPath);
        try {

            if (userAgent.contains("MSIE") || userAgent.contains("Trident")) {
                fileName = URLEncoder.encode(fileName, "UTF-8");
            } else {
                // 非IE浏览器的处理：
                fileName = new String((fileName).getBytes("UTF-8"), "ISO-8859-1");
            }
            response.setContentType("application/x-msdownload;");
            response.setHeader("Content-disposition", "attachment; filename=" + fileName+prefix);
            response.setHeader("filename",fileName);
            bis = new BufferedInputStream(inputStream);
            bos = new BufferedOutputStream(response.getOutputStream());
            byte[] buff = new byte[2048];
            int bytesRead;
            while (-1 != (bytesRead = bis.read(buff, 0, buff.length))) {
                bos.write(buff, 0, bytesRead);
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            if (bis != null){
                try {
                    bis.close();
                } catch (IOException e) {
                    e.printStackTrace();
                }
            }

            if (bos != null){
                try {
                    bos.close();
                } catch (IOException e) {
                    e.printStackTrace();
                }
            }

        }

    }