sathishi kumarar wrote:Is this is the only way to check for duplicates or we can use any Logic inside the JAVA Code for checking duplicate records.
Well, first you need to have a "record" (by which I presume you mean an Excel row). If you're using Apache POI, you need to find out if it already has such a class (I suspect it does).
Second, you need some way to check if they are "equal", and again, POI may be able to do that for you already.
Alternatively, you could write your own Record class (maybe as a wrapper to POI's own, if it has one), create an equals() and hashCode() method for it, and try loading the entire spreadsheet into a HashSet. That'll soon highlight any "duplicates" you have.
Isn't it funny how there's always time and money enough to do it WRONG?
Articles by Winston can be found here
subject: Source code for removing duplicate records in the excel sheet !!