Sounds like you're stuck on how to compare. What kinds of differences are you looking for?
Sheet 1 has a row that sheet 2 does not? Sheet 2 has a column that sheet 2 does not? Sheet 1 has more cells in a named range? Sheet 1 has a different value in one cell? Different formulae? Values? Colors? Column width?
Ok, I got a bit silly there, but can you narrow it down some?
A good question is never answered. It is not a bolt to be tightened into place but a seed to be planted and to bear more seed toward the hope of greening the landscape of the idea. John Ciardi
Joined: Jul 12, 2005
No, i want To compare the Two Excel Files with difference of columns and row data
suppose one excel file 1st row and 1st column value is "Anil"
in Second Excel file ist row nad ist column value is "Anil Kumar"
then in Log file should have the where the differenece in the two files i.e
first file 1st row-1st column --Anil Second file 1st row -1st column ---Anil Kumar Vice versa
Joined: Jan 29, 2003
I have no idea what kind of data structures you have after you read from Excel, but the basic compare might be as simple as:
I asked about finding missing or extra rows because comparing two sorted lists has a different technique.
Note you might have to mix these - when you find matching keys in a sorted list then compare all the columns.
As of now I am doing the xls comparison throug field by field. I mean to say From xls A I will pick the firest Row & from xls B i will pick one row. After getting the data I will do field by field comparison.
So currently I am following that way.
I just wanted to ask Is there any alternative solution for the same?