Reading values from an excel spreadsheet

Ruby
1

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

2

Krishna V. wrote:

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

3

Krishna V. wrote:

Krishna V. 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…

4

Have a looky here:

http://fastercsv.rubyforge.org/

5

Krishna V. 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
…