System.Array to POCO using LINQ

Question

I am reading in data from an Excel sheet so I have this code to get the region I want;

Excel.Range range = (Excel.Range)worksheet.get_Range("A9", "AO" + (worksheet.UsedRange.Rows.Count).ToString());
System.Array rangeCells = (System.Array)range.Cells.Value;

So my Data is x long and 41 cells wide so my array looks like;

rangeCells[1,1] through to rangeCells[1,41] is line 1
rangeCells[2,1] through to rangeCells[2,41] is line 2

and so forth until the end.

Does anyone know of a LINQ way to get each line into an object?

Answer 1

I don't believe this is possible because multi-dimensional arrays do not impliment IEnumerable

Discussed more:

• Why do C# Multidimensional arrays not implement IEnumerable<T>?
• Selecting a multi-dimensional array in LINQ
• Generate a two dimensional array via LINQ