Hi All,
I am a newbie to watir. My scenario is to validate e-mail text field
with various input data which taken from a external excel sheet, then
i have to write the results to the same excel sheet. In some cases i
should use the same data for more than one pages, if the test gets
failed i should write the results to the results column with page
name, if the test gets failed in more than pages i have to append the
pages name one by one in a single cell.
below code i am using for single page it works good.
$excel_path = "e:\\Data\\Prince\\WatIR\\Test Cases\
\iTrade_Masters_Test_Report.xls"
$excel = WIN32OLE.new("excel.application")
$excel['Visible'] = true;
$workbook = $excel.Workbooks.Open $excel_path
$worksheet = $workbook.WorkSheets(6)
$worksheet.Select
# in the middle i start the application and open the particular
page
until i > 14
i = 1
j = 0
j = i+84
$ie.frame(:id,"wfFrame").text_field(:id,"txtEmail").set
$worksheet.Range("e#{j}")['Value']
$wsh.AppActivate("iTrade - Microsoft Internet Explorer")
$wsh.SendKeys"{TAB}"
if $ie.frame(:id,"wfFrame").div
(:id,"PageActionPane_ValidationSummary1").li(:text,"Invalid Email
ID").exists?
$ie.frame(:id,"wfFrame").div
(:id,"PageActionPane_ValidationSummary1").li(:text,"Invalid Email
ID").flash
$worksheet.Range("j#{j}")['Value'] = "Fail"
else
$worksheet.Range("j#{j}")['Value'] = "Pass"
end
i+=1
end
I should use the same code for more than 5 pages and write the result
to the same cell in append mode. If i use the same code for second
page it overwrite the existing result.
so give me the solution to append the results in a excel sheet's cell
Thanks,
Prince3105
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
