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.