I am using the code :
require 'watir'
require 'open-uri'
url = ""http://finance.yahoo.com">http://finance.yahoo.com"
ie = Watir::IE.start(url)
ie.text_field(:name,'s').flash
ie.text_field(:name,'s').set("IBM")
ie.button(:id,'q').flash
ie.button(:id,'q').click
sleep 2
ie.show_tables
All works well except in ie.show_tables it gives the following error message:
Found 65 tables
1 id=yfncmh rows=1 columns=1
2 id=yfncmkttme rows=1 columns=1
3 id= rows=1 columns=1
4 id=yfncsubtit rows=1 columns=2
5 id=leftNavTable rows=2 columns=1
6 id=yfncbrobtn rows=1 columns=4
W, [30-Oct-2006 17:02:31#592] WARN -- : frame error in waitdocument
OLE error code:80070005 in <Unknown>
Access is denied.
HRESULT error code:0x80020009
Exception occurred.
c:/ruby/lib/ruby/site_ruby/1.8/watir.rb:1405:in `method_missing'
c:/ruby/lib/ruby/site_ruby/1.8/watir.rb:1405:in `wait'
c:/ruby/lib/ruby/site_ruby/1.8/watir.rb:1404:in `wait'
c:/ruby/lib/ruby/site_ruby/1.8/watir.rb:1254:in `goto'
c:/ruby/lib/ruby/site_ruby/1.8/watir.rb:1095:in `start'
gggggg.rb:6
W, [30-Oct-2006 17:03:05#592] WARN -- : frame error in waitdocument
OLE error code:80070005 in <Unknown>
Access is denied.
HRESULT error code:0x80020009
Exception occurred.
c:/ruby/lib/ruby/site_ruby/1.8/watir.rb:1405:in `method_missing'
c:/ruby/lib/ruby/site_ruby/1.8/watir.rb:1405:in `wait'
c:/ruby/lib/ruby/site_ruby/1.8/watir.rb:1404:in `wait'
c:/ruby/lib/ruby/site_ruby/1.8/watir.rb:2014:in `click'
gggggg.rb:11
c:/ruby/lib/ruby/site_ruby/1.8/watir.rb:1622:in `[]': unknown property or method `0' (WIN32OLERuntimeError)
HRESULT error code:0x80020006
Unknown name. from c:/ruby/lib/ruby/site_ruby/1.8/watir.rb:1622:in `show_tables'
from c:/ruby/lib/ruby/site_ruby/1.8/watir.rb:1621:in `show_tables'
from gggggg.rb:15
>Exit code: 1
I wants to access the value of nested table and store each record in Excel file, such as :
Prev Close : 90.76
Open : 90.86
What should be the solution for this
Thanks in advance
Find out what India is talking about on - Yahoo! Answers India
Send FREE SMS to your friend's mobile from Yahoo! Messenger Version 8. Get it NOW
_______________________________________________ Wtr-general mailing list [email protected] http://rubyforge.org/mailman/listinfo/wtr-general
