导出Excel

最新推荐文章于 2024-12-19 15:40:20 发布

weixin_34352449

最新推荐文章于 2024-12-19 15:40:20 发布

阅读量69

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/RobotTech/archive/2007/03/02/661773.html

本文介绍了一种使用ASP.NET将数据导出为Excel文件的方法。通过设置HTTP响应头、编码及内容类型等，实现将Web页面内容以Excel格式下载。文中还展示了如何禁用视图状态并使用StringWriter与HtmlTextWriter来渲染页面内容。

Response.Clear();
   Response.Buffer = true;
   Response.Charset = "gb2312";
   Response.AppendHeader("Content-Disposition", "attachment;filename=" + Server.UrlEncode("中文名称") + ".xls");
   //Response.ContentEncoding = System.Text.Encoding.Default;

Response.ContentType = "application/ms-excel";

this.EnableViewState = false;

System.IO.StringWriter oStringWriter = new StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new HtmlTextWriter(oStringWriter);

   this.RenderControl(oHtmlTextWriter);
   Response.Write(oStringWriter.ToString());
   Response.End();

转载于:https://www.cnblogs.com/RobotTech/archive/2007/03/02/661773.html