GridView Export Excel and set display column visible status

最新推荐文章于 2025-08-13 15:20:13 发布

原创最新推荐文章于 2025-08-13 15:20:13 发布 · 473 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#excel #string #object

ASP.NET 专栏收录该内容

14 篇文章

订阅专栏

本文介绍了一种使用ASP.NET将GridView数据导出到Excel文件的方法。通过调整GridView的显示属性，并利用StringWriter和HtmlTextWriter类，可以实现将网格视图内容转换为适合Excel的HTML格式。此外，还提供了一个用于预处理GridView以确保所有数据都能正确导出的函数。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

using System.Text;
using System.IO;

protected void lbnExport_Click(object sender, EventArgs e)
    {


        PrepareGridViewForExport(gridViewReport);

        ExportGridView();
    }

    /// <summary>
    ///
    /// </summary>
    private void ExportGridView()
    {

        string attachment = "attachment; filename=Report.xls";

        Response.ClearContent();

        Response.AddHeader("content-disposition", attachment);

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

        StringWriter sw = new StringWriter();

        HtmlTextWriter htw = new HtmlTextWriter(sw);

        GridView formatGridView = gridViewReport;
        formatGridView.Columns[5].Visible = true;
        formatGridView.Columns[6].Visible = true;
        formatGridView.Columns[9].Visible = true;
        formatGridView.Columns[11].Visible = true;
        formatGridView.Columns[12].Visible = true;
        formatGridView.RenderControl(htw);

        //gridViewReport.RenderControl(htw);

        Response.Write(sw.ToString());

        Response.End();

    }

    public override void VerifyRenderingInServerForm(Control control)
    {

    }

    private void PrepareGridViewForExport(Control gv)
    {

        LinkButton lb = new LinkButton();

        Literal l = new Literal();

        string name = String.Empty;

        for (int i = 0; i < gv.Controls.Count; i++)
        {

            if (gv.Controls[i].GetType() == typeof(LinkButton))
            {

                l.Text = (gv.Controls[i] as LinkButton).Text;

                gv.Controls.Remove(gv.Controls[i]);

                gv.Controls.AddAt(i, l);

            }

            else if (gv.Controls[i].GetType() == typeof(DropDownList))
            {

                l.Text = (gv.Controls[i] as DropDownList).SelectedItem.Text;

                gv.Controls.Remove(gv.Controls[i]);

                gv.Controls.AddAt(i, l);

            }

            else if (gv.Controls[i].GetType() == typeof(CheckBox))
            {

                l.Text = (gv.Controls[i] as CheckBox).Checked ? "True" : "False";

                gv.Controls.Remove(gv.Controls[i]);

                gv.Controls.AddAt(i, l);

            }

            if (gv.Controls[i].HasControls())
            {

                PrepareGridViewForExport(gv.Controls[i]);

            }

        }

    }