导出Excel(导出一个模版)

有时,客户需要一个标准的模板来填东西,然后在导入

这时可以弄好excel模板,供导出

/**

     * 导出excel模板文件

     * @param request  

     * @param response

     * @return

     * @throws Exception

     */

    @RequestMapping("downLoadExcelModel")

    @Action(description="导出子表Excel模板文件")

    public void exportExcelMode(HttpServletRequest request,

           HttpServletResponse response) throws Exception{

           String dirPath = FileUtil.getRootPath() + File.separator+"commons" +File.separator+"template"+File.separator+"exportMode"+File.separator;

           String fileName="负荷预测日报表模板.xls";

           ///oms/web/commons/exportMode/负荷预测日报表模板.xls

            FileInputStream inStream = new FileInputStream(new File(dirPath+fileName));

            byte[] buf = new byte[4096]; 

            int readLength; 

            response.setContentType("application/octet-stream;charset=UTF-8");

            response.setHeader("Content-Type","application/vnd.ms-excel");

            response.setHeader( "Content-Disposition", "attachment;filename=" + new String( fileName.getBytes("GB2312"), "8859_1" ));

            response.addHeader("Pargam", "no-cache"); 

            response.addHeader("Cache-Control", "no-cache");

            OutputStream out = response.getOutputStream();   

            while (((readLength = inStream.read(buf)) != -1)) { 

                out.write(buf, 0, readLength); 

            } 

            inStream.close(); 

            out.flush();   

            out.close();

       }

原文地址:https://www.cnblogs.com/rdchen/p/9724049.html