Hi i am new to this forum...i want to compare two excel sheets row wise..here i want to take one row from first excel sheet and compare with all rows in another excel sheet.if any of the row from first sheet completely matches with any of the rows in second excel sheet then it shoud give report like yes or matching with this row like that in any one of the excel sheet...can anyone help me in this

thanks in advance.....

I am not aware of existing tools/code to do that. But if you are using apache POI and want to do it on your own, you can do like as follows
1. Extends HSSFRow class and override equals() method and implement your code to compare two rows. OR write a utility method in your existing class which take two HSSFRow object and compares two rows, returns true if they are equal else false.
2. Use HSSFSheet.rowIterator() to get the rows and loop through the rows of your document and call the equals() OR the utility method to compare

Hope it gives some start to solve your problem.

__________________
- Rakesh
http://iam-rakesh.blogspot.com

thank you for the response...will try in that way

do i need any jar file for using poi
if in case i have to use where can i get that jar files?????


thanks in advance

check this link

http://poi.apache.org/

__________________
- Rakesh
http://iam-rakesh.blogspot.com