add title when exporting grid to excel
<p>I use the following code to export a datatable to excel</p>

<p>Is there a way to add a title to the excel sheet??</p>

<p>Here is the code I use to generate the excel sheet.</p>

<pre><code>enter code here
    public void export2(DataTable dt)
    {
        System.Web.UI.WebControls.DataGrid grid = 
                           new System.Web.UI.WebControls.DataGrid();
        grid.HeaderStyle.Font.Bold = true;
        grid.DataSource = dt;
        grid.DataBind();
        using (StreamWriter sw = new StreamWriter("C:\\Reports\\Report.xls"))
        {
            using (HtmlTextWriter hw = new HtmlTextWriter(sw))
            {
                grid.RenderControl(hw);
            }
        }
    }
</code></pre>

<p>The output from this looks like this</p>

<pre><code>Name    Employee ID 
abc         123 
def         456
ghi         789 
jkl         987
mno         654
</code></pre>

<p>is it possible to get the output as shown below??</p>

<pre><code>Employee Report

Name    Employee ID 
abc         123 
def         456
ghi         789 
jkl         987
mno         654
</code></pre>

<p>Thanks in advance!!</p>
