facing diffculties while comparing two excel sheet using poi

[anish reddy]

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]

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]

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]

Thank you so much Anish.
My e-mail id is [e-mail].
If you can send the code, that would be really great.