Analogy Analogy wrote:
> Thanks for the suggestion David. How would I get rid of the "nil" values
> for the empty cells that are pulled into the 2D array? Thanks!!

How you do this may depend on what you plan do with your data, and when.

I'm assuming you want to preserve the structure; otherwise the
aforementioned compact method will remove nil values for you.

I frequently convert nils to empty strings with the to_s method. You may
wish to do this when outputting your data, or in-place using a method
such as collect!:

data = worksheet.UsedRange.Value

=> [["A1", "B1", "C1", nil, "E1"], ["A2", nil, "C2", "D2", nil], [nil,
"B3", nil, "D3", "E3"]]

data.collect!{|row| row.collect!{|field| field.to_s}}

=> [["A1", "B1", "C1", "", "E1"], ["A2", "", "C2", "D2", ""], ["", "B3",
"", "D3", "E3"]]

If it's numeric data, perhaps to_i or to_f works better for you.

Hope that s.

David

http://rubyonwindows.blogspot.com
--
Posted via http://www.ruby-forum.com/.