RE: java.lang.NullPointerException at utility.ExcelUtils.getRowCount(ExcelUtils.java:49) at executionEngine.DriverScript.execute_TestCase(DriverScript.java:50) at executionEngine.DriverScript.main(DriverScript.java:45)

Hi,
Thank you so much for providing the knowledge.

When I run the selenium keyword driven frame work I am getting  the below mentioned error.How to fix this issue?

java.lang.NullPointerException
at utility.ExcelUtils.getRowCount(ExcelUtils.java:49)
at executionEngine.DriverScript.execute_TestCase(DriverScript.java:50)
at executionEngine.DriverScript.main(DriverScript.java:45)

Regards
Anju

Anju Default Asked on January 21, 2015 in Selenium WebDriver.
Add Comment
3 Answers

Hi, got solution. here is the code.

 package executionEngine;
import config.ActionKeywords;
 import utility.ExcelUtils;
 import java.lang.reflect.*;
public class DriverScript {
public static ActionKeywords actionKeywords;
 public static String sActionKeyword;
//This is reflection class object, declared as 'public static'
 //So that it can be used outside the scope of main[] method
public static Method method[];
//Here we are instantiating a new object of class 'ActionKeywords'
public DriverScript() throws NoSuchMethodException, SecurityException{
 actionKeywords = new ActionKeywords();
//This will load all the methods of the class 'ActionKeywords' in it.
 //It will be like array of method, use the break point here and do the watch
method =actionKeywords.getClass().getMethods();
}
public static void main(String[] args) throws Exception {
 // Declaring the path of the Excel file with the name of the Excel file
String sPath = "D://WorkspaceOne//KeyWordFramework//src//dataEngine//DataEngine.xlsx";
// Here we are passing the Excel path and SheetName as arguments to connect with Excel file
ExcelUtils.setExcelFile(sPath, "Test Steps");
 
DriverScript startEngine = new DriverScript();
 startEngine.execute_TestCase();
}
private void execute_TestCase() throws Exception {
for (int iRow=1;iRow<=7;iRow++){
 //Storing the value of excel cell in sActionKeyword string variable
 sActionKeyword = ExcelUtils.getCellData(iRow, 3);
execute_Actions();
 }
 }
//This method contains the code to perform some action
 //As it is completely different set of logic, which revolves around the action only,
 //It makes sense to keep it separate from the main driver script
 //This is to execute test step (Action)
 private static void execute_Actions() throws Exception {
 //This is a loop which will run for the number of actions in the Action Keyword class
 //method variable contain all the method and method.length returns the total number of methods
 //int totalmethods=method.length;
for(int i = 0;i < method.length;i++){
 //System.out.println(method[i]);
//This is now comparing the method name with the ActionKeyword value got from excel
 if(method[i].getName().equals(sActionKeyword)){
 //In case of match found, it will execute the matched method
 method[i].invoke(actionKeywords);
 //Once any method is executed, this break statement will take the flow outside of for loop
 break;
}
 }
 }
 }
 
Default Answered on April 15, 2015.

thank u so much for the solution provided.
It worked.

on November 30, 2016.
Add Comment

Your Answer

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