From: Josh Cheek <josh.cheek@...>
Date: 2010-06-09T20:39:54+09:00
Subject: Re: How can I use Ruby with MS Excel?

--0016e656b6c0c4e3bc0488975ced
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On Tue, Jun 8, 2010 at 9:25 AM, Marvin G=FClker <sutniuq@gmx.net> wrote:

> Jason Lillywhite wrote:
> > As much as I hate to say it, Microsoft Excel is here to stay and will
> > continue to be the most popular tool among engineers and scientists.
> > When I say engineers, I mean mechanical, civil, environmental, chemical
> > engineers. The new version of Excel has some very nice graphical
> > capability.
> >
> > I love Ruby and hate Visual Basic with passion. Hopefully that goes
> > without further explanation.
> >
> > Could someone here help me envision a way to make use of Excel for the
> > input/output and Ruby for the model logic?
> >
> > In the perfect world, I would set up spreadsheet columns in Excel with
> > input data. Maybe I would have a couple of GUI windows for other inputs=
.
> > Then I could run the logic written in Ruby and output would be fed back
> > to spreadsheet columns in Excel. Then I could make use of their nice
> > graphing capabilities.
> >
> > Has anyone looked into this question?
> >
> > Thank you.
>
> Since it looks like on every computer excel is set up, you can connect
> to an excel OLE server and issue all the commands you can from
> VisualBasic (as far as I know). Have a look at
> http://rubyonwindows.blogspot.com/search/label/excel which has several
> blog posts about using Ruby together with excel. This post may makes a
> good starting point:
>
> http://rubyonwindows.blogspot.com/2008/01/rubygarden-archives-scripting-e=
xcel.html
>
> Marvin
> --
> Posted via http://www.ruby-forum.com/.
>
>
Any resources about how to access those formats on a Unix/Linux machine?

--0016e656b6c0c4e3bc0488975ced--