title: Get column names from excel file of a specific sheet using c# with OleDbConnection
body: <p>So far I have managed to get the column names of the whole excel file, but what I would like to do is to get the column names of the excel file of a given table (sheet). How could I modify the code to achieve this. I have been trying for a while now with no positive results, any help much appreciated.</p>
  
  <pre><code>public static List&lt;String&gt; ReadSpecificTableColumns(string filePath, string sheetName)
      {
          var columnList = new List&lt;string&gt;();
          try
          {
              var excelConnection = new OleDbConnection("provider=Microsoft.ACE.OLEDB.12.0;Data Source='" + filePath + "';Extended Properties='Excel 12.0;IMEX=1'");
              excelConnection.Open();
              var columns = excelConnection.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, null);
              excelConnection.Close();
  
              if (columns != null)
              {
                  columnList.AddRange(from DataRow column in columns.Rows select column["Column_name"].ToString());
              }
  
          }
          catch (Exception exception)
          {
              Console.WriteLine(exception.Message);
          }
  
          return columnList;
      }
  </code></pre>