Null Pointer Exception while reading from excel? [duplicate]

Question

public class ExecuteTest {
@Test

public void testLogin() throws Exception {
    // TODO Auto-generated method stub
`WebDriver webdriver = new FirefoxDriver();

ReadExcelFile file = new ReadExcelFile();
ReadObject object = new ReadObject();
Properties allObjects = object.getObjectRepository();
UIOperation operation = new UIOperation(webdriver);
//Read keyword sheet
Sheet RDSheet = file.readExcel(System.getProperty("user.dir")+"\\","TestCase.xlsx" , "KeywordFramework");
//Find number of rows in excel file
int rowCount =        //Loop over all the rows RDSheet.getLastRowNum()-RDSheet.getFirstRowNum();
    //Create a loop over all the rows of excel file to read it
    for (int i = 1; i < rowCount+1; i++) {
        Row row = RDSheet.getRow(i);
        //Check if the first cell contain a value, if yes, That means it is the new testcase name
    if(row.getCell(0).toString().length()==0){
        //Print testcase detail on console
        System.out.println(row.getCell(1).toString()+"----"+ row.getCell(2).toString()+"----"+
        row.getCell(3).toString()+"----"+ row.getCell(4).toString());
        //Call perform function to perform operation on UI
        operation.perform(allObjects, row.getCell(1).toString(), row.getCell(2).toString(),
                row.getCell(3).toString(), row.getCell(4).toString());
     }
else{

//Print the new testcase name when it started
            System.out.println("New Testcase->"+row.getCell(0).toString() +" Started");
            }
}
}
}

getting null pointer exception when first cell is empty. I have searched many blogs but couldn't find any solution can anyone please help me with code.

What did you understand about a NullPointerException when you read about them? What's the confusion? Can you read a stack trace? Where is the stack trace? Did you try debugging with a debugger? — Kon
– Kon, Commented May 29, 2015 at 16:11
if a cell is empty and you want the info it returns null. add a condition ( variable != null) to avoid NullPointerException — Uma Kanth
– Uma Kanth, Commented May 29, 2015 at 16:12
@Uma Lakshmi Kanth row.getCell(0) is empty cell. I want to navigate to next cell i.e getCell(1) to print the values.can you please help me with code — Ron
– Ron, Commented May 29, 2015 at 16:14
String x = row.getCell(0); if(x != null) {//do stuff} x = row.getCell(1); if(x! = null){//do your stuff} — Uma Kanth
– Uma Kanth, Commented May 29, 2015 at 16:19

Uma Kanth · Accepted Answer · 2015-05-29 16:23:15Z

1

for every .toString() add a " "+ x.toString() to it, so that the value doesnt become a null. `

for (int i = 1; i < rowCount+1; i++) {
        Row row = RDSheet.getRow(i);
        //Check if the first cell contain a value, if yes, That means it is the new testcase name
    if((row.getCell(0)+"").toString().length()==0){
        //Print testcase detail on console
        System.out.println((row.getCell(1)+"").toString()+"----"+ (row.getCell(2)+"").toString()+"----"+
        (row.getCell(3)+"").toString()+"----"+ (row.getCell(4)+"").toString());
        //Call perform function to perform operation on UI
        //your operations
     }
else{

//Print the new testcase name when it started
            System.out.println("New Testcase->"+row.getCell(0).toString() +" Started");
            }
}


`

answered May 29, 2015 at 16:23

Uma Kanth

5,6292 gold badges22 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Naman Gala Over a year ago

Refering this answer, row.getCell(0)+"" will result in string null. So the length value will be 4 instead of 0. @Ron make sure you debug your code and check weather it is working as expected.

Uma Kanth Over a year ago

This is not the case. Even I had the same problem, I did the same and it worked for me. @Naman Gala

Community · Accepted Answer · 2017-05-23 12:16:21Z

1

Make sure you add a null check before using toString() method otherwise you will get NPE if the value is null.

if (row.getCell(0) != null) {
     row.getCell(0).toString() //in this case you are trying to call toString on null value.
}

Refer this SO question

edited May 23, 2017 at 12:16

CommunityBot

11 silver badge

answered May 29, 2015 at 16:15

Naman Gala

4,6901 gold badge25 silver badges57 bronze badges

Comments

KiranVegi · Accepted Answer · 2016-09-08 13:44:48Z

try below Code its working fine for me, we cannot define length of a Null

if(row.getCell(0)==null){
            //Print testcase detail on console
//System.out.println("testing");
            System.out.println(row.getCell(1)+"----"+ row.getCell(2)+"----"+
                row.getCell(3)+"----"+ row.getCell(4));
            //Call perform function to perform operation on UI
            try{
                operation.perform(allObjects, row.getCell(1)==null?"Not a Valid KeyWord":row.getCell(1).toString(), 
                        row.getCell(2)==null?null:row.getCell(2).toString(),
                                row.getCell(3)==null?null:row.getCell(3).toString(), 
                                        row.getCell(4)==null?null:row.getCell(4).toString());
            }catch(Exception e)
            {
                //will print Error Row and break the flow
                System.out.println(i);
                System.out.println(e);
                break;
            }
     }
        else{
            //Print the new testcase name when it started
                System.out.println("New Testcase->"+row.getCell(0) +" Started");
            }
        }

Collectives™ on Stack Overflow

Null Pointer Exception while reading from excel? [duplicate]

3 Answers 3

2 Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Linked

Related