导出功能

最新推荐文章于 2024-11-15 23:34:41 发布

songjg2010

最新推荐文章于 2024-11-15 23:34:41 发布

阅读量147

点赞数

分类专栏：导入excel 文章标签： c#

本文链接：https://blog.csdn.net/songjg2010/article/details/84623292

版权

导入excel 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

本文介绍了使用ASP.NET进行Excel文件导出的方法，包括设置HTTP响应头、字符集及编码方式，利用StringWriter与HtmlTextWriter将指定控件的内容转换为HTML格式并下载为Excel文件。

摘要由CSDN通过智能技术生成

    protected void excelout_Click(object sender, EventArgs e)
    {
        reloadBtn_Click(sender, e);
        System.Web.UI.Control ctl = this.TablePanel;
        //DataGrid1是你在窗体中拖放的控件
        HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + System.Web.HttpUtility.UrlEncode("国" + Year + "年" + titleMonth + "份计划", System.Text.Encoding.UTF8) + ".xls");
        HttpContext.Current.Response.Charset = "UTF-8";
        HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.Default;
        HttpContext.Current.Response.ContentType = "application/ms-excel";
        System.IO.StringWriter tw = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);
        ctl.RenderControl(hw);
        HttpContext.Current.Response.Write(tw.ToString());
        HttpContext.Current.Response.End();

    }

protected void btnExportExcel_Click(object sender, EventArgs e)
    {
        if (GridViewListTemplet.Rows.Count == 0)
        {
            ScriptManager.RegisterClientScriptBlock(this.Page, GetType(), "noneData", "alert(\"没有数据！\");", true);
            return;
        }
        //Catch缓存给权限
        HttpContext.Current.Response.ClearHeaders();
        HttpContext.Current.Response.AppendHeader("Expires ", System.DateTime.Now.AddMinutes(30).ToString());
        HttpContext.Current.Response.AppendHeader("Pragma ", "public ");
        HttpContext.Current.Response.AppendHeader("Cache-Control ", "must-revalidate,   post-check=0,   pre-check=0 ");
        HttpContext.Current.Response.AppendHeader("Cache-Control ", "public "); 

        GridViewListTemplet.AllowPaging = false;
        GridViewListTemplet.AllowSorting = false;
        GridViewListTemplet.DataBind();
        bindData();
        if (GridViewListTemplet.HeaderRow.FindControl("ckbAll") != null)//有复选框时
        {
            GridViewListTemplet.Columns[0].Visible = false;
        }
        HttpContext.Current.Response.Charset = "UTF-8"; 
        HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF7;
        HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=export"+DateTime.Now.Ticks.ToString()+".xls");
        HttpContext.Current.Response.ContentType = "application/ms-excel";
        GridViewListTemplet.Page.EnableViewState = true;// false;
        System.IO.StringWriter tw = new System.IO.StringWriter();
        HtmlTextWriter hw = new HtmlTextWriter(tw);
        GridViewListTemplet.RenderControl(hw);

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

        GridViewListTemplet.AllowPaging = true;
        GridViewListTemplet.AllowSorting = true;
        GridViewListTemplet.DataBind();
        if (GridViewListTemplet.HeaderRow.FindControl("ckbAll") != null)//有复选框时
        {
            GridViewListTemplet.Columns[0].Visible = true;
        }
    }
    #endregion