If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

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.