ASP.ENT c# 将数据导出为Excel

最新推荐文章于 2024-07-09 17:19:46 发布

dataadapters

最新推荐文章于 2024-07-09 17:19:46 发布

阅读量695

点赞数

分类专栏： asp.net C# 文章标签： c# string excel

本文链接：https://blog.csdn.net/dataadapters/article/details/7245739

版权

asp.net 同时被 2 个专栏收录

7 篇文章 0 订阅

订阅专栏

7 篇文章 0 订阅

订阅专栏

public void ToExcel(DataTable dt,HttpContext content)
        {
            string filename = DateTime.Now.ToString("yyyyMMddHHmmss");
            content.Response.Clear();
            string fileName = System.Web.HttpUtility.UrlEncode(System.Text.Encoding.UTF8.GetBytes(filename));
            content.Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName + ".xls");
            content.Response.ContentType = "applicationnd.ms-excel";
            content.Response.Charset = "utf-8";
            StringBuilder s = new StringBuilder();
            s.Append("<HTML><HEAD><TITLE>" + fileName + "</TITLE><META http-equiv=\"Content-Type\" content=\"textml; charset=utf-8\"></head><body>");

            System.IO.StringWriter sw = new System.IO.StringWriter();
            System.Web.UI.HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(sw);
            System.Web.UI.WebControls.GridView dg = new System.Web.UI.WebControls.GridView();

            dg.DataSource = dt;
            dg.DataBind();
            dg.RenderControl(htw);
            content.Response.Write(sw.ToString());
            content.Response.End();
        }

dataadapters

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
ASP.ENT c# 将数据导出为Excel

public void ToExcel(DataTable dt,HttpContext content) { string filename = DateTime.Now.ToString("yyyyMMddHHmmss"); content.Response.Clear(); string fileName
复制链接

扫一扫