• .net中从GridView中导出数据到excel(详细)


    1,创建数据源 找到要导出的GridView中的数据。

    2,重写VerifyRenderingInServerForm方法。

       public override void VerifyRenderingInServerForm(Control control)
     {

        }

    3,编写导到Excel的方法。

    private void ExportGridView()
            {
                /**
                 * 如果打印全部数据,则加上注视的代码
                 * */
                //GVExport.AllowPaging = false;
                //GVExport.AllowSorting = false;
                //GVExport.DataSource = null;
                //GVExport.DataBind();
                DateTime dt = DateTime.Now;
                Response.ClearContent();
                Response.Buffer = true;
                Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");
                string filename = "XX_" + dt.ToString("yyyyMMddHHmm") + ".xls";
                string[] browsers = { "Firefox", "AppleMAC-Safari", "Opera" }; //针对FF、Safari、Opera 设置编码
                string browser = Request.Browser.Browser;
                string attachment = string.Empty;
                if (Array.IndexOf<string>(browsers, browser) != -1)
                {
                    attachment = "attachment; filename=" + filename;
                }
                else
                {
                    attachment = "attachment; filename=" + Server.UrlEncode(filename);
                }
                Response.AddHeader("content-disposition", attachment);
                Response.Write("<meta http-equiv=Content-Type content=text/html;charset=utf-8>");
                Response.ContentType = "application/ms-excel";
                StringWriter sw = new StringWriter();
                HtmlTextWriter htw = new HtmlTextWriter(sw);
                GVExport.RenderControl(htw);

                Response.Output.Write(sw.ToString());
                Response.Flush();
                Response.End();
            }

  • 相关阅读:
    Golang 用go-sql-driver 调用MySQL存储过程时的问题排查
    mysqlbinlog 查看binlog时报错unknown variable 'default-character-set=utf8'
    HBase Go客户端Row构造注意事项
    MySQL JOIN操作报错问题小解
    MySQL主从同步的一个小问题解决
    PHP 多个mysql连接的问题
    记一起动态库加载错误问题排查过程
    DNS缓存
    C输出大于127的ACSII字符
    Mint17 一些安装备忘
  • 原文地址:https://www.cnblogs.com/lintao0823/p/3318568.html
Copyright © 2020-2023  润新知