How work Excel Checkpoint?

[lodecesa]

Hi,

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.

Thanks

[rraghvani]

You can compare two Excel files with CheckExcelWorkbook Method.

[lodecesa]

---

@rraghvani wrote:

You can compare two Excel files with CheckExcelWorkbook Method.

---

I want to compare only two sheets from the two Excel files, that is to compare Sheet1 of Excel file A with Sheet3 of Excel file B.

[rraghvani]

"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.

[tristaanogre]

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.