title: How to open an Excel document and read values using Open XML in C#
body: <p>I would like to be able to open an excel document and loop through the values in the cells using Open XML in C#. </p>
  
  <p>Tried using the below code, but it never gets past the Foreach (Row...).  Also comments state this is for numeric values not Alpha Numeric values. </p>
  
  <pre><code>    using (SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.Open(Filedirectory, false))
      {
          WorkbookPart workbookPart = spreadsheetDocument.WorkbookPart;
          WorksheetPart worksheetPart = workbookPart.WorksheetParts.First();
          SheetData sheetData = worksheetPart.Worksheet.Elements&lt;SheetData&gt;().First();
          string text;
          foreach (Row r in sheetData.Elements&lt;Row&gt;())
          {
              foreach (Cell c in r.Elements&lt;Cell&gt;())
              {
                  text = c.CellValue.Text;
              }
          }
      }
  </code></pre>