From: "Marvin Gülker" <sutniuq@...>
Date: 2010-06-08T23:25:28+09:00
Subject: Re: How can I use Ruby with MS Excel?

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-excel.html

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