POI实现模板的导出

前 言：

　此篇介绍的只是在服务器上将模板下载下来，不设计数据的处理，后续在发布一版关于数据处理导出的。

前端代码

<button type="button" onclick="excelExport()" class="layui-btn layui-btn-small">模板下载</button>

按钮点击调用

  function excelExport() {
    window.location.href = "/prisoner/exportTemplateExcel";
  }

后端java接口

    @RequestMapping(value = "/exportTemplateExcel", method= RequestMethod.GET)
    @ResponseBody
    public void exportTemplateExcel(HttpServletRequest request , HttpServletResponse response) throws IOException {

        // 获取固定Excel文件作为输入流 (参数为配置的模板路径)
        InputStream in = this.getClass().getResourceAsStream("/static/template/fxrymm.xlsx");
        OutputStream toClient = null;
        byte[] buffer;
        try {
            // 获取导出文件的字节数组
            ByteArrayOutputStream outStream = new ByteArrayOutputStream();
            byte[] buffer1 = new byte[1024];
            int len = 0;
            while ((len = in.read(buffer1)) != -1) {
                outStream.write(buffer1, 0, len);
            }
            in.close();
            buffer = outStream.toByteArray();

            // 导出Excel
            if (null != buffer && buffer.length > 0) {
                // 清空response
                response.reset();
                // 设置response的Header
                response.addHeader("Content-Disposition",
                        "attachment;filename=" + new String(("服刑人员模板.xlsx").getBytes("GBK"), "ISO8859_1"));
                response.addHeader("Content-Length", "" + buffer.length);
                toClient = response.getOutputStream();
                response.setContentType("application/octet-stream");
                toClient.write(buffer);
                toClient.flush();
            }
        } catch (IOException e) {
            e.printStackTrace();
        } finally {
            if(toClient != null){
                toClient.close();
            }
            if(in != null){
                in.close();
            }
        }

    }