Response.ClearContent(); string filename = "FY15 Input Collection Template_" + ddlcity.SelectedItem.Text + ".xls"; Response.AddHeader("content-disposition", "attachment;filename=" + filename); Response.Charset = "UTF-8"; Response.ContentType = "application/vnd.ms-excel"; StringWriter tw = new StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(tw); Microsoft.Office.Interop.Excel.ApplicationClass _ExcelApp = new Microsoft.Office.Interop.Excel.ApplicationClass(); _ExcelApp.DisplayAlerts = false; tbcity.RenderControl(hw); tbannualpercent.RenderControl(hw); tblasm.RenderControl(hw); tbtwotable.RenderControl(hw); tbsectb.RenderControl(hw); tbthreetb.RenderControl(hw); tbthirdtb.RenderControl(hw); this.EnableViewState = false; Response.Write(tw.ToString()); Response.Flush(); Response.End();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)