GridView Export Excel and set display column visible status

来源：互联网发布：mac侧边栏图标异常编辑：程序博客网时间：2024/05/22 06:37

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]);

            }

        }

    }