Forum Discussion
tristaanogre
8 years agoEsteemed Contributor
I wouldn't even bother with the OleObject... use a DDT.ExcelDriver to loop through the rows and check the value of each cell in the indicated column. Built a list of all the differences and report any at the end.
- XBug8 years agoContributor
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.
- tristaanogre8 years agoEsteemed Contributor
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.
Related Content
Recent Discussions
- 5 days ago
- 5 days ago