导出下载模板

  @ApiOperation(value = "下载模板")
    @GetMapping("/download")
    public void download(HttpServletRequest request, HttpServletResponse response) throws IOException, FinanceException {
        userManagementService.download(request,response);
         }
 public void download(HttpServletRequest request, HttpServletResponse response) throws IOException, FinanceException {
        InputStream inStream = getClass().getClassLoader().getResourceAsStream("excel/user.xlsx");
        if (null != inStream) {
            try {
                // 设置输出的格式
                response.reset();
                response.setContentType("application/vnd.ms-excel");
                response.addHeader("Access-Control-Allow-Origin", "*");
                response.addHeader("Access-Control-Allow-Methods", "GET, POST, PUT, DELETE");
                response.addHeader("Access-Control-Allow-Headers", "Content-Type");
                response.addHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode("excel/人员修改模板.xlsx", "UTF-8"));
                // 循环取出流中的数据
                byte[] b = new byte[200];
                int len;
                while ((len = inStream.read(b)) > 0) {
                    response.getOutputStream().write(b, 0, len);
                }
                inStream.close();
            } catch (IOException e) {
                e.printStackTrace();
            } finally {
                if (null != inStream) {
                    try {
                        inStream.close();
                    } catch (IOException e) {
                        e.printStackTrace();
                    }
                }

            }
        } else {
            throw new FinanceException(111,"获取excle错误,请联系管理员");
        }

原文地址:https://www.cnblogs.com/yangxiaoli/p/14250580.html