下载excel模板到当前浏览器

Love The Way You Lie 2022-11-26 04:59 164阅读 0赞

一、xlsx：

@PostMapping(value = "userTemplate")
        public void userTemplate(HttpServletResponse response, HttpServletRequest request) {
            File file = new File(this.getClass().getClassLoader().getResource("").getPath() + File.separator + "templates" + File.separator + "userTemplate.xlsx");
            SXSSFWorkbook sxssfWorkbook = null;
            try {
                InputStream is = new FileInputStream(file);
                sxssfWorkbook = new SXSSFWorkbook( (XSSFWorkbook) WorkbookFactory.create(is) );
                //  设置响应头信息。
                response.setHeader("Charset", "UTF-8");
                response.setHeader("Content-Type", "application/force-download");
                response.setHeader("Content-Type", "application/vnd.ms-excel");
                response.setHeader("Content-disposition", "attachment; filename=" + URLEncoder.encode("用户明细模板" , "utf-8")+ ".xlsx");
                response.flushBuffer();
                OutputStream outputStream = response.getOutputStream();
                sxssfWorkbook.write(outputStream);
                //  处理在磁盘上支持此工作簿的临时文件。
                sxssfWorkbook.dispose();
            } catch (Exception e) {
               
            } finally {
                if (null != sxssfWorkbook){
                    try {
                        sxssfWorkbook.close();
                    }catch (Exception e){
                       
                    }
                }
            }
        }

二、xls：

@PostMapping(value = "userTemplate")
        public void userTemplate(HttpServletResponse response, HttpServletRequest request) {
            File file = new File(this.getClass().getClassLoader().getResource("").getPath() + File.separator + "templates" + File.separator + "userTemplate.xls");
            HSSFWorkbook sxssfWorkbook = null;
            try {
                InputStream is = new FileInputStream(file);
                sxssfWorkbook = new HSSFWorkbook(is);
                //  设置响应头信息。
                response.setHeader("Charset", "UTF-8");
                response.setHeader("Content-Type", "application/force-download");
                response.setHeader("Content-Type", "application/vnd.ms-excel");
                response.setHeader("Content-disposition", "attachment; filename=" + URLEncoder.encode("用户模板" , "utf-8")+ ".xls");
                response.flushBuffer();
                OutputStream outputStream = response.getOutputStream();
                sxssfWorkbook.write(outputStream);
                //  处理在磁盘上支持此工作簿的临时文件。
                //sxssfWorkbook.dispose();
            } catch (Exception e) {
               
            } finally {
                if (null != sxssfWorkbook){
                    try {
                        sxssfWorkbook.close();
                    }catch (Exception e){
                       
                    }
                }
            }
        }