ansaurus

Question

Why does my Excel export have a blank row at the top?

Answer 1

A:

Here is my code that works fine:

protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                BindData();
            }
        }

        private void BindData()
        {
            string connectionString = "Server=localhost;Database=Northwind;Trusted_Connection=true";
            SqlConnection myConnection = new SqlConnection(connectionString);
            SqlDataAdapter ad = new SqlDataAdapter("select * from products", myConnection);
            DataSet ds = new DataSet();
            ad.Fill(ds);

            gvProducts.DataSource = ds;
            gvProducts.DataBind(); 
        }

        protected void ExportGridView(object sender, EventArgs e)
        {
            Response.ClearContent();

            Response.AddHeader("content-disposition", "attachment; filename=MyExcelFile.xls");

            Response.ContentType = "application/excel";

            StringWriter sw = new StringWriter();

            HtmlTextWriter htw = new HtmlTextWriter(sw);

            gvProducts.RenderControl(htw);

            Response.Write(sw.ToString());

            Response.End();
        }

        public override void VerifyRenderingInServerForm(Control control)
        {

        }

azamsharp 2008-10-02 23:43:46

Answer 2

+1 A:

@azamsharp - I found the solution elsewhere while you were replying. :-) It turns out that removing the form tag entirely from the ASPX page is the trick, and the only way to do this is to override the VerifyRenderingInServerForm method as you are doing.

If you update your solution to include the fact that you need to remove the form tag from the page, I will accept your answer. Thanks.

jeremcc 2008-10-02 23:53:18

I just removed the form tag and it resulted in the error. You can export using the form tag if you add this line to the page directive: EnableEventValidation="false"

azamsharp 2008-10-02 23:58:45

Answer 3

+1 A:

An easier solution is to override the Render (HtmlTextWriter writer) method and make it empty:

protected override void Render(HtmlTextWriter writer){}

http://c-sharpe.blogspot.com/2009/05/get-rid-of-blank-row-when-exporting-to.html

Eric 2009-05-08 20:16:06

ansaurus

tags:

views:

answers:

Why does my Excel export have a blank row at the top?

related questions