Reading values from an excel spreadsheet

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

···

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

Krishna Vutukuru wrote:

···

does anybody know how to open a csv and read the values in the
cells and store them into an array using ruby?

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

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/\.

Krishna Vutukuru wrote:

Krishna Vutukuru wrote:

does anybody know how to open a csv and read the values in the
cells and store them into an array using ruby?

I actually need it for csv files not xls files...

···

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

Have a looky here:

http://fastercsv.rubyforge.org/

···

On 10/11/07, Krishna Vutukuru <krishna_vutukuru@gap.com> wrote:

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

I actually need it for csv files not xls files...

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