Reading Data From Excel File

ruby-talk
1

I write some code for Reading data from excel file and put into the
google.
but they give error plz help me.

ERROR:
Excel.rb:16: warning: already initialized constant Keyword
Excel.rb:17: warning: already initialized constant Object_Prop_Name
Excel.rb:18: warning: already initialized constant Object_Prop_Value
Excel.rb:19: warning: already initialized constant Expected_Output
Excel.rb:20: warning: already initialized constant Parm_01
Excel.rb:16: warning: already initialized constant Keyword
Excel.rb:17: warning: already initialized constant Object_Prop_Name
Excel.rb:18: warning: already initialized constant Object_Prop_Value
Excel.rb:19: warning: already initialized constant Expected_Output
Excel.rb:20: warning: already initialized constant Parm_01
Excel.rb:16: warning: already initialized constant Keyword
Excel.rb:17: warning: already initialized constant Object_Prop_Name
Excel.rb:18: warning: already initialized constant Object_Prop_Value
Excel.rb:19: warning: already initialized constant Expected_Output
Excel.rb:20: warning: already initialized constant Parm_01

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_Prop_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_Prop_Value).set(Parm_01)

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

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

    when/^CloseURL/
    ie.close
    end

  end

end
workbook.Close()
excel.quit()

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

Attachments:
http://www.ruby-forum.com/attachment/4726/POC.xls

···

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

2

Keyword, Object_Prop_Name ... there are constant values in Ruby.
You should use lower case charset for valiable name. (e.g. keyword,
object_prop_name)
Thanks.

···

2010/5/13 KingMaker KingMaker <sweetzubair@gmail.com>:

I write some code for Reading data from excel file and put into the
google.
but they give error plz help me.

ERROR:
Excel.rb:16: warning: already initialized constant Keyword
Excel.rb:17: warning: already initialized constant Object_Prop_Name
Excel.rb:18: warning: already initialized constant Object_Prop_Value
Excel.rb:19: warning: already initialized constant Expected_Output
Excel.rb:20: warning: already initialized constant Parm_01
Excel.rb:16: warning: already initialized constant Keyword
Excel.rb:17: warning: already initialized constant Object_Prop_Name
Excel.rb:18: warning: already initialized constant Object_Prop_Value
Excel.rb:19: warning: already initialized constant Expected_Output
Excel.rb:20: warning: already initialized constant Parm_01
Excel.rb:16: warning: already initialized constant Keyword
Excel.rb:17: warning: already initialized constant Object_Prop_Name
Excel.rb:18: warning: already initialized constant Object_Prop_Value
Excel.rb:19: warning: already initialized constant Expected_Output
Excel.rb:20: warning: already initialized constant Parm_01

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_Prop_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\(:&quot;\#\{Object\_Prop\_Name\}&quot;,

Object_Prop_Value).set(Parm_01)

 when/^ClickButton/
ie\.button\(:&quot;\#\{Object\_Prop\_Name\}&quot;, Object\_Prop\_Value\)\.click

when/^ClickLink/

ie.link(:"#{Object_Prop_Name}", Object_Prop_Value).click

when/^CloseURL/
ie.close
end

end

end
workbook.Close()
excel.quit()

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

Attachments:
http://www.ruby-forum.com/attachment/4726/POC.xls

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

3

Ayumu Aizawa wrote:

Keyword, Object_Prop_Name ... there are constant values in Ruby.
You should use lower case charset for valiable name. (e.g. keyword,
object_prop_name)
Thanks.

Hi i try with lower case charset but program not run.

···

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

4

Hi,

plz post now virsion of your program.

···

2010/5/13 KingMaker KingMaker <sweetzubair@gmail.com>:

Ayumu Aizawa wrote:

Keyword, Object_Prop_Name ... there are constant values in Ruby.
You should use lower case charset for valiable name. (e.g. keyword,
object_prop_name)
Thanks.

Hi i try with lower case charset but program not run.

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

5

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

6

So are you getting the same warning messages?? Since those were
Warnings and not Errors, your program should still have done something.
When you say its not running, are you getting errors, or it not working
the way you want it to??

-- john

···

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

7

This program may be your want, but also you can use Selenium or Mechanize.

see below
- http://seleniumhq.org/
- http://mechanize.rubyforge.org/mechanize/

···

---
require 'rubygems'
require 'win32ole'
require 'watir'
include Watir

begin
  #Open Excel File
  excel = WIN32OLE::new('excel.Application')
  excel.DisplayAlerts = false
  workbook = excel.Workbooks.Open('C:\tmp\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

---
Ayumu AIZAWA
http://twitter.com/ayumin

2010/5/13 John Allen <john.allen@exonets.com>:

So are you getting the same warning messages?? Since those were
Warnings and not Errors, your program should still have done something.
When you say its not running, are you getting errors, or it not working
the way you want it to??

-- john

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