title: Export to excel from asp.net c# mvc
body: <p>I am trying to export the data table to the excel sheet in asp.net mvc. I tried the following code to export. It does't show any errors but it does't create the excel file also. So what is the problem in this code?</p>
  
  <pre><code>if (dt.Rows.Count &gt; 0)
                  {
                      string filename = "DownloadMobileNoExcel.xls";
                      System.IO.StringWriter tw = new System.IO.StringWriter();
                      System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);
                      DataGrid dgGrid = new DataGrid();
                      dgGrid.DataSource = dt;
                      dgGrid.DataBind();
  
                      dgGrid.RenderControl(hw);
                      Response.ContentType = "application/vnd.ms-excel";
                      Response.AppendHeader("Content-Disposition", "attachment; filename=" + filename + "");
  
                      this.EnableViewState = false;
                      Response.Write(tw.ToString());
                      Response.End();
                  }
  </code></pre>