From: Kenichi Kamiya Date: 2012-03-06T14:14:27+09:00 Subject: Re: Error when trying to read from excel file 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/.