Comparing two excel sheets using Selenium WebDriver with Java using Apache POI

Dear All. I have two excel work books to compare. Each excel has more than 10 columns.
If the value in Cell 1 of Column A in Sheet 1 IS EQUAL TO the value in Cell 1 of Column A in sheet 2 then I have to check Cell 1 of Column B in sheet 1 with Cell 1 of Column B in sheet 2 and so on.
If the value in Cell 1 of Column A in Sheet 1 IS NOT EQUAL TO the value in Cell 1 of Column A in Sheet 2 then i have to check the value of Cell 1 of Column A in Sheet 1 with Cell 2 of Column A in Sheet 2 and so on.

Have to display the mismatched values in another sheet or highlight the mismatched row.
Kindly provide a sample code for this.

Also i have another doubt. Could you please guide me on how to get the length of a value in a particular cell of an excel sheet. Eg. I would like to get a value of Cell 1, Row 2 then i can use System.out.println(“required cell”). its working fine for me. If i would like to get the length of that cell, how to get it.

Sample Code of mine:

FileInputStream f1 = new FileInputStream(“D://Excel1.xls”);
FileInputStream f2 = new FileInputStream(“D://Excel2.xls”);
Workbook wb1 = WorkbookFactory.create(f1);
Sheet sh1 = wb1.getSheet(“Sheet1”);
Workbook wb2 = WorkbookFactory.create(f2);
Sheet sh2 = wb2.getSheet(“Sheet2”);

for (int i = 2; i<7; i++){
Row row1=sh1.getRow(i);
Cell cell1 = row1.getCell(6);
System.out.println(cell1);{
for (int j = 5; j<10; j++){
Row row2=sh2.getRow(j);
Cell cell2 = row2.getCell(26);
System.out.println(cell2);
//Above syso will display the value of that cell. How to get the length of that cell.
if(cell1 == cell2){
System.out.println(“True”);
}else{
System.out.println(“False”);
}

Thanks in advance.
Raj.

Default Asked on September 4, 2015 in Selenium WebDriver.

probably you can put the cell values in String variables and compare for easy access.

on September 6, 2015.
Add Comment
  • 0 Answer(s)
  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.