From: bernhard stoecker <lists@...>
Date: 2012-09-11T19:41:29+09:00
Subject: Re: How to Read a Excel file

this is how i usually resolve this (by using the spreadsheet gem)

          book = Spreadsheet.open(File.dirname(__FILE__) + 
'/xyz/data.xls')
          sheet1 = book.worksheet('strange name') # can use an index or 
worksheet name
          array = []
          sheet1.each do |row|
            break if row[0].nil? # if first cell empty
            array << {:value1 => row[0].to_datetime, :value2 => 
row[1].to_f}
          end

hope this helps

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