How work Excel Checkpoint?
Can someone explain to me how the Excel Checkpoint works? It seems like it just compares the content of an existing Excel file with itself. What I would like it to do is compare an existing Excel file with an Excel file that I download from a web page during the test.
"What I would like it to do is compare an existing Excel file with an Excel file that I download from a web page during the test." - you did say "file".
Use DDT.ExcelDriver Method, create a function to loop through each worksheet and compare values.
That's going to entail you writing your own custom comparison routine. Your best bet is to, as @rraghvani mentioned, use the DDT.ExcelDriver object to read and compare the two sheets.
[Hall of Fame]
Please consider giving a Kudo if I write good stuff
Why automate? I do automated testing because there's only so much a human being can do and remain healthy. Sleep is a requirement. So, while people sleep, automation that I create does what I've described above in order to make sure that nothing gets past the final defense of the testing group.
I love good food, good books, good friends, and good fun.
Mysterious Gremlin Master
Vegas Thrill Rider