Response.Clear();

Response.Buffer= true;

Response.ContentType = "application/vnd.ms-excel";

Response.AddHeader("Content-Disposition", "attachment;filename=ReviewDesignation.xls");//This
lets you always open the Excel window when exporting whether you click on open
or save.

Response.Charset = "";

this.EnableViewState = false;

System.IO.StringWriter oStringWriter = new
System.IO.StringWriter();System.Web.UI.HtmlTextWriter oHtmlTextWriter =

new System.Web.UI.HtmlTextWriter(oStringWriter);

this.ClearControls(dGrid);

dGrid.RenderControl(oHtmlTextWriter);

Response.Write(oStringWriter.ToString());

Response.End();