Array of an array

Question

0.00/5 (No votes)

See more:

Hi,

I need to store multiple 2 dimensional arrays. So basically what I want to do is store an array of arrays. To give you some background on what I'm doing, I need to build an array and write it to a spreadsheet. I need to open 9 different spreadsheets and extract information from each of them. Based on the instructions given to me, all 9 spreadsheets need to be open at the same time in order for the cross reference links to work correctly.

What I would like to have is each element of the master array, contains a two dimensional array. Is this possible, or do I need to declare 9 separate multidimensional array variables?

Thank you,
Glenn

Posted 14-Sep-10 9:19am

gmhanna

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Marc A. Brown · Accepted Answer · 2010-09-14T09:37:00

Solution 1

Can't you declare a three dimensional array? Two dimensions to represent the rows and columns and the third to represent each sheet?

Posted 14-Sep-10 9:37am

Marc A. Brown

Updated 14-Sep-10 9:47am

v2

OriginalGriff · Accepted Answer · 2010-09-14T09:44:00

Solution 2

Try this:

C#

int[][,] arrayOfArrays = new int[100][,];
for (int i = 0; i < 100; i++)
    {
    arrayOfArrays[i] = new int[20, 30];
    }

This declares an array of 100 2D arrays, and assigns each enough room for a 20 by 30 int array.

Posted 14-Sep-10 9:44am

OriginalGriff

AspDotNetDev · Accepted Answer · 2010-09-14T09:49:00

Solution 3

You can do that. You can also use lists:

C#

List<List<List<SomeClass>>> myList;

Posted 14-Sep-10 9:49am

AspDotNetDev