如何导出Excel

源控件如何导出Excel 如：GridView

1. public string ControlToHTML(System.Web.UI.Control Control)
2.     {
3.         string sHTML = string.Empty;
4.         System.IO.StringWriter oTextWriter = new System.IO.StringWriter();
5.         System.Web.UI.HtmlTextWriter oHTMLWriter = new System.Web.UI.HtmlTextWriter(oTextWriter);
6.         Control.RenderControl(oHTMLWriter);
7.         sHTML = oTextWriter.ToString();
8.         System.IO.Stream myStream;
9.         string path=Server.MapPath(".")+"//ok.xls";
10.         myStream = System.IO.File.Create(path);
11.         System.IO.StreamWriter writer = new System.IO.StreamWriter(myStream);
12.         //writer.Write("<stlye>..........样式等");
13.         writer.Write(sHTML);
14.         writer.Close();
15.         myStream.Close();
16.         Response.Redirect("ok.xls");
17.         return sHTML;
20.     }
22. 为避免错误 需要在Page指令加<%@ Page Language="C#"   EnableEventValidation="false"
26. 再重载方法
29.     public override void VerifyRenderingInServerForm(System.Web.UI.Control Control)
30.     {
31.         //覆写，不执行 Base.VerifyRenderingInServerForm 方法，解决执行 RenderControl 产生的错误
32.       
33.     }

复制代码