C# js 导出execl

[forget_loves]

当前页面Query/PlanListSearch.aspx
前台js
function DownloadFile() {

var iframe = document.createElement('iframe');
iframe.id="iframeId";
$('#iframeId').attr('runat','server')
parent.ShowBlockUI('导出中...请稍候'); ---罩层
var params = "";
var projectID = document.getElementById("i02r0_pid").value;
//alert(projectID);
if (projectID != null) {
params = params + "&ProjectIDs=" + projectID;
}
// var planID = document.getElementById("i03r0_pid").value;

var planName=$.trim($("#<%=txtPlanName.ClientID%>").val());
//alert(planID);
if (planName.length>0) {
params = params + "&PlanName=" +escape(planName);
}

var planTypeStr = <%=plItemTree2.ClientID %>.get_PlanTypeStrValue(); //从树形取“计划类型”逗号分隔字符串（而“节点类型”，则在后台可依此值调用方法获取） 。 By Liangning 2013/10/08 14:45
//alert( planTypeStr);
if (planTypeStr) {
params = params + "&planTypeStr=" + planTypeStr;
}
var approveID = document.getElementById("<%=hfUserID.ClientID%>").value;
if (approveID != null) {
params = params + "&ApproveID=" + approveID;
}
var receiverID = document.getElementById("<%=hidReceiverID.ClientID %>").value;
if (receiverID != null) {
params = params + "&ReceiverID=" + receiverID;
}
var taskName = document.getElementById("<%=txtTaskName.ClientID%>").value;
if (taskName != null && taskName != "") { params = params + "&TaskName=" + escape(taskName); }
var complete = document.getElementById("<%=completeList.ClientID%>").value;
if (complete != null && complete != "" && complete != "-1") { params = params + "&IsClosed=" + complete; }
var light = document.getElementById("<%=lightList.ClientID%>").value;
if (light != null && light != "" && light != "0") { params = params + "&Light=" + light; }
var stage = document.getElementById("<%=stage.ClientID%>").options[document.getElementById("<%=stage.ClientID%>").selectedIndex].text;
if (stage != null && stage != "" && stage != "全部") { params = params + "&Stage=" + escape(stage); }
//modify by zhangmin 2012-12-12 planType 没有找到
//if (planType != null && planType != "" && planType != "全部") { params = params + "&Stage=" + escape(planType); }
var startDate = parseDate(document.getElementById("<%=tbxStart.ClientID%>").value);
if (!isNaN(startDate) && startDate != null) { params = params + "&PlanStartDateStart=" + document.getElementById("<%=tbxStart.ClientID%>").value; }
var startEndDate = parseDate(document.getElementById("<%=tbxStartEnd.ClientID%>").value);
if (!isNaN(startEndDate) && startEndDate != null) { params = params + "&PlanStartDateEnd=" + document.getElementById("<%=tbxStartEnd.ClientID%>").value; }
var taskLevel = document.getElementById("<%=taskLevel.ClientID%>").value;
if (taskLevel != null && taskLevel != "" && taskLevel != "0") { params = params + "&TaskLevel=" + taskLevel; }
var endDate = parseDate(document.getElementById("<%=tbxEnd.ClientID%>").value);
if (!isNaN(endDate) && endDate != null) { params = params + "&PlanFinishDateStart=" + document.getElementById("<%=tbxEnd.ClientID%>").value; }
var endEndDate = parseDate(document.getElementById("<%=tbxEndEnd.ClientID%>").value);
if (!isNaN(endEndDate) && endEndDate != null) { params = params + "&PlanFinishDateEnd=" + document.getElementById("<%=tbxEndEnd.ClientID%>").value; }
var sendDept = document.getElementById("<%= txtSendDept.ClientID %>").value;
if (trim(sendDept) != null && trim(sendDept) != "") { params = params + "&sendDept=" + trim(sendDept); }
var receiveDept = document.getElementById("<%= txtReceiveDept.ClientID %>").value;
if (trim(receiveDept) != null && trim(receiveDept) != "") { params = params + "&receiveDept=" + trim(receiveDept); }
var PlanIDs = document.getElementById("<%= hdfPlanIDs.ClientID %>").value;
if (trim(PlanIDs) != "") { params = params + "&PlanIDs=" + trim(PlanIDs); }
// debugger;
var IsContainFinishedPlan = $("input:radio:checked[name$=IsContainFinishedPlan]").val();
if(IsContainFinishedPlan!=undefined && IsContainFinishedPlan!=""){
params = params + "&IsContainFinishedPlan=" + IsContainFinishedPlan;//是否显示结束的计划
}
var fileurl = "/Query/PlanListSearch.aspx?Action=Export" + params;

iframe.src = fileurl;
iframe.style.display = 'none';
document.body.appendChild(iframe);
return false;
}
后台
private void GenerateExcelFile(DataTable bindTable)
{

if (bindTable == null || bindTable.Rows.Count == 0)
{
AjaxAlert("无符合条件的导出信息！");
return;
}
ExcelExporter exporter = new ExcelExporter();
if (exporter.OpenExcelFile(ConfigurationManager.AppSettings[ConstSet.AppSettings.FILE_FOLDER] + @"Project\ProjectList.xls", MapPath(@"\inc\Aspose.Total.lic")))
{
bindTable.TableName = "Plan";
System.Collections.Hashtable columnNamePair = new System.Collections.Hashtable();
columnNamePair.Add("ProjectName", "项目名称");
columnNamePair.Add("PlanName", "计划名称");
columnNamePair.Add("SerialNo", "序号");
columnNamePair.Add("TaskLevel", "级别");
columnNamePair.Add("TaskName", "业务事项");
columnNamePair.Add("Stage", "阶段");
columnNamePair.Add("SendDept", "发起部门");
columnNamePair.Add("ReceiveDept", "接收部门");
columnNamePair.Add("PlanStartDate", "计划开始日期");
columnNamePair.Add("Period", "周期");
columnNamePair.Add("PlanFinishDate", "计划完成日期");
columnNamePair.Add("TargetDate", "预计完成日期");
columnNamePair.Add("CloseDate", "实际完成日期");
MemoryStream stream = exporter.ExportAsStream(bindTable, columnNamePair, "业务事项");
Response.Clear();
Response.ClearHeaders();
Response.Buffer = false;
Response.ContentType = "application/octet-stream";
Response.AppendHeader("Content-Disposition", "attachment;filename=" + Server.UrlEncode("计划节点情况") + "(" + DateTime.Now.ToString("yyyyMMddHHmmss") + ").xls");
Response.AppendHeader("Content-Length", stream.Length.ToString());
Response.OutputStream.Write(stream.ToArray(), 0, (int)stream.Length);
stream.Close();
Page.ClientScript.RegisterStartupScript(typeof(BasePage), "blockUI", "<script>parent.HiddenBlockUI();</script>");
//Response.Flush();
//Response.End();

}

}
后台出怎么写那个罩层去掉的

[wangnaisheng]

js导出execl

[花花VS珍桂]

为啥导出写的那么麻烦。。。