title: Exporting datasets into multiple excel sheets of one excel file
body: <p>I need to export two dataset's values in two excel sheets of the same workbook.
  My Query is like:</p>
  
  <p>//Dataset One:</p>
  
  <pre><code>        DataSet ds1 = new DataSet();
          SqlCommand commandOpen = new SqlCommand("storedproc1", conSql);
          commandOpen.CommandType = CommandType.StoredProcedure;
          var adaptOpen = new SqlDataAdapter();
          adaptOpen.SelectCommand = commandOpen;
          adaptOpen.Fill(ds1, "table");
  </code></pre>
  
  <p>//Dataset Two:</p>
  
  <pre><code>        DataSet ds2 = new DataSet();
          SqlCommand commandOpen = new SqlCommand("storedproc2", conSql);
          commandOpen.CommandType = CommandType.StoredProcedure;
          var adaptOpen = new SqlDataAdapter();
          adaptOpen.SelectCommand = commandOpen;
          adaptOpen.Fill(ds2, "table");
  </code></pre>
  
  <p>Now to create one Excel workbook I have used:</p>
  
  <pre><code>        ExcelLibrary.DataSetHelper.CreateWorkbook("C:/New Folder/file1.xls", ds1);
  </code></pre>
  
  <p>But instead of this, in the same workbook I want to add two sheets; one for ds1 and another for ds2. How to do that?
  Thanks.</p>