Forum Discussion

XBug's avatar
XBug
Contributor
9 years ago

How to test the content of an Excel spreadsheet?

Hi,   What I would like to do is the following: Open an Excel File from a directory Check if the content of the column in Excel file meets a certain criteria   I have done the first step but ...
tristaanogre's avatar
tristaanogre
Esteemed Contributor
9 years ago
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.
XBug's avatar
XBug
Contributor
8 years ago

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.