title: export multiple gridviews to excel clientside.
body: <p>I want to export data from my webpage using and export button. the data is displayed in 3 different gridviews that i want separated onto 3 different worksheets "top 1, top 2, top3" i want to do this clientside im using c# and asp.net.. how can i do this? could i use java script? </p>
  
  <p>here is my code</p>
  
  <pre><code>using System;
  using System.Configuration;
  using System.Linq;
  using System.Web;
  using System.Web.Security;
  using System.Web.UI;
  using System.Web.UI.HtmlControls;
  using System.Web.UI.WebControls;
  using System.Web.UI.WebControls.WebParts;
  using System.Xml.Linq;
  using System.Data;
  using System.Data.SqlClient;
  using System.Collections;
  using System.Text;
  using System.IO;
  using Excel = Microsoft.Office.Interop.Excel;
  using System.Reflection;
  
  
  
  public partial class _Default : System.Web.UI.Page
  {
  protected void Page_Load(object sender, EventArgs e)
  {
      DataSet dataSet = new DataSet();
  
      SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ISALog1ConnectionString"].ToString());
  
      SqlCommand cmd = new SqlCommand("exec ProxyReport", conn);
      cmd.CommandTimeout = 200;
  
      SqlDataAdapter ad = new SqlDataAdapter(cmd);
      ad.Fill(dataSet);
  
      GridView1.DataSource = dataSet.Tables[0];
      GridView1.DataBind();
      GridView2.DataSource = dataSet.Tables[1];
      GridView2.DataBind();
      GridView3.DataSource = dataSet.Tables[2];
      GridView3.DataBind();
  
  }
  protected void Button1_Click(object sender, EventArgs e)
  {
      string attachment = "attachment; filename=Top 1.xls";
      Response.ClearContent();
      Response.AddHeader("content-disposition", attachment);
      Response.Cache.SetCacheability(HttpCacheability.NoCache);
      Response.ContentType = "application/ms-excel";
      StringWriter sw = new StringWriter();
      HtmlTextWriter htw = new HtmlTextWriter(sw);
      GridView1.RenderControl(htw);
      GridView2.RenderControl(htw);
      GridView3.RenderControl(htw);
      Response.Write(sw.ToString());
      Response.End();
  }
  protected void GetExcel(object sender, EventArgs e)
  {
      //3 gridviews each in 3 different worksheets
  }
  
  public override void VerifyRenderingInServerForm(Control control)
  {
  
  }
  
  
  }
  </code></pre>