In case it is a simple format consider using JDBC-ODBC bridge and acess the excel sheet as though you are acessing DB's and comparing tables using JDBC API.
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
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.
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
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?
Is this the real life? Is this just fantasy? Is this a tiny ad?