Export DataGrid to Excel in C#

Code For Export Data From DataGrid to Excel Sheet 

1. public static void ExportDataGridToExcel(DataGrid dgrdExport,Page pg)
2. {
3. try
4. {
5. pg.Response.Clear();
6. pg.Response.Buffer= true;
7. pg.Response.ContentType = "application/vnd.ms-excel";
8. pg.Response.Charset = "";
9. pg.EnableViewState = false;
10. System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
11. System.Web.UI.HtmlTextWriter oHtmlTextWriter = new                 System.Web.UI.HtmlTextWriter(oStringWriter);
12.               ClearControls(dgrdExport);
13. dgrdExport.RenderControl(oHtmlTextWriter);
14. pg.Response.Write(oStringWriter.ToString());
15. pg.Response.End();
16. }
17. catch(System.Exception ex)
18. {
19. throw ex;
20. }
21. 
    
22. }

1. private static void ClearControls(Control control)
2. {
3. for (int cnt=control.Controls.Count -1; cnt>=0; cnt--)
4. {
5. ClearControls(control.Controls[cnt]);
6. }
7. if (!(control is TableCell))
8. {
9. if (control.GetType().GetProperty("SelectedItem") != null)
10. {
11. LiteralControl literal = new LiteralControl();
12. control.Parent.Controls.Add(literal);
13. try
14. {
15. literal.Text = (string)control.GetType().GetProperty("SelectedItem").GetValue(control,null);
16. }
17. catch
18. {
20. }
21. control.Parent.Controls.Remove(control);
22. }
23. 
    
24. else
25. 
    
26. if (control.GetType().GetProperty("Text") != null)
27. {
28. LiteralControl literal = new LiteralControl();
29. control.Parent.Controls.Add(literal);
31. literal.Text = (string)control.GetType().GetProperty("Text").GetValue(control,null);
32. control.Parent.Controls.Remove(control);
33. }
34. }
35. return;
36. }