Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Comparing two excel files
#1
Solved: 10 Years, 9 Months ago
Hi guys...
i want to comapre two excel files.
the requirements for that are as follows.
1. First get the sheet count in both files if the count is not equal then exit and print the result.
2. copare the row count and column count
3. have to comapre the fonts,cell color,image etc.
4. have to compare the data in the files(row wise)
Note # wherever it fails then immediately it should show the error output and exit from run.

i have seperate code to get the count of sheets, and comparison of cell by cell that too for comparing excels having single sheet....
any one know how to do this?
please let me know....
thanks in advance
Reply


Messages In This Thread
Comparing two excel files - by Sathiya - 09-26-2011, 12:25 PM
RE: Comparing two excel files - by rajpes - 09-26-2011, 03:58 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  UFT taking different script execution timings while comparing 2 excel files. sudheer 0 2,218 06-26-2015, 03:28 PM
Last Post: sudheer
  Comparing webtable data with weblist and webelements in other webpage arnav 1 5,596 04-18-2014, 10:01 PM
Last Post: Parke
  Comparing two excel Sheets whose columns names vary Divya Roopa 2 8,282 03-26-2014, 07:20 PM
Last Post: Parke
  QTP Should open files(say txt files) it can be n number from a folder. Shiv Y 1 2,528 12-18-2013, 01:45 AM
Last Post: mlkrqtp
  Launch n-times QTP Test with different Excel Files nacchio 3 3,437 11-08-2011, 03:34 PM
Last Post: ravi.gajul

Forum Jump:


Users browsing this thread: 1 Guest(s)