title: How to save workbook without showing save dialog with Excel interop?
body: <p>I have to create a Console application that exports a <code>DataSet</code> to Excel. The problem is that it shouldn't pop up the save window, it should automatically create the Excel file. So far I have the following code, but I don't know how to make it save automatically. Would appreciate any help.</p>
  
  <pre><code>public static void CreateWorkbook(DataSet ds, String path)
  {
      int rowindex = 0;
      int columnindex = 0;
  
      Microsoft.Office.Interop.Excel.Application wapp = new Microsoft.Office.Interop.Excel.Application();
      Microsoft.Office.Interop.Excel.Worksheet wsheet;
      Microsoft.Office.Interop.Excel.Workbook wbook;
  
      wapp.Visible = false;
  
      wbook = wapp.Workbooks.Add(true);
      wsheet = (Worksheet)wbook.ActiveSheet;
  
      try
      {
          for (int i = 0; i &lt; ds.Tables[0].Columns.Count; i++)
          {
              wsheet.Cells[1, i + 1] = ds.Tables[0].Columns[i].ColumnName;
  
          }
  
          foreach (DataRow row in ds.Tables[0].Rows)
          {
              rowindex++;
              columnindex = 0;
              foreach (DataColumn col in ds.Tables[0].Columns)
              {
                  columnindex++;
                  wsheet.Cells[rowindex + 1, columnindex] = row[col.ColumnName];
              }
          }
      }
      catch (Exception ex)
      {
          String err = ex.Message;
      }
      wapp.UserControl = true;
  }
  </code></pre>