Exports gridview and prints it in excel

try this one, though I didn't test this on printing the exported XLS

protected void ExportToXls_Click(object sender, EventArgs e) //On click Event of a control (button/link button/hyperlink)
 {

        this.DataGridView1.AllowPaging = false;

        ExportGridViewToExcel(Response, this.DataGridView1, "Exported.xls");
 }

 public void ExportGridViewToExcel(HttpResponse response, GridView gvControl, string fileName)
        {
            string attachment = "";
            System.IO.StringWriter sw = new System.IO.StringWriter();
            HtmlTextWriter htw = new HtmlTextWriter(sw);
            response.AddHeader("content-disposition", "attachment; filename=" + fileName);
            response.ClearContent();
            response.AddHeader("content-disposition", attachment);
            gvControl.AllowPaging = false;
            gvControl.DataBind();
            gvControl.RenderControl(htw);
            response.Write(sw.ToString());
            response.Flush();
            response.End();

            gvControl.AllowPaging = true;
        }

 public override void VerifyRenderingInServerForm(Control control) // I just got this in forum just
           // add this. I don't why but it will work if this is added
        {
        }