C#打印EXCEL js调用方法

0.要打印的页面JS方法调用

//导出
function RePort() {
var xmmc = document.getElementById("txtXMMC").value;
var sec = document.getElementById("txtsec").value;
var tzsmll = document.getElementById("txttzsmll").value;
var tzmax = document.getElementById("txttzmax").value;
var mjsmll = document.getElementById("txtmjsamll").value;
var mjmax = document.getElementById("txtmjmax").value;
var xmlx = $("#ddlxmlx").val();
var xmjd = $("#ddlxmjd").val();

$.ligerDialog.open({ title: '请稍后...', width: 200, content: '正在导出，请稍后.....'
, url: "../RePort.aspx?xmmc=" + encodeURI(encodeURI(xmmc)) + "&sec=" + sec + "&tzsmll=" + tzsmll + "&tzmax=" + tzmax + "&mjsmll=" + mjsmll + "&mjmax=" + mjmax + "&xmlx=" + xmlx + "&xmjd=" + xmjd + ""
});
setTimeout(function () {
$.ligerDialog.hide();
}, 3000);
}

1.RePort.aspx页面前台方法实用用户控件

2.后台方法1.
private string RedContro()
{
string result = "";
StringBuilder build = new StringBuilder();
HtmlTextWriter htmlWriter = new HtmlTextWriter(new StringWriter(build));
try
{
this.SearchRePort.RenderControl(htmlWriter);
}
catch { }
finally
{
htmlWriter.Flush();
result = build.ToString();
}
return result;//返回控件的HTML代码
}

3.后台方法2

///

/// 导出Excel
///

void exportexcel()
{
Response.Clear();
Response.Buffer = true;
Response.Charset = "utf-8";
Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(expTitle + ".xls", Encoding.UTF8).ToString());
Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");

Response.ContentType = "application/ms-excel";
this.EnableViewState = false;
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
oHtmlTextWriter.WriteLine(RedContro());
Response.Write(oStringWriter.ToString());
Response.End();
}

4.调用即可
exportexcel();