title: Add Title before Export Excel
body: <p>Am using the Following Function for Export the Excel File.It Was working Fine.I retrieve the Records from SQL DataBase to data table and I Export the Excel Sheet.</p>
  
  <pre><code>        public ActionResult ExporttoExcel()
          {
              DataTable dt = new DataTable();
              SqlConnection con = new SqlConnection("Connection string here");
              con.Open();
              SqlCommand cmd = new SqlCommand("select * from Exportxcel", con);
              dt.Load(cmd.ExecuteReader());
              int total = 0;
              foreach (DataRow row in dt.Rows)
              {
                  int salaryvalue = Convert.ToInt32(row["Salary"]);
                  total = salaryvalue + total;
              }
              dt.Rows.Add(new object[] { "", "Total", total });
  
  
              if (dt.Rows.Count &gt; 0)
              {
                  string filename = "ExcelExport.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 + "");
                  Response.Write(tw.ToString());
                  Response.End();
              }
               return View(dt);
          }
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/xSNXL.png" alt="enter image description here"></p>
  
  <p>My question is I need to add Two title before the Value Bind?How to do this?I need to add Title ,author like the following Screen Shot.How to do this?</p>
  
  <p><img src="https://i.stack.imgur.com/ie7MS.png" alt="enter image description here"></p>