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?

@HighCore Don't comment just to comment. Linq is good but not necessary. griegs, Linq wouldn't make your code more efficent. — I4V
– I4V, Commented Jul 2, 2013 at 22:02
@griegs Going by RandomWebGuy's links, it seems that multidimensional arrays do, however, implement non-generic IEnumerable. So range.Cells.Value.Cast<whatever>().Select() is also an option. — millimoose
– millimoose, Commented Jul 2, 2013 at 23:00

Community · Accepted Answer · 2017-05-23 11:56:31Z

1

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

Discussed more:

edited May 23, 2017 at 11:56

CommunityBot

11 silver badge

answered Jul 2, 2013 at 22:07

RandomWebGuy

1,43912 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

millimoose Over a year ago

@AbeMiessler Seeing as LINQ-to-Objects is a set of extension methods over IEnumerable(T), the fact that only onedimensional arrays implement that interface would be a sticking point.

millimoose Over a year ago

@KevinBabcock If by "ways around that" you mean doing something to flatten the array, then you're not really working with a 2D array anymore. (I admit this is splitting hairs, but the ambiguity alone means this answer isn't wrong per se, if not particularly helpful.)

Kevin Babcock Over a year ago

@millimoose agreed (removed my comment)

Collectives™ on Stack Overflow

System.Array to POCO using LINQ

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related