From: "abbadi s." <lists@...>
Date: 2012-09-11T18:51:31+09:00
Subject: How to Read a Excel file

Hello,

I am trying to read a excel file using ruby but i am not able to read
the file. below is the code i have used

------------------------------------
require 'rubygems'
require 'selenium-webdriver'
require 'parseexcel'

workbook =
Spreadsheet::ParseExcel.parse("c:\Ruby193\scripts\testing.xls")
worksheet = workbook.worksheet (1)
j = 1
worksheet.each { |row|

i=0
  if row != nil
      row.each { |cell|
    if cell != nil
      contents = cell.to_s('latin1')
      puts "Row: #{j} cell: #{i} > #{contents}"
    end
  i = i+1
    }
  end
}
--------------------------------------
Please any one can help me in this... Provide me the right code

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