On Sep 14, 6:18 pm, Analogy Analogy <analog...@aol.com> wrote:
> I'm reading an excel file (text and numbers) with the intent of storing
> the data in a 2D array.
>
> Anyone know how
> I might be able to pull all my data into a 2D array no matter where the
> data starts? Thanks!
>

Here's a method I frequently use to get a 2-dimensional array of all
values from a worksheet...

data = worksheet.UsedRange.Value

David

http://rubyonwindows.blogspot.com/search/label/excel