导出html页面 EXCEL

最新推荐文章于 2025-03-03 10:49:30 发布

转载最新推荐文章于 2025-03-03 10:49:30 发布 · 114 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/mingfeng/archive/2011/03/07/1975248.html

文章标签：

#ui

本文介绍了一种将HTML页面内容导出为Excel文件的方法。通过设置HTTP响应头及使用.NET平台提供的工具类，可以实现在Web应用中直接将当前页面内容转换并下载为.xls格式的Excel文件。

//导出html页面
        public void OutPutExcel(string title)
        {
            Response.Clear();
            Response.Buffer = true;
            Response.Charset = "utf-8";

Response.AddHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(title + ".xls"));
Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");

Response.ContentType = "application/ms-excel";
Page.EnableViewState = false;

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

this.Page.RenderControl(oHtmlTextWriter);

            string temp = oStringWriter.ToString();

            Response.Write(temp);//写入excel
            Response.End();
        }

转载于:https://www.cnblogs.com/mingfeng/archive/2011/03/07/1975248.html