Qfyilyi

I use OpenXml SDK to read excel file :

        using (SpreadsheetDocument spreadsheetDocument =

    SpreadsheetDocument.Open(Server.MapPath("~/Content/Book1.xlsx"),

        false))

        {

            WorkbookPart workbookPart = spreadsheetDocument.WorkbookPart;

            WorksheetPart worksheetPart = workbookPart.WorksheetParts.First();

            SheetData sheetData = worksheetPart.Worksheet.Elements<SheetData>().First();

            string text;

            foreach (Row r in sheetData.Elements<Row>())

            {

                foreach (Cell c in r.Elements<Cell>())

                {

                    text = c.CellValue.Text;

                    SharedStringTablePart shareStringPart = spreadsheetDocument.WorkbookPart.GetPartsOfType<SharedStringTablePart>().First();

                    SharedStringItem items = shareStringPart.SharedStringTable.Elements<SharedStringItem>().ToArray();

                    text = items[int.Parse(c.CellValue.Text)].InnerText;

                }

            }

        }

it works fine, but I want to "move" data to collection of custom class. I.e. excel sheet is:

Custom class is declared as :

internal class Company

{

    public string CompanyName { get; set; }

    public string State { get; set; }



}

After parsing excel file I want to have a collection with 3 elements.
Any nuget package or another extensions to OpenXml SDK to do it?