将GridView导出到Excel代码,Asp.Net代码库,德仔网

代码语言

代码分类

【Asp.Net】将GridView导出到Excel

作者:scottckt/ / 发布于2010/12/30/ 1012

<div> /// <summary>
 /// GridView导出Excel
 /// </summary>
 /// <param name="pageLocal">要导出的页面</param>
 /// <param name="gvVal">要导出的GridView</param>
 /// <param name="sFileName">导出后的文件名</param>
 public static void ExcelExport(Page pageLocal, GridView gvVal, string sFileName)
 {
 string attachment = "attachment; filename=" + sFileName + ".xls";
 pageLocal.Response.ClearContent();
 pageLocal.Response.AddHeader("content-disposition", attachment);
 pageLocal.Response.ContentType = "application/ms-excel";
 StringWriter sw = new StringWriter();
 HtmlTextWriter htw = new HtmlTextWriter(sw);</div>
<div> // Create a form to contain the grid
 HtmlForm frm = new HtmlForm();
 gvVal.Parent.Controls.Add(frm);
 frm.Attributes["runat"] = "server";
 frm.Controls.Add(gvVal);
 frm.RenderControl(htw);</div>
<div> //GridView1.RenderControl(htw);
 pageLocal.Response.Write(sw.ToString());
 pageLocal.Response.End();
 }
<div></div>

试试其它关键字

　导出Excel　

同语言下

可能有用的

scottckt/贡献的其它代码(3)