Extracting Excel Data Chart and Storing into 2-D array in VB

Hello, I'm new to using Visual Basic, so I apologize if my question is confusing.

So I have this Excel chart of data with two columns and numbers under these

columns. I want to figure out a way to extract the data from Excel and store

the chart contents into a 2-D array in VB consisting of the number of entries

for its first dimension, then the two columns from the chart being the components

of the second dimension. So for example, if I had 11 entries of numbers

under both columns in the Excel chart, the new array in VB would have [11][2]

as it's array specs. Any help would be greatly appreciated. Thanks.

Re: Extracting Excel Data Chart and Storing into 2-D array in VB

The Excell spreadsheet IS a 2 dimension array. If you check out the object

browser for a little bit, you will figure it out.

You need to access the Cell property of a sheet, and the cell property has

2 parameters... rowIndex, colIndex. Use an imbeded for loop, and tear it

apart and put it back together in your array.

Sorry if I am a little parse... but I haven't worked with the Excell model

in a while.

"Eugene Lim" <eugene.lim@guidant.com> wrote:

>

>Hello, I'm new to using Visual Basic, so I apologize if my question is confusing.

> So I have this Excel chart of data with two columns and numbers under these

>columns. I want to figure out a way to extract the data from Excel and

store

>the chart contents into a 2-D array in VB consisting of the number of entries

>for its first dimension, then the two columns from the chart being the components

>of the second dimension. So for example, if I had 11 entries of numbers

>under both columns in the Excel chart, the new array in VB would have [11][2]

>as it's array specs. Any help would be greatly appreciated. Thanks.