From: Sean Carley <seanacarley@...>
Date: 2006-06-06T06:04:25+09:00
Subject: Re: reading data from excel

------=_Part_4760_16627526.1149541462384
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On 6/5/06, Parvinder Ghotra <ghotrapa@yahoo.com> wrote:
>
> Can somebody share their expertise on how to open and read data from
> excel using ruby?


I would also recommend parseexcel.  The maintainer is very friendly and the
package works quite well.

require "parseexcel/parseexcel"
file_name = "/your/file/name/here.xls"
workbook = Spreadsheet::ParseExcel.parse(file_name)
worksheet = workbook.worksheet(0) # the first sheet in the book
worksheet.each { |row| puts row.at(0) } # print the first column of each row

And also any suggestions on where/how to learn Ruby would be very
> helpful and appreciated.
>

I would recommend "Why's (Poignant) Guide to Ruby" if your tolerance for the
absurd is high.  (http://poignantguide.net/ruby/)  Otherwise, I would
recommend "Learn to Program" as a place to start online.  (
http://pine.fm/LearnToProgram/)

Good luck.

Sean Carley
http://sean-carley.blogspot.com/

------=_Part_4760_16627526.1149541462384--