Reading Data From Excel File

King_Maker · 13 May 2010 06:00

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

Ayumu_Aizawa · 13 May 2010 06:12

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

King_Maker · 13 May 2010 06:39

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

Ayumu_Aizawa · 13 May 2010 06:42

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

King_Maker · 13 May 2010 06:47

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

John_Allen1 · 13 May 2010 07:07

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

Ayumu_Aizawa · 13 May 2010 07:35

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

Topic		Replies	Views
How to get value of constants in Excel using WIN32OLE ruby-talk	2	119	1 December 2006
Excel manipulation ruby-talk	2	89	14 April 2010
Excel and Ruby ruby-talk	16	112	5 November 2010
Win32ole and excel ruby-talk	18	469	13 August 2002
Reading data from excel ruby-talk	12	129	23 May 2008

Reading Data From Excel File

Related topics