把Table中的内容输出到Excel 中

把一Table中的内容输出到Excel 中
1。 拖一HTML控件Table 到 Web 页面中, id 为 TABLE1
2.   在Html文件中加入属性 runat = "server".
e   g:<TABLE id="TABLE1" ... runat="server">
3. 加一按钮,把下面的函数加入此按钮产生的事件中.
private void ibtnDaoChu_Click(object sender, System.Web.UI.ImageClickEventArgs e)
  {
   
   Response.Clear();
   Response.Buffer= true;
   
   Response.AppendHeader("Content-

Disposition","attachment;filename=Store.xls");
   Response.ContentEncoding=System.Text.Encoding.GetEncoding("gb2312");

   Response.ContentType = "application/ms-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);
   

   TABLE1.RenderControl(oHtmlTextWriter);
   

   Response.Charset="gb2312";
   Response.Write(oStringWriter.ToString());
   Response.End();
  }

4.测试成功.

转载于:https://www.cnblogs.com/easylearning/archive/2005/12/01/288623.html