导出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();

}