西夏普的部落格

1.前言
ASP.NET網頁設計GridView報表輸出為Excel格式的檔案。

2.說明
在Button(Name=btExport)的Click事件中輸入Excel檔案名稱FileName.xls。

protected void btExport_Click(object sender, EventArgs e)
{
	Response.Clear();
	Response.AddHeader("content-disposition", "attachment;filename=FileName.xls");
	Response.Charset = "utf8";
	Response.ContentType = "application/vnd.xls";
	StringWriter StringWriter = new System.IO.StringWriter();
	HtmlTextWriter HtmlTextWriter = new HtmlTextWriter(StringWriter);
	GridView1.RenderControl(HtmlTextWriter);
	Response.Write(StringWriter.ToString());
	Response.End();
}