开发学院 WEB开发 ASP.NET 将ASP.NET页面内的数据导出到Excel 或 Word中阅读

将ASP.NET页面内的数据导出到Excel 或 Word中

　2006-07-11 17:10:42　来源：WEB开发网　　　

核心提示：在以下按钮单击事件中实现：PRivate void btnMIME_Click(object sender, System.EventArgs e){ BindData(); Response.ContentType = "application/vnd.ms-Excel"; Response.Ad

在以下按钮单击事件中实现：
PRivate void btnMIME_Click(object sender, System.EventArgs e)
{
BindData();
Response.ContentType = "application/vnd.ms-Excel";
Response.AddHeader("Content-Disposition", "inline;filename="
　 +　 HttpUtility.UrlEncode("下载文件.xls",Encoding.UTF8　 )　 );　

//如果输出为Word，修改为以下代码
//Response.ContentType = "application/ms-word"
//Response.AddHeader("Content-Disposition", "inline;filename=test.doc")
StringBuilder sb=new StringBuilder();
System.IO.StringWriter sw = new System.IO.StringWriter(sb);
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw);
sb.Append("<html><body>");
dgShow.RenderControl(hw);
sb.Append("</body></html>");
Response.Write(sb.ToString());
Response.End();
}
注：1.若DataGrid中有按钮列，则在导出前应先将其隐藏.
　 2.若DataGrid有分页，而又要打印所有数据的话就应先取消分页.

http://pyt5208.cnblogs.com/archive/2006/07/10/447048.html