Comparing the contents of Excel file(expected val)
In my application we have to compare the contents of Excel (which has expected values) with the values in my application.
As i am using Data Driven framework is that better if i take my actual values into one array and expected values into one array and compare both?, Or is that better way if i create a virtual sheet and put my actual contents into that and compare my Expected values sheet and Actual values sheet?
Krishna, I have a suite(devloped some time back) where logic is to convert all excel and webtable data into text files and then compare them which takes time.
Am looking at replacing the idea of creating text files and using pure array comparison, as Tarun says it does work fast, but then you may to include a case to create excel with actual data in case the comparison fails.