From: Todd Burch <promos@...>
Date: 2007-08-09T03:45:07+09:00
Subject: Re: How to operate an existing Excel file?

alexeyomux wrote:
> <<Programming Ruby 2nd>> teaches me how to create a new Excel file and 
> add
> something to it, but now I have a task that there were some existing 
> Excel
> files with data, what should I do is opening the files one by one and 
> read
> the data for doing something.
> I try to use the WIN32OLE .connect() function, but it didn't work.
> Is there other better way to do so?
> thanks a lot!

.connect establishes a connection between your ruby and an already 
running instance of Excel.
.open opens a new instance of Excel, whether Excel is running at the 
time or not.

After you establish a session with Excel, using either of the above 
methods, then you need to open the workbook you want.

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