From: Timothy Gregory Date: 2013-02-20T22:07:57+09:00 Subject: Re: Select "columns" from multidimensional array? --047d7bdc071081191504d627a5cb Content-Type: text/plain; charset=ISO-8859-1 hey thanks for some concise notes on this important topic yes at length you guys built a nifty way to filter data in the memory even present live updates of cell vectors in the sheets your main data is strings my excel woes lately is the veteran car club parts catalogs i scan pages to tiff then image OCR to Word correct it and paste into Excel with aims like matching compatible pistons to various makes and models On Wed, Feb 20, 2013 at 11:00 PM, Joel Pearson wrote: > 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/. > > --047d7bdc071081191504d627a5cb Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
hey thanks for some concise notes on this i= mportant topic
yes at length you guys built a nifty way to filter = data in the memory
even present live updates of cell vectors in the shee= ts
your main data is strings
my excel woes lately is the v= eteran car club parts catalogs
i scan pages to tiff then image OCR to W= ord correct it and paste into Excel
with aims like matching compat= ible pistons to various makes and models


On Wed,= Feb 20, 2013 at 11:00 PM, Joel Pearson <lists@ruby-forum.com> wrote:
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 abilit= y
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/.


--047d7bdc071081191504d627a5cb--