title: Excel automation C#: How to delete multiple rows?
body: <p>I have the following code and it does not delete the rows, it asks me to save over the current workbook but nothing is saved and EXCEL.EXE continues to run in Task Manager:</p>
  
  <pre><code>protected void OpenExcelWorkbook(string fileName)
  {
      _app = new Excel.Application();
  
      if (_book == null)
      {
          _books = _app.Workbooks;
          _book = _books.Open(fileName, Type.Missing, Type.Missing, Type.Missing,
              Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
              Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
              Type.Missing);
          _sheets = _book.Worksheets;
      }
  }
  
  protected void CloseExcelWorkbook()
  {
      _book.Save();
      _book.Close(false, Type.Missing, false);
  }
  
  
  protected void NAR(object o)
  {
      try
      {
          if (o != null)
              System.Runtime.InteropServices.Marshal.ReleaseComObject(o);
      }
      finally
      {
          o = null;
      }
  }
  
  private void button1_Click(object sender, EventArgs e)
  {
      OpenExcelWorkbook(@"C:\Book2.xls");
      _sheet = (Excel.Worksheet)_sheets[1];
      _sheet.Select(Type.Missing);
  
      Excel.Range range = _sheet.get_Range("A1", "A3");            
      range.EntireRow.Delete(Type.Missing);            
      NAR(range);
      NAR(_sheet);
      CloseExcelWorkbook();
      NAR(_book);
      _app.Quit();
  
      NAR(_app);
  }
  </code></pre>