title: Remove Characters from List Filled by DataTable (OleDB read Excel File)
body: <p>I want to read Excel <strong>sheet names</strong> (in workbook) using <code>OleDB</code>. I am filling the <code>DataTable</code> and assigning the sheet names to a list.</p>
  <p>Sheet names in Excel Workbook is under</p>
  <ul>
  <li>Grade 7</li>
  <li>Grade 6</li>
  <li>ECE</li>
  </ul>
  <p>Code that I am trying is as-</p>
  <pre><code>DataTable schemaTable = connExcel.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
  List&lt;string&gt; lstSheets = schemaTable.AsEnumerable()
                      .Select(r =&gt; r.Field&lt;string&gt;(&quot;TABLE_NAME&quot;)).ToList();
          lstClass.DataSource = lstSheets; // lstClass is a Listbox
  </code></pre>
  <p>I can read the name of sheets using this code but it has extra characters Like (<strong>'</strong> , <strong>$</strong>). sheet names retrieving are as:-</p>
  <ul>
  <li><strong>'Grade 7$'</strong></li>
  <li><strong>'Grade 6$'</strong></li>
  <li><strong>ECE$</strong></li>
  </ul>
  <p>I want to read just names not with special extra characters.</p>