title: How can show Excel Sheet Name in dropdownlist using C#
body: <p>I want to show an excel sheet name in a dropdown list using c#. But using my code, I am able to show excel sheet name but excel sheet name comes with '' and $.
  Coming Output is like: <code>Sheet1$</code>, <code>Sheet2$</code></p>
  
  <pre><code>        sheetNameddl.Items.Clear();
          sheetNameddl.DataSource = con.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
          sheetNameddl.DataTextField = "TABLE_NAME";
          sheetNameddl.DataValueField = "TABLE_NAME";
          sheetNameddl.DataBind();
          sheetNameddl.Items.Insert(0, new ListItem("--Select Sheet--", ""));
  </code></pre>
  
  <p>But the wanted output is like <code>sheet1</code>, <code>sheet2</code>.</p>