Error in Exporting Data in Gridview to Excel Sheet

[umamahesh2020]

I getting an error that one when click on the Export Button in the show shows the data of GridView Along with PageIndexing NUmbers also

protected void btnexcel_Click(object sender, EventArgs e)
    {       
        Response.Clear();
        Response.AddHeader("content-disposition", "attachment;filename=Emp.xls");
        Response.ContentType = "application/vnd.ms-excel";
        StringWriter sw = new StringWriter();
        HtmlTextWriter htw = new HtmlTextWriter(sw);
        GridView1.RenderControl(htw);
        Response.Write(sw.ToString());
        Response.End();
    }

[rohand]

Can you please let us know what the error is coming up when you are exporting data to excel file ?

I getting an error that one when click on the Export Button in the show shows the data of GridView Along with PageIndexing NUmbers also

protected void btnexcel_Click(object sender, EventArgs e)
    {       
        Response.Clear();
        Response.AddHeader("content-disposition", "attachment;filename=Emp.xls");
        Response.ContentType = "application/vnd.ms-excel";
        StringWriter sw = new StringWriter();
        HtmlTextWriter htw = new HtmlTextWriter(sw);
        GridView1.RenderControl(htw);
        Response.Write(sw.ToString());
        Response.End();
    }

[umamahesh2020]

In the ExcelSheet i am Getting Pagenumbers along with the Data.