Export two gridview in one excel? In Asp.net?
<p>In web application, i am exporting one gridive it is working fine, now i want two gridviews in single excel sheet. This is my code :</p>

<pre><code>          Response.Clear();
                        Response.Write("&lt;center&gt;&lt;font size=4 color='red'&gt;&lt;U&gt;&lt;em&gt;&lt;b&gt;Trip Sheet Report&lt;/b&gt;&lt;/em&gt; &lt;/U&gt;&lt;/font&gt;&lt;/center&gt;");
                        Response.AddHeader("content-disposition", "attachment;filename=FileName.xls");
                        Response.Charset = "";
                        Response.ContentType = "application/vnd.xls";
                        System.IO.StringWriter stringWrite = new System.IO.StringWriter();
                        System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
                        grdTripSheet.RenderControl(htmlWrite);
                        Response.Write(stringWrite.ToString());
                        Response.End();
</code></pre>

<p>The above code for one gridivew can i export two gridview at a time. Thank you.</p>
