Codewut Because Software Matters

String connectionString =
  "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\test.xls;Extended Properties=\"Excel 8.0;HDR=YES;\"";
DbProviderFactory factory = DbProviderFactories.GetFactory("System.Data.OleDb");
try
{
  using (OleDbConnection connection = new OleDbConnection(connectionString))
  {
    connection.Open();
    DataRowCollection rows = connection.GetSchema("Tables").Rows;
    foreach (DataRow row in rows)
    {
      string sheetName = row["TABLE_NAME"] as string;
      Console.WriteLine("************************************************************************");
      Console.WriteLine("Dumping Sheet: "+sheetName);
      Console.WriteLine("************************************************************************");
      using (DbCommand command = connection.CreateCommand())
      {
        string[] restrictions = { null, null, sheetName, null };
        DataRowCollection columns = connection.GetSchema("Columns", restrictions).Rows;
        string[] columnNames = new string[columns.Count];
        for (int i=0; i<columns.Count; i++)
        {
          columnNames[i] = columns[i]["COLUMN_NAME"] as string;
        }
        Console.Write("Columns in Sheet: ");
        foreach (string s in columnNames)
        {
          Console.Write(s);
          Console.Write(" ");
        }
        Console.WriteLine("");
 
        command.CommandText = "SELECT * from [" + sheetName + "]";
        using (DbDataReader dr = command.ExecuteReader())
        {
          while (dr.Read())
          {
            foreach (string columnName in columnNames)
            {
              Object fieldValue = dr[columnName];
              Console.WriteLine("'" + columnName + "' : " + "'" + fieldValue + "'");
            }
            Console.WriteLine("------------------------------------------------------------------------");
          }
        }
      }
    }
  }
}
catch (Exception e)
{
  Console.Write(e.StackTrace);
}