DataGrid 导Excel

Response.Clear(); 

   Response.Buffer= true; 

   Response.Charset="GB2312";    

   Response.AppendHeader("Content-Disposition","attachment;filename=FileNamel.xls"); 

   Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312");//设置输出流为简体中文

   Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。 

   this.EnableViewState = false;    

   System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN",true);

   System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad); 

   System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);

   this.DataGrid1.RenderControl(oHtmlTextWriter); 

   Response.Write(oStringWriter.ToString());

   Response.End();

以上代码copy来用就可以实现了

本文转自   wenyan  51CTO博客，原文链接:http://blog.51cto.com/wenyan/10138