Export DataGrid to Excel

Most of the applications which are being developed now require data to be exported to various formats. With ASP.Net this has become quite simple

private void Export2Excel(DataGrid grd)
{
     Response.Clear();
     Response.Buffer = true;
     Response.ContentType = "application/vnd.ms-Excel";
     Response.Charset = "";
     EnableViewState = false;
     System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
     System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);

     // Convert the controls to string literals
     ClearControls(grd);
     grd.RenderControl(oHtmlTextWriter);

     Response.Write(oStringWriter.ToString());
     Response.End();
}

private void ClearControls(Control Ctrl)
{
     for (int i= Ctrl.Controls.Count - 1; i >= 0; i--)
     {
          ClearControls(Ctrl.Controls[i]);
     }

     if (!(Ctrl is TableCell))
     {
          if (Ctrl.GetType().GetProperty("SelectedItem") != null)
          {
               LiteralControl Lt = new LiteralControl();
               Ctrl.Parent.Controls.Add(Lt);
               try
               {
                    Lt.Text = (string)Ctrl.GetType().GetProperty("SelectedItem").GetValue(Ctrl, null);
               }
               catch {}

               Ctrl.Parent.Controls.Remove(Ctrl);
          }
          else if (Ctrl.GetType().GetProperty("Text") != null)
          {
               LiteralControl Lt = new LiteralControl();
               Ctrl.Parent.Controls.Add(Lt);
               Lt.Text = (string)Ctrl.GetType().GetProperty("Text").GetValue(Ctrl, null);

               Ctrl.Parent.Controls.Remove(Ctrl);
          }
     }
     return;
}

Hope this post helped you. Please feel free to post your comments.