RE: java.lang.NullPointerException at utility.ExcelUtils.getRowCount( at executionEngine.DriverScript.execute_TestCase( at executionEngine.DriverScript.main(

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?

at utility.ExcelUtils.getRowCount(
at executionEngine.DriverScript.execute_TestCase(
at executionEngine.DriverScript.main(


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

Hi , i am facing same issue. the method array is not loading the methods from ActionKeywords class.
The method array is null. below is the code. Can you please provide solution.
Thank you.

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");
//Hard coded values are used for Excel row & columns for now

//In later chapters we will replace these hard coded values with varibales

//This is the loop for reading the values of the column 3 (Action Keyword) row by row
for (int iRow=1;iRow<=7;iRow++){

//Storing the value of excel cell in sActionKeyword string variable
String sActionKeyword = ExcelUtils.getCellData(iRow, 3);


//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


//In case of match found, it will execute the matched method


//Once any method is executed, this break statement will take the flow outside of for loop





Default Answered on April 15, 2015.
Add Comment

Your Answer

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