From: KingMaker KingMaker <sweetzubair@...>
Date: 2010-05-13T15:47:48+09:00
Subject: Re: Reading Data From Excel File

require 'watir'
include Watir

begin
 #Open Excel File
excel = WIN32OLE::new('excel.Application')
excel.DisplayAlerts = false
workbook = excel.Workbooks.Open('C:\test\POC.xls')
#Loop through the worksheets
for i in 1 .. workbook.Worksheets.Count

  worksheet = workbook.Worksheets(i)
  rowcount = worksheet.UsedRange.Rows.Count

  for j in 2..rowcount
    keyword =worksheet.Cells(j, 1).value
    object_prop_name = worksheet.Cells(j, 2).value
    object_Ppop_value = worksheet.Cells(j, 3).value
    expected_output = worksheet.Cells(j, 4).value
    parm_01 = worksheet.Cells(j, 6).value

    case keyword
      when /^OpenURL/
      ie=IE.start(Parm_01)
      #~ @Browser.maximize

      when /^SetText/
      ie.text_field(:"#{object_prop_name}", 
object_Ppop_value).set(parm_01)

      when/^ClickButton/
     ie.button(:"#{object_prop_name}", object_Ppop_value).click

     when/^ClickLink/
    ie.link(:"#{object_prop_name}", object_Ppop_value).click

    when/^CloseURL/
    ie.close
    end
  end
end
 workbook.Close()
excel.quit()

  rescue
  workbook.Close()
  excel.quit()
end



also i attach the execl file plz have a look
gem 0.9.4
ruby 1.8.6 (2007-09-24 patchlevel 111) [i386-mswin32]
-- 
Posted via http://www.ruby-forum.com/.