From: Liang He <goal1860@...>
Date: 2007-10-11T12:32:06+09:00
Subject: Re: reading values from an excel spreadsheet

Krishna Vutukuru wrote:
> does anybody know how to open a spreadsheet and read the values in the
> cells and store them into an array using ruby?

xl=WIN32OLE.new('Excel.Application')
book = xl.Workbooks.Open('test.xls')
v=xl.Cells(1,1).value
xl.Cells(1,2).value=v
......
-- 
Posted via http://www.ruby-forum.com/.