From: Rafal Zdziech <raf@...>
Date: 2012-03-06T22:54:11+09:00
Subject: Re: Error when trying to read from excel file

I think we could do with this excell sheet and explanation on what you
want to get from that sheet.

Cheers.

On 3/6/12, Kenichi Kamiya <kachick1@gmail.com> wrote:
> You mean like this?
> I've never used this gem too.
> But the results are looked succeed.
>
> on:
>   * ruby 1.9.3p125 (2012-02-16) [i386-mingw32]
>   * roo-1.10.1
>
> =begin
> require 'roo'
>
> spreadsheet = Excel.new 'example.xls'
> spreadsheet.default_sheet = spreadsheet.sheets.first
>
> 1.upto 12 do |row_number|
>   situation, justification, code, description =
>   * %w[A B P Q].map{|line_symbol|spreadsheet.cell row_number,
> line_symbol}
>
>   if situation == 'abc' and justification == 'xyz'
>     puts [situation, justification, code, description].join("\t")
>   end
> end
> =end
>
> Lekha Selvaraj wrote in post #1050301:
>> Any help here pls.
>
> --
> Posted via http://www.ruby-forum.com/.
>
>