reading values from an excel spreadsheet

[Krishna Vutukuru]

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

 

[Krishna Vutukuru]

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

 

[Krishna Vutukuru]

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

 

[Liang He]

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