aspose file tools*
The moose likes Other Open Source Projects and the fly likes facing diffculties while comparing two excel sheet using poi Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "facing diffculties while comparing two excel sheet using poi" Watch "facing diffculties while comparing two excel sheet using poi" New topic
Author

facing diffculties while comparing two excel sheet using poi

anish reddy
Ranch Hand

Joined: Apr 19, 2008
Posts: 74
hi all
i have a task to compare excel sheets,that should be generic,so that at run time it can be any excel file.
i have written a code which checks rows and cells based on which i have written a logic to check one row with other row ie cells in it also.
if they are differnt ,then color with blue in both cells.
if they are same ,color it with common color.
but my problem is if sheet contain empty rows it is not giving proper count ie getPhysicalNumberOfRows(),pSheet.getLastRowNum() which is not counting empty row.
similarly cell if there is a row with cells ie last two cells of a row are empty its showing 1 less count i used both methods but not getting proper cell count ie
.getLastCellNum(),getPhysicalNumberOfCells().

please give me idea for proper row count and cells,where my logic depends on it.

or code snippets to compare to excel sheets.


please give your inputs regarding the above.
Savitha Srinivasan
Greenhorn

Joined: Sep 09, 2013
Posts: 2
Hi Anish,
I am a QA engineer and i need help in writing java code for comparing two excel reports as part of our automation exercise.
If you can please share your code, that will be really useful to me. The excel reports don't have empty rows, so your original code should work for me.

Thanks in advance,
Savitha
anish reddy
Ranch Hand

Joined: Apr 19, 2008
Posts: 74
i developed this component some year back.


i am not able to post the source code i developed .
if you want can you post your email id i will send to that.

Savitha Srinivasan
Greenhorn

Joined: Sep 09, 2013
Posts: 2
Thank you so much Anish.
My e-mail id is mail2savi@gmail.com.
If you can send the code, that would be really great.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: facing diffculties while comparing two excel sheet using poi