利用Response.ContentType属性,设置为application/vnd.ms-excel,将文本数据以microsoft excel的格式输出(Response)到客户端。
如,导出DataGrid:
//要导出的DataGrid控件
protected void Button2_Click(object sender, EventArgs e)
{
//要导出的控件
System.Web.UI.Control ctl = this.Label1;
//输出属性
HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=Excel.xls");
HttpContext.Current.Response.Charset = "UTF-8";
HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.Default;
HttpContext.Current.Response.ContentType = "application/ms-excel";
//输出空间内容到HtmlTextWriter
ctl.Page.EnableViewState = false;
System.IO.StringWriter tw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);
ctl.RenderControl(hw);
//输出HtmlTextWriter
HttpContext.Current.Response.Write(tw.ToString());
HttpContext.Current.Response.End();
}
使用这种方法,可以将大部分控件的数据都导入到Excel文件中。如Literal、GridView、Repeater、Label,只要这些控件中的数据是格式良好的表格,导出的Excel格式也是以表格数据形式展现。
将上边的代码直接写入到Page_Load中,可以将整个页面下载为Excel文件.
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Response.Clear();
Response.Buffer = true;
Response.AppendHeader("Content-Disposition", "attachment;filename=" + DateTime.Now.ToString("yyyyMMdd") + ".xls");
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.ContentType = "application/vnd.ms-excel";
this.EnableViewState = false;
}
}