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
"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.
You can compare two Excel files with CheckExcelWorkbook Method.
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.
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.
