using System;

using System.Collections;

using System.Collections.Generic;

using DocumentFormat.OpenXml;

using DocumentFormat.OpenXml.Packaging;

using DocumentFormat.OpenXml.Spreadsheet;

using System.Linq;

​

public class Program

{

    public static void Main()

    {

        Console.WriteLine("Hello World");

    }

​

    public static IEnumerable<List<string>> ReadData(string fileName)

    {

        using (SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.Open(fileName, false))

        {

            WorkbookPart workbookPart = spreadsheetDocument.WorkbookPart;

            WorksheetPart worksheetPart = workbookPart.WorksheetParts.FirstOrDefault();

            if (workbookPart != null)

            {

                using (OpenXmlReader oxr = OpenXmlReader.Create(worksheetPart))

                {

                    IEnumerable<SharedStringItem> sharedStrings = workbookPart.SharedStringTablePart.SharedStringTable.Elements<SharedStringItem>();

                    while (oxr.Read())

                    {

                        if (oxr.ElementType == typeof(Row))

                        {

                            oxr.ReadFirstChild();

                            List<string> rowData = new List<string>();

                            do

                            {

                                if (oxr.ElementType == typeof(Cell))

                                {

                                    Cell c = (Cell)oxr.LoadCurrentElement();

                                    string cellValue;

                                    if (c.DataType != null && c.DataType == CellValues.SharedString)

                                    {

                                        SharedStringItem ssi = sharedStrings.ElementAt(int.Parse(c.CellValue.InnerText));

                                        cellValue = ssi.Text.Text;

                                    }

                                    else

                                    {

                                        cellValue = c.CellValue.InnerText;

                                    }

​

                                    rowData.Add(cellValue);

                                }

                            }

                            while (oxr.ReadNextSibling());

                            yield return rowData;

                        }

                    }

                }

            }

        }

    } // GetData

}