hi Joel
i am timo i follow this thread you are do= ing great

starting to look like it will be a worthwhile effor= t

lately i have hoped for a few pointers in this same topic<= br>

may i ask have you compared any current ruby forge programs?
a few= mainly older Ruby programs seem to exist for MS Excel in Ruby
http://rubyforge.org/project= s/spreadsheet=A0=A0 (2011) beta
and on ruby-lang
ht= tp://raa.ruby-lang.org/project/hyogen/ =A0 ( 2007)
http://raa.ruby-lang.org/proje= ct/ruby-statsample/=A0 (2010)
http://raa.ruby-la= ng.org/project/parseexcel/=A0=A0=A0=A0=A0 (2006)

On Wed, Feb 20, 2013 at 10= :14 AM, Joel Pearson <lists@ruby-forum.com> wrote:

I've now had time to do a bit more testi= ng and debugging, and I've
managed to come up with a (relatively) stable and usable framework. Even more surprising, I now have a working version of pretty much everything
on my wish list. I suppose I can just call .dup or .clone for when I
want to take different sections of the data down different paths.

I've tried to refactor some of the more esoteric code, and improve the<= br> "encapsulation" by hiding the underlying hash wherever I spotted = it
poking out.

I've actually managed to use recursion (in the "unique" metho= d) without
permanently looping! I'll just gloss over the amount of permanent loops=
I went through to get that right...

I've had to make some hefty use of reverse_each to sort out deleting entire sections and compacting the rest afterwards.

As usual, I've probably made many silly mistakes and done things the hard way. Any advice would be appreciated (although not demanded ;-) ).

I think the next thing to do is put this class through some real-world
scenarios, so I'll be using it as a replacement for ye olde Excel_Sheet=
class.

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

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