将DataGrid数据导出到Word文档
private void ExportToWord_Click(object sender, System.EventArgs e)
{
Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename=FileName.doc");
Response.Charset = "";
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = "application/vnd.word";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
dgDevice.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
}
将DataGrid数据导出到Excel文档
private void ExportToExcel_Click(object sender, System.EventArgs e)
{
Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename=FileName.xls");
Response.Charset = "";
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = "application/vnd.xls";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
dgDevice.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
}
本文内容参考以下出处:
http://www.codeproject.com/KB/webforms/DAtaGridExportToExcel.aspx