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

在以下按钮单击事件中实现：
private void btnMIME_Click(object sender, Sy***m.EventArgs e)
{
 BindData();
 Re***nse.ContentType = "ap***cation/vnd.ms-excel";
 Re***nse.AddHeader("Content-Disposition", "inline;filename="
   +   Ht***tility.UrlEncode("下载文件.xls",En***ing.UTF8 ;  )   );  
 

 //如果输出为Word，修改为以下代码
 //Re***nse.ContentType = "application/ms-word"
 //Re***nse.AddHeader("Content-Disposition", "inline;fi***ame=test.doc")
 StringBuilder sb=new StringBuilder();
 Sy***m.IO.StringWriter sw = new Sy***m.IO.StringWriter(sb);
 Sy***m.Web.UI.HtmlTextWriter hw = new Sy***m.Web.UI.HtmlTextWriter(sw);
 sb***pend("");
 dg***w.RenderControl(hw);
 sb***pend("");
 Re***nse.Write(sb***String());
 Re***nse.End();
}
注：1.若DataGrid中有按钮列，则在导出前应先将其隐藏.
    2.若DataGrid有分页，而又要打印所有数据的话就应先取消分页.

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