大家好啊,大家谁知道qtp如何通过导入excel,控制excel里面的数据和页面table里的数据进行比较!作者: auto_tester 时间: 2014-4-21 13:55 回复 1#auto_tester
高人谁有这样的例子,请赐教!作者: auto_tester 时间: 2014-4-23 09:00
For i = 1 To 1 Step 1
For j = 1 To 2 Step 1
Set excel = createobject("Excel.Application")
excel.Workbooks.Open "D:\Test.xlsx"
Set osheet = excel.Sheets.Item(1)
d =osheet.cells(i,j)
print d
Dim result
For b = 2 to Browser("IDS Super - Member Details").Page("IDS Super - Member Details").WebTable("Pension Account").RowCount
result = trim(cstr(Browser("IDS Super - Member Details").Page("IDS Super - Member Details").WebTable("Pension Account").GetCellData(b,4)))
If d = result then
Reporter.ReportEvent micPass,"Current Withdrawals" ,"预期是" &d& "实际是" &result
else