protected void btnExcel_Click(object sender, EventArgs e)
{
Response.Clear();
Response.AddHeader("content-disposition",
"attachment;filename=FileName.xls");
Response.ContentType = "application/vnd.xls";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite =
new HtmlTextWriter(stringWrite);
gvDB.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
}
本文介绍了一个使用ASP.NET将GridView中的数据导出为Excel文件的方法。通过设置HTTP响应头及内容类型,利用StringWriter和HtmlTextWriter将GridView渲染为HTML表格,并最终输出为Excel文件。
2981

被折叠的 条评论
为什么被折叠?



