title: Iterate Through rows in Excel
body: <p>I am attempting to get all the numbers from the cells in column A from an excel spreadsheet, but I am only getting my header line returned. What am I doing wrong?</p>
  
  <pre><code>static void Main(string[] args)
  {
      var excel = new Microsoft.Office.Interop.Excel.Application();
      Workbook workbook = excel.Workbooks.Open(@"C:\Documents\ANIs.xlsx");
      Worksheet worksheet = workbook.Worksheets[1];
  
      Range a1 = worksheet.get_Range("$A1");
  
      object rawValue = a1.Value;
      string Text = a1.Text;
  
      foreach (Range item in a1.Cells)
      {
          Console.WriteLine("{1}", rawValue, Text);    
      }
      Console.Read();
  }
  </code></pre>