追寻我心

记录点点滴滴,追随自我风格!
  博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

ASP.NET GridView数据导出Excel

Posted on 2011-11-03 19:51  追寻我心  阅读(196)  评论(0)    收藏  举报
 #region 导出

public void ExportExcute(GridView gv)
{
if (gv.Rows.Count > 0)
{
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=DMReport" + DateTime.Now.ToString("_yyyyMMdd_HHmmss") + ".xls");
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.ContentType = "application/excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
gv.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
else
{
Tools.Alert(Page, "没有数据!");
}
}
public override void VerifyRenderingInServerForm(Control control)
{ }
#endregion