I am trying to export gridview contents into Excel as given

JAYRAM

I am trying to export gridview contents into Excel as given below, Excel is created but there is no content. but I am able to view the content in the webpage.

Response.Clear();
Response.Buffer = true;
string filename = "GridViewExport_" + DateTime.Now.ToString() + ".xls";
Response.AddHeader("content-disposition",
"attachment;filename=" + filename);
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
gv.AllowPaging = false;
gv.DataBind();
gv.RenderControl(hw);
//style to format numbers to string
string style = @"";
Response.Write(style);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
public override void VerifyRenderingInServerForm(Control control)
{
//verifies that the control is rendered
}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

JAYRAM13y ago

error

RegisterForEventValidation can only be called during Render();

Dscription: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: RegisterForEventValidation can only be called during Render();

Source Error:

Line 100: StringWriter StringWriter = new System.IO.StringWriter(); Line 101: HtmlTextWriter HtmlTextWriter = new HtmlTextWriter(StringWriter); Line 102: gv.RenderControl(HtmlTextWriter); Line 103: Response.Write(StringWriter.ToString()); Line 104: Response.End();

JAYRAM13y ago
excel is created display only frontend....not display gridview records
Rishikesh Kumar Singh13y ago
Try this code, your problem will be solved ,

protected void btnExcel_Click(object sender, ImageClickEventArgs e)
{
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "Customers.xls"));
Response.ContentType = "application/ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
gvdetails.AllowPaging = false;
gvdetails.DataBind();
//Change the Header Row back to white color
gvdetails.HeaderRow.Style.Add("background-color", "#FFFFFF");
//Applying stlye to gridview header cells
for (int i = 0; i < gvdetails.HeaderRow.Cells.Count; i++)
{
gvdetails.HeaderRow.Cells[i].Style.Add("background-color", "#507CD1");
}

}

public override void VerifyRenderingInServerForm(Control control)
{
/* Verifies that the control is rendered */
}

If it helps you then mark it as an accepted answer otherwise let me know..!!

I am trying to export gridview contents into Excel as given

error RegisterForEventValidation can only be called during Render();

error

RegisterForEventValidation can only be called during Render();