From: "Stephan Kämper" <sigma.kappa@...>
Date: 2006-12-16T18:05:49+09:00
Subject: Re: EXCEL Ruby not working

Hi,

anon1m0us wrote:
> I get a file name in the directory and modify the cells with making
> bold etc.
> when excel.visible=TRUE it works. However, when excel.visible=FALSE
> nothing happens.
> Why?
> 
> 
> 
> newdir=Dir.getwd
> 
> }
> excel.quit()
> 

This will look more like Ruby is you don't type the parentheses, and
it's less typing.

Speaking of Excel, I mostly use spreadsheet and parseexcel, which are
both available here:

http://rubyforge.org/frs/?group_id=678&release_id=6674

And BTW, you might consider putting your code in a begin ... rescue ...
ensure ... end block and, well, ensure that excel it actually quit.
Otherwise you might (will) end up with 'dangling' excel instances if (or
when) the code raises an exception.
If/when that happens, you have to quit the dangling Excel app. from the
task manager before you can run your program again (well without
problems, that is).
This happened every now and then on a Windows (2K) machine until I made
sure that excel.quit is actually executed in case of an error.

Anyway, I think the above mentioned modules are easier to use and 
understand than using OLE automation. And the code also look a lot more 
like Ruby.

Happy rubying

Stephan