Hi,
What I would like to do is the following:
I have done the first step but is getting stuck on the 2nd one. I am having trouble with mapping the objects of the Excel spreadsheet.
Looking forward to anyone's input.
tristaanogre, how do I do that via Keyword Test? Note that I do not use scripts and mainly use Keyword tests.
shankar_r, I do not use scripts, only Keywords. See ExcelVerification.png. The property checkpoint there only checks the spreadsheet's filename as that's the only thing I can do for now with my limited knowledge.
The basics of a DDT loop in Keyword testing can be found at https://support.smartbear.com/testcomplete/docs/keyword-testing/basic/data-driven-loops.html.
What you need to do is put your comparison routine in your loop. This is the easiest way to do this with keyword tests. Beyond that, your next best bet is to work with the OleObject of Excel.Application and compare the values in the columns.
Hi,
Simple sample for validating content in excel.
Sub CompareValue(str_ComVal)
Dim Excel
Set Excel = Sys.OleObject("Excel.Application")
Excel.Workbooks.Open("D:\Users\Documents\Testss.xlsx")
If Excel.ActiveWorkbook.Sheets.Item("Sheet1").Range("A1") = str_ComVal Then
Log.Checkpoint("Matched")
Else
Log.Error("Not matched")
End If
Excel.Quit
Set Excel = Nothing
End SubCan you show us the code which you trying for this scenario?
