From: Joel Pearson <lists@...>
Date: 2013-04-11T09:38:45+09:00
Subject: Re: RubyExcel class. Useful?

Hi all, just an update for anyone who's interested.

I've now managed to get this gem working sufficiently well to use it in 
a few of my projects.

I've incorporated some WIN32OLE tools for things that I do a lot, also 
lending credence to the name RubyExcel.

I think I've weeded out most of the bugs, and I've written a more 
comprehensive guide which is the ReadMe at Github.

I've tried to take on board all the suggestions so far, although I've 
dropped the header columns idea as tricky to implement alongside header 
rows; and currently of no use to me. Maybe I'll be able to add them 
later.

I've now managed to implement all the basics to the point that I'm just 
adding new bits as and when I need them. The core sections all seem to 
be working as intended, although of course it's still possible to cause 
problems by feeding it invalid input. I might add more extensive 
validation if that becomes enough of an issue.

I've even managed to get a wobbly looking bit of recursive code to 
import a nested Hash into a table array; which is something I'm having 
to do at work with increasing regularity. I spent long hours into the 
night trying to build it and I'm still not entirely sure how it works. 
It was more of a half-understood trial and error thing.
Actually if anyone can come up with a better way to do this I'd be 
fascinated, since I always have trouble visualising recursive methods. 
I'll attach the relevant code to this post.

The gem still lives here: https://rubygems.org/gems/rubyexcel
The code still lives here: https://github.com/VirtuosoJoel/RubyExcel

I still need to work out what (if any) documentation-style comments to 
add to the code itself. What do people use the most? The rubygems 
documentation link says it's a "YARD documentation server", but the 
local install only dropped some ".ri" files, and I've only just learned 
how to use those.

Attachments:
http://www.ruby-forum.com/attachment/8318/convert_hash.rb


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