xargon
October 14th, 2003, 07:37 AM
Hi everyone,
I have a weird problem when I try to export a datagrid to excel. It works when I save it, but if I choose the option of Open from the site, it displays the contents of some labels of the page! If someone has any idea of what is wrong, or has experienced something similar...please let me know.
Here is the code:
private void exportButton_Click(object sender, System.EventArgs e)
{
Response.Clear();
Response.Buffer= true;
Response.ContentType = "application/vnd.ms-excel";
Response.Charset = "";
this.EnableViewState = false;
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
resultGrid.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();
}
Thanks a lot,
Xargon
I have a weird problem when I try to export a datagrid to excel. It works when I save it, but if I choose the option of Open from the site, it displays the contents of some labels of the page! If someone has any idea of what is wrong, or has experienced something similar...please let me know.
Here is the code:
private void exportButton_Click(object sender, System.EventArgs e)
{
Response.Clear();
Response.Buffer= true;
Response.ContentType = "application/vnd.ms-excel";
Response.Charset = "";
this.EnableViewState = false;
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
resultGrid.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();
}
Thanks a lot,
Xargon