Gridview to Excel

Question

I have a gridview with AutoGenerateDeleteButton

And i export this gridview simple this code..

Response.Clear();
        Response.AddHeader("content-disposition", "attachment;filename=Avukat.xls");
        Response.Charset = "";

        Response.ContentType = "application/vnd.xls";
        System.IO.StringWriter stringWrite = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
        GridView1.RenderControl(htmlWrite);
        Response.Write("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" />");
        Response.Write(stringWrite.ToString());
        Response.End();

There is no problem with that.

But in the excel there is a delete column :))

How can i delete the delete column in excel?

Answer 1

Your problem is you want 2 x "views" of your grid. With & without the delete column.

One for the browser, and one for Excel.

On your export, drop the delete column. Something something like:

    GridView1.AutoGenerateDeleteButton = false;
    GridView1.DataBind(); 
    GridView1.RenderControl(htmlWrite);
    Response.Write("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" />");

Answer 2

You need to remove the column from the GridView before exporting it.