cancel
Showing results for 
Search instead for 
Did you mean: 

How to Compare two excel sheets

VenkatRamana
Level 3
Can any one help me on below scenario.   we need to compare two Excel sheets. Ant idea on - how to implement.   Thanks in advance        
3 REPLIES 3

RonAng
Level 5
Compare in what sense? What differences are you looking for?

VenkatRamana
Level 3
yeah I want mismatches from my master sheet. here is my scenario  - should export data from sap (export as a spread sheet) and internally we have one master sheet. so i have to compare these two and should report mismatches.   any clue.   thanks in advance  

TomaszAdamski
Level 5
Maybe importing the sheets to collections and then comparing field by field, row by row?