
有时,客户需要一个标准的模板来填东西,然后在导入
这时可以弄好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();
}