From: Joel Pearson <lists@...>
Date: 2013-02-19T21:52:08+09:00
Subject: Re: Select "columns" from multidimensional array?

Ok... new changes:

Used "Me" to reference the class so I don't have to keep typing the 
classname when referencing class methods.

Removed String alterations in favour of the class methods "self.row" and 
"self.column" which pass a string as an argument.

Combined various checks again multidimensional array input into a method 
"multi_array?"

Added "insert_columns" and "insert_rows", which after long hours of 
threatening my laptop with physical violence I've finally gotten into 
some sort of working order.

Added "delete_column" and "delete_row"

Modified the "compact" methods to work with the above.

Modified "calc_columns" and "calc_rows" to accept a multidimensional 
array as an optional argument, otherwise they reference "data".

Added "cells" so the API gives the option to list all populated cell 
addresses.

Added strip! and upcase!

Modified the example case at the end to work with the major changes.

It's still far from complete, but it's taking form well enough that I 
might be able to start replacing my old class with it in future 
projects.
If I can get a clean and tidy version eventually I might make it into a 
gem.

Sadly I did succumb to the urge to add ASCII art comments. I'll probably 
remove it when I drift back closer to sanity.

Attachments:
http://www.ruby-forum.com/attachment/8154/RubyExcel.rb


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