利用Response.ContentType 属性，设置为application/vnd.ms-excel，将文本数据以microsoft excel的格式输出（Response）到客户端。

如，导出DataGrid:

1 //要导出的DataGrid控件   2  3 protected void Button2_Click(object sender, EventArgs e)   4  5     {   6  7         //要导出的控件   8  9         System.Web.UI.Control ctl = this.Label1;  10 11    12 13         //输出属性  14 15         HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=Excel.xls");  16 17         HttpContext.Current.Response.Charset = "UTF-8";  18 19         HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.Default;  20 21         HttpContext.Current.Response.ContentType = "application/ms-excel";  22 23    24 25         //输出空间内容到HtmlTextWriter  26 27         ctl.Page.EnableViewState = false;  28 29         System.IO.StringWriter tw = new System.IO.StringWriter();  30 31         System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);  32 33         ctl.RenderControl(hw);  34 35    36 37         //输出HtmlTextWriter  38 39         HttpContext.Current.Response.Write(tw.ToString());  40 41         HttpContext.Current.Response.End();  42 43     }

 

使用这种方法，可以将大部分控件的数据都导入到Excel文件中。如Literal、GridView、Repeater、Label，只要这些控件中的数据是格式良好的表格，导出的Excel格式也是以表格数据形式展现。

将上边的代码直接写入到Page_Load中，可以将整个页面下载为Excel文件.

1 protected void Page_Load(object sender, EventArgs e)   2  3     {   4  5         if (!IsPostBack)   6  7         {   8  9             Response.Clear();  10 11             Response.Buffer = true;  12 13             Response.AppendHeader("Content-Disposition", "attachment;filename=" + DateTime.Now.ToString("yyyyMMdd") + ".xls");  14 15             Response.ContentEncoding = System.Text.Encoding.UTF8;  16 17             Response.ContentType = "application/vnd.ms-excel";  18 19             this.EnableViewState = false;  20 21         }  22 23     }