81,092
社区成员
发帖
与我相关
我的任务
分享
public String createExcelFile(){
PrintWriter out = null;
String forWord="createExcelFile";
scriptId = getRequest().getParameter("scriptId");
maintenanceId = getRequest().getParameter("maintenanceId");
resultOutParam = getRequest().getParameter("resultOutParam");
this.getResponse().setContentType("application/ms-excel;charset=GBK");
this.getResponse().setHeader("content-disposition", "no-cache");
try {
String xlsFilePath = spmServiceCatalogCreateJobManager.getQueryServiceInfoExcel(scriptId, maintenanceId,
resultOutParam, getEmployeeNo(), this.getProjectPath()) ;
out = this.getResponse().getWriter();
out.println("<SCRIPT language=JAVASCRIPT>");
out.println("window.location.href(\"" + this.getProjectPath() + xlsFilePath + "\";)");
out.println("</SCRIPT>");
out.flush() ;
//** *写入操作日志** *//*
createLog(Constants.FMP_Excel_out, "导出查询-Excel");
return forWord ;
} catch (Exception e) {
e.printStackTrace();
log.error(e.getMessage());
return ERROR ;
}finally {
out.close();
}
}
response.setHeader("Content-disposition", "attachment; filename=" + fileName + ".xlsx");
这是我自己的,你百度下,这不难。