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

From what I've seen of statsample so far it looks more numerically 
oriented, whereas I tend to be dealing with lots of strings, some 
numbers, and a few dates.

Hyogen also looks more interested in the read-write than the analysis in 
the interim. My input tends to come from Nokogiri and I can already 
output to excel with some advanced formatting options using my own code.

I have attached one of the functions I wrote to output the data to Excel 
(part of a larger class).
As you can see, it's pretty simple to use; and I always have the option 
of just handing over the win3ole object if I need more advanced options 
(which happens occasionally). It could use some refactoring, but it does 
the job.

As I already have this kind of functionality available, it's the ability 
to sort through a table of data efficiently in the memory which 
interests me. I know a database would be ideal for that kind of 
operation, but I have portability in mind as a given report program may 
be on a variety of machines, and the only thing I know they have for 
sure is Office 2007 or higher.

Attachments:
http://www.ruby-forum.com/attachment/8161/Demo.rb


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