How do I export 2 gridviews into 2 seperated sheets in 1 ms-excel file?

See more:

C#

ASP.NET

MS-Excel

Gridview

Hi members,

How do I export 2 gridviews (GridView1 & GridView2) into 2 seperated sheets in 1 ms-excel file? Currently, I'm able to export only 1 gridview to an excelsheet which the filename is the same as the sheet name. But I would like to 2 gridviews into 2 seperated sheets which I would like sheet name to be define/set by myself. thanks.

    public void ExportGridToExcel()
{
    Response.Clear();
    Response.Buffer = true;
    Response.ClearContent();
    Response.ClearHeaders();
    Response.Charset = "";
    string FileName ="Export"+DateTime.Now+".xls";
    StringWriter strwritter = new StringWriter();
    HtmlTextWriter htmltextwrtter = new HtmlTextWriter(strwritter);
    Response.Cache.SetCacheability(HttpCacheability.NoCache);
    Response.ContentType = "application/vnd.ms-excel";
    Response.AddHeader("Content-Disposition","attachment;filename=" + FileName);
    GridView1.GridLines = GridLines.Both;
    GridView1.HeaderStyle.Font.Bold = true;
    GridView1.RenderControl(htmltextwrtter);
    Response.Write(strwritter.ToString());
    Response.End();
}

    public override void VerifyRenderingInServerForm(Control control)
    {
        return;
    }