Hi
Am trying to parameterizing my test cases am getting some error,am not
understanding where am wrong i have gone thru the posts regarding this
i dint get any idea,Can anyone pls let me know whats wrong here
My code:
require 'watir'
require 'watir/testcase'
require 'watir/assertions'
require 'test/unit'
require 'LogIn'
begin
xlFile = XLS.new('C:\\MA.xls')
$Policynumber = xlFile.getColumnRecords('B4:C6', 'Ponumber')
setupInfo = xlFile.getHash('A1:B4', 'Setup')
$runTests = xlFile.getHash('A13:B27', 'Setup')
ensure
xlFile.close
end
$test_site = setupInfo['URL']
$UserName = setupInfo['Username']
$UserPass = setupInfo['Password']
#get today's date for use in scripts
$today = "#{Time.now.month.to_s}/#{Time.now.day.to_s}/#
{Time.now.year.to_s}"
# open the IE browser
$ie = Watir::IE.new
$ie.speed = :fast
# go to the selected MA site
$ie.goto($test_site)
class TestSuite < Test::Unit::TestCase
include Watir::Assertions
#login with the supplied producer username and password
def test_00Login
if $runTests['login'] == 'Yes'
if $ie.text.include?('Inspection Search Results')
login($Username, $Password)
else
puts 'The user was already logged in when the
application was opened.'
end
else
puts ' '
puts 'You chose not to run the user login test.'
end
end
#Search records
def Searchrecord_ponumber
myData.each do |record|
$ie.link(:href, "http://www.searchrecord/SearchInit.do";).click
$ie.button(:name, "clearCriteriaBtn").click
$ie.radio(:index, 2).set
$ie.text_field(:name, "policyNumber").set(record['PoNumber'])
$ie.button(:name, "submitBtn").click
if $ie.contains_text(record['ContainsText'])
puts "Results of search: '#{record['PoNumber']}' contains '#{record
['ContainsText']}'"
else
puts "Error: could not find text: '#{record['ContainsText']}' in
results of search: '#{record['PoNumber']}'"
end
sleep 3
#~ ie.close
end
end
end
Error message:
Testrun.rb:37:
./Xls.rb:226:in `getWorksheet': getWorksheet(sheet=Setup) --> Sheet
'Setup' COULD NOT BE FOUND (RuntimeError)
from ./Xls.rb:193:in `getRange'
from ./Xls.rb:104:in `get2DArray'
from ./Xls.rb:145:in `getHash'
undefined method `close' for nil:NilClass (NoMethodError)
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Watir General" group.
To post to this group, send email to [email protected]
Before posting, please read the following guidelines:
http://wiki.openqa.org/display/WTR/Support
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/watir-general
-~----------~----~----~----~------~----~------~--~---
