Exporting grid to excel
<p>I used this code for exploring grid to excel.I got this code from net.</p>

<pre><code>protected void Button1_Click(object sender, EventArgs e)
{
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=GridViewExport.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
GridView1.AllowPaging = false;
GridView1.DataBind();
GridView1.RenderControl(hw);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
</code></pre>

<p>When I am using this code,grid data get display in excel,but that does not have vertical and horizontal lines.It shows gridview column name as link not normal text.I have not used any theme to gridview and columns are autogenerated.One column say col3 contain more description so it's data get displayed at top when second row start,still it's discription shown in cell2.So I wanted to add vertical and horizontal lines,in that.So it is easy to come to know which data of belong to which id.I want to format col 1 also which is of number format only and decimal places zero.</p>

<pre><code> 1 col1    col2              col3
                                     hjhhjhjhjhjhjhjhjhjhjbbv
                                     gfgfgfuiuiuiuiui
    2 9.12E+11   gkjj                etwtrtrwqtrtttwwtretqwfe
                                     dear member
                                      gffgf

    3 565E+11 hghgh
</code></pre>
