/// <summary> /// Export To Excel /// </summary> public static void Export(string fileName, GridView gv) { HttpContext.Current.Response.Clear(); HttpContext.Current.Response.AddHeader( "content-disposition", string.Format(CultureInfo.CurrentCulture, "attachment; filename={0}", fileName)); HttpContext.Current.Response.ContentType = "application/ms-excel"; using (StringWriter sw = new StringWriter(CultureInfo.CurrentCulture)) { using (HtmlTextWriter htw = new HtmlTextWriter(sw)) { Table table = new Table(); table.GridLines = gv.GridLines; if (gv.HeaderRow != null) { GridViewExportUtility.PrepareControlForExport(gv.HeaderRow); table.Rows.Add(gv.HeaderRow); } foreach (GridViewRow row in gv.Rows) { GridViewExportUtility.PrepareControlForExport(row); table.Rows.Add(row); } if (gv.FooterRow != null) { GridViewExportUtility.PrepareControlForExport(gv.FooterRow); table.Rows.Add(gv.FooterRow); } table.RenderControl(htw); HttpContext.Current.Response.Write(sw.ToString()); HttpContext.Current.Response.End(); } } } /// <summary> /// Replace any of the contained controls with literals /// </summary> private static void PrepareControlForExport(Control control) { for (int i = 0; i < control.Controls.Count; i++) { Control current = control.Controls[i]; if (current is LinkButton) { control.Controls.Remove(current); control.Controls.AddAt(i, new LiteralControl((current as LinkButton).Text)); } else if (current is Image) { control.Controls.Remove(current); } else if (current is ImageButton) { control.Controls.Remove(current); control.Controls.AddAt(i, new LiteralControl((current as ImageButton).AlternateText)); } else if (current is HyperLink) { control.Controls.Remove(current); control.Controls.AddAt(i, new LiteralControl((current as HyperLink).Text)); } else if (current is DropDownList) { control.Controls.Remove(current); control.Controls.AddAt(i, new LiteralControl((current as DropDownList).SelectedItem.Text)); } else if (current is CheckBox) { control.Controls.Remove(current); } if (current.HasControls()) { GridViewExportUtility.PrepareControlForExport(current); } } }
"'" + (123456).ToString()
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)