protected void ExportExcel() { Response.Clear(); Response.Buffer = true; Response.ContentType = "application/vnd.ms-excel"; Response.AddHeader("content-disposition", "attachment;filename=" + ddlplanner.SelectedItem.Text.Replace(" ", "_") + "_Activities_" + DateTime.Now.ToString("yyyy-dd-M--HH-mm-ss").Replace("-", "_") + ".xls"); Response.Charset = ""; this.EnableViewState = false; System.IO.StringWriter sw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(sw); GridViewLMS_excel.RenderControl(htw); Response.Write(sw.ToString()); Response.End(); }