title: OLEDB for EXCEL - Drop Table [SheetName$] - Doen't Delete Sheet
body: <p>I am using drop table [SheetName$] to delete a worksheet from excel. </p>
  
  <p><strong>This just clears the data of the sheet but does not delete the sheet.</strong></p>
  
  <p>I have tried using xls and xlsx. Doesn't work with both versions !</p>
  
  <pre><code>OleDbConnection connection = new OleDbConnection();
  
  try
  {
  connection.ConnectionString =
  @"Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties='drop.xlsx";
  connection.Open();
  OleDbCommand command = new OleDbCommand("Drop Table [MySheetName_1$]", connection);
  command.ExecuteNonQuery();
  }
  finally
  {
  connection.Close();
  }
  </code></pre>
  
  <p>Any Help / Pointers appreciated !
  Thanks</p>