导出excel到客户端

sheercony

于 2004-07-14 12:04:00 发布

阅读量994

点赞数

CC 4.0 BY-SA版权

分类专栏： ASP.NET 文章标签： excel string

本文链接：https://blog.youkuaiyun.com/sheercony/article/details/41235

ASP.NET 专栏收录该内容

15 篇文章

订阅专栏

博客给出了将System.Web.UI.WebControls.DataGrid数据导出到Excel的代码。设置了响应的字符集、编码和内容类型，通过StringWriter和HtmlTextWriter将DataGrid内容渲染并输出到Excel文件。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

  public static void gridToExcel(System.Web.UI.WebControls.DataGrid grid, string excelName)
  {
   HttpContext.Current.Response.Charset ="GB2312";
   HttpContext.Current.Response.ContentEncoding =   System.Text.Encoding.UTF8;
   HttpContext.Current.Response.ContentType = "application/ms-excel";
   HttpContext.Current.Response.AppendHeader("Content-Disposition","attachment;filename=" + excelName + ".xls");
   //HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");

   grid.Page.EnableViewState = false;
   System.IO.StringWriter tw = new System.IO.StringWriter();
   System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);
   grid.RenderControl(hw);

   HttpContext.Current.Response.Write(tw.ToString());
   HttpContext.Current.Response.End();
  }