Error when trying to read from excel file

ruby-talk
1

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

2

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