unable to handle blank cells while reading blank cell from excel in selenium?null pointer exception_using java selenium webdriver with TestNGNull pointer exception in selenium webdriver - TestNG - PageFactoryGetting NullPointerException for method Invocation in TestNGI am trying to get data from excel sheet and pass those test data into the login & password field but I am getting following errorSelenium pageFactory NullPointerException for driverData provider mismatch in Selenium with TestNGGetting NullPointeException while running the Selenium test scriptCucumber testng runner failsGetting “java.lang.NullPointerException” upon execution of selenium scriptunable to click on paper button using selenium web driver

Professor falsely accusing me of cheating in a class he does not teach, two months after end of the class. What precautions should I take?

Machine learning and operations research projects

Print the last, middle and first character of your code

Is Trump personally blocking people on Twitter?

How to find the shape parameters of of a beta distribution given the position of two quantiles?

ESTA: "Is your travel to the US occurring in transit to another country?" when going on a cruise

What explains 9 speed cassettes price differences?

How can I deal with a player trying to insert real-world mythology into my homebrew setting?

Reducing using/foreach/using nesting with a helper extension

Who has taken "my" Managed package namespace? Can we find out?

What does "un pareil soin" mean here?

Received a dinner invitation through my employer's email, is it ok to attend?

How to (graphically) present computational results?

What species of wasp is this? And how to get rid of them?

Shortest distance around a pyramid?

The monorail explodes before I can get on it

Are unclear "take-it or leave-it" contracts interpreted in my favor?

Was I subtly told to resign?

Why are Hobbits so fond of mushrooms?

How do Windows version numbers work?

Referring to different instances of the same character in time travel

Single word for "refusing to move to next activity unless present one is completed."

What is this welding tool I found in my attic?

For a hashing function like MD5, how similar can two plaintext strings be and still generate the same hash?



unable to handle blank cells while reading blank cell from excel in selenium?


null pointer exception_using java selenium webdriver with TestNGNull pointer exception in selenium webdriver - TestNG - PageFactoryGetting NullPointerException for method Invocation in TestNGI am trying to get data from excel sheet and pass those test data into the login & password field but I am getting following errorSelenium pageFactory NullPointerException for driverData provider mismatch in Selenium with TestNGGetting NullPointeException while running the Selenium test scriptCucumber testng runner failsGetting “java.lang.NullPointerException” upon execution of selenium scriptunable to click on paper button using selenium web driver






.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;








0















I am trying to read values for excel but my excel file contains some blank cells when I try to read values for those files using dataprovider then I get nullpointer



Please let me know how to deal with these blank cells in excel file??



Please find my excel file as below:-



excel file



Please find attached my Page object file code as :-



Pageobject file



Please find attached my excelutility code as below:- 



public class XLUtility 

 public static FileInputStream fi;
 public static XSSFWorkbook wb;
 public static XSSFSheet ws;
 public static XSSFRow row;
 public static XSSFCell cell;

 public XLUtility(String xlfile,String xlsheet) throws IOException
 try 
 FileInputStream Excelfile=new FileInputStream(xlfile);
 wb=new XSSFWorkbook(Excelfile);
 ws=wb.getSheet(xlsheet);
 catch (Exception e) 
 e.getMessage();
 e.printStackTrace();
 
 

 public static void setExcelFile(String xlfile,String xlsheet) throws Exception 

 try 
 FileInputStream ExcelFile = new FileInputStream(xlfile);
 wb = new XSSFWorkbook(ExcelFile);
 ws = wb.getSheet(xlsheet);
 catch (Exception e)
 System.out.println("Exception occured is"+e);
 
 

 public int getRowCount() throws IOException 
 
 int rowcount=ws.getLastRowNum();
 return rowcount; 
 

 public int getCellCount(int rownum) 
 row=ws.getRow(rownum);
 int cellcount=row.getLastCellNum();
 return cellcount;
 

 public String getCelldata(int rownum,int colnum) 
 row=ws.getRow(rownum);
 cell=row.getCell(colnum);
 String data;
 try 
 
 DataFormatter formatter = new DataFormatter();
 String cellData = formatter.formatCellValue(cell);
 return cellData;
 
 catch (Exception e) 
 
 data="";
 
 return data;



Please find my test class code as below:-



Test class two



Please find console output as below:- 



[RemoteTestNG] detected TestNG version 6.14.3
FAILED: loginDDT("BlaBla", "")
java.lang.NullPointerException
 at org.openqa.selenium.support.pagefactory.DefaultElementLocator.findElement(DefaultElementLocator.java:69)
 at org.openqa.selenium.support.pagefactory.internal.LocatingElementHandler.invoke(LocatingElementHandler.java:38)
 at com.sun.proxy.$Proxy8.sendKeys(Unknown Source)
 at com.AutomationTest.PageObjects.PageoneObjects.login(PageoneObjects.java:20)
 at com.AutomationTest.Testcases.TC_App_001.loginDDT(TC_App_001.java:25)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:498)
 at org.testng.internal.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:124)
 at org.testng.internal.Invoker.invokeMethod(Invoker.java:583)
 at org.testng.internal.Invoker.invokeTestMethod(Invoker.java:719)
 at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:989)
 at org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:125)
 at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:109)
 at org.testng.TestRunner.privateRun(TestRunner.java:648)
 at org.testng.TestRunner.run(TestRunner.java:505)
 at org.testng.SuiteRunner.runTest(SuiteRunner.java:455)
 at org.testng.SuiteRunner.runSequentially(SuiteRunner.java:450)
 at org.testng.SuiteRunner.privateRun(SuiteRunner.java:415)
 at org.testng.SuiteRunner.run(SuiteRunner.java:364)
 at org.testng.SuiteRunnerWorker.runSuite(SuiteRunnerWorker.java:52)
 at org.testng.SuiteRunnerWorker.run(SuiteRunnerWorker.java:84)
 at org.testng.TestNG.runSuitesSequentially(TestNG.java:1208)
 at org.testng.TestNG.runSuitesLocally(TestNG.java:1137)
 at org.testng.TestNG.runSuites(TestNG.java:1049)
 at org.testng.TestNG.run(TestNG.java:1017)
 at org.testng.remote.AbstractRemoteTestNG.run(AbstractRemoteTestNG.java:115)
 at org.testng.remote.RemoteTestNG.initAndRun(RemoteTestNG.java:251)
 at org.testng.remote.RemoteTestNG.main(RemoteTestNG.java:77)

 FAILED: loginDDT("", "BlaBla")
 java.lang.NullPointerException
 at org.openqa.selenium.support.pagefactory.DefaultElementLocator.findElement(DefaultElementLocator.java:69)
 at org.openqa.selenium.support.pagefactory.internal.LocatingElementHandler.invoke(LocatingElementHandler.java:38)
 at com.sun.proxy.$Proxy8.sendKeys(Unknown Source)
 at com.AutomationTest.PageObjects.PageoneObjects.login(PageoneObjects.java:20)
 at com.AutomationTest.Testcases.TC_App_001.loginDDT(TC_App_001.java:25)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:498)
 at org.testng.internal.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:124)
 at org.testng.internal.Invoker.invokeMethod(Invoker.java:583)
 at org.testng.internal.Invoker.invokeTestMethod(Invoker.java:719)
 at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:989)
 at org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:125)
 at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:109)
 at org.testng.TestRunner.privateRun(TestRunner.java:648)
 at org.testng.TestRunner.run(TestRunner.java:505)
 at org.testng.SuiteRunner.runTest(SuiteRunner.java:455)
 at org.testng.SuiteRunner.runSequentially(SuiteRunner.java:450)
 at org.testng.SuiteRunner.privateRun(SuiteRunner.java:415)
 at org.testng.SuiteRunner.run(SuiteRunner.java:364)
 at org.testng.SuiteRunnerWorker.runSuite(SuiteRunnerWorker.java:52)
 at org.testng.SuiteRunnerWorker.run(SuiteRunnerWorker.java:84)
 at org.testng.TestNG.runSuitesSequentially(TestNG.java:1208)
 at org.testng.TestNG.runSuitesLocally(TestNG.java:1137)
 at org.testng.TestNG.runSuites(TestNG.java:1049)
 at org.testng.TestNG.run(TestNG.java:1017)
 at org.testng.remote.AbstractRemoteTestNG.run(AbstractRemoteTestNG.java:115)
 at org.testng.remote.RemoteTestNG.initAndRun(RemoteTestNG.java:251)
 at org.testng.remote.RemoteTestNG.main(RemoteTestNG.java:77)

 FAILED: loginDDT("BlaBla", "BlaBla")
 java.lang.NullPointerException
 at org.openqa.selenium.support.pagefactory.DefaultElementLocator.findElement(DefaultElementLocator.java:69)
 at org.openqa.selenium.support.pagefactory.internal.LocatingElementHandler.invoke(LocatingElementHandler.java:38)
 at com.sun.proxy.$Proxy8.sendKeys(Unknown Source)
 at com.AutomationTest.PageObjects.PageoneObjects.login(PageoneObjects.java:20)
 at com.AutomationTest.Testcases.TC_App_001.loginDDT(TC_App_001.java:25)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:498)
 at org.testng.internal.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:124)
 at org.testng.internal.Invoker.invokeMethod(Invoker.java:583)
 at org.testng.internal.Invoker.invokeTestMethod(Invoker.java:719)
 at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:989)
 at org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:125)
 at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:109)
 at org.testng.TestRunner.privateRun(TestRunner.java:648)
 at org.testng.TestRunner.run(TestRunner.java:505)
 at org.testng.SuiteRunner.runTest(SuiteRunner.java:455)
 at org.testng.SuiteRunner.runSequentially(SuiteRunner.java:450)
 at org.testng.SuiteRunner.privateRun(SuiteRunner.java:415)
 at org.testng.SuiteRunner.run(SuiteRunner.java:364)
 at org.testng.SuiteRunnerWorker.runSuite(SuiteRunnerWorker.java:52)
 at org.testng.SuiteRunnerWorker.run(SuiteRunnerWorker.java:84)
 at org.testng.TestNG.runSuitesSequentially(TestNG.java:1208)
 at org.testng.TestNG.runSuitesLocally(TestNG.java:1137)
 at org.testng.TestNG.runSuites(TestNG.java:1049)
 at org.testng.TestNG.run(TestNG.java:1017)
 at org.testng.remote.AbstractRemoteTestNG.run(AbstractRemoteTestNG.java:115)
 at org.testng.remote.RemoteTestNG.initAndRun(RemoteTestNG.java:251)
 at org.testng.remote.RemoteTestNG.main(RemoteTestNG.java:77)





selenium-webdriver testng testng-dataprovider







share|improve this question






























    0















    I am trying to read values for excel but my excel file contains some blank cells when I try to read values for those files using dataprovider then I get nullpointer



    Please let me know how to deal with these blank cells in excel file??



    Please find my excel file as below:-



    excel file



    Please find attached my Page object file code as :-



    Pageobject file



    Please find attached my excelutility code as below:- 



    public class XLUtility 

     public static FileInputStream fi;
     public static XSSFWorkbook wb;
     public static XSSFSheet ws;
     public static XSSFRow row;
     public static XSSFCell cell;

     public XLUtility(String xlfile,String xlsheet) throws IOException
     try 
     FileInputStream Excelfile=new FileInputStream(xlfile);
     wb=new XSSFWorkbook(Excelfile);
     ws=wb.getSheet(xlsheet);
     catch (Exception e) 
     e.getMessage();
     e.printStackTrace();
     
     

     public static void setExcelFile(String xlfile,String xlsheet) throws Exception 

     try 
     FileInputStream ExcelFile = new FileInputStream(xlfile);
     wb = new XSSFWorkbook(ExcelFile);
     ws = wb.getSheet(xlsheet);
     catch (Exception e)
     System.out.println("Exception occured is"+e);
     
     

     public int getRowCount() throws IOException 
     
     int rowcount=ws.getLastRowNum();
     return rowcount; 
     

     public int getCellCount(int rownum) 
     row=ws.getRow(rownum);
     int cellcount=row.getLastCellNum();
     return cellcount;
     

     public String getCelldata(int rownum,int colnum) 
     row=ws.getRow(rownum);
     cell=row.getCell(colnum);
     String data;
     try 
     
     DataFormatter formatter = new DataFormatter();
     String cellData = formatter.formatCellValue(cell);
     return cellData;
     
     catch (Exception e) 
     
     data="";
     
     return data;



    Please find my test class code as below:-



    Test class two



    Please find console output as below:- 



    [RemoteTestNG] detected TestNG version 6.14.3
    FAILED: loginDDT("BlaBla", "")
    java.lang.NullPointerException
     at org.openqa.selenium.support.pagefactory.DefaultElementLocator.findElement(DefaultElementLocator.java:69)
     at org.openqa.selenium.support.pagefactory.internal.LocatingElementHandler.invoke(LocatingElementHandler.java:38)
     at com.sun.proxy.$Proxy8.sendKeys(Unknown Source)
     at com.AutomationTest.PageObjects.PageoneObjects.login(PageoneObjects.java:20)
     at com.AutomationTest.Testcases.TC_App_001.loginDDT(TC_App_001.java:25)
     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
     at java.lang.reflect.Method.invoke(Method.java:498)
     at org.testng.internal.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:124)
     at org.testng.internal.Invoker.invokeMethod(Invoker.java:583)
     at org.testng.internal.Invoker.invokeTestMethod(Invoker.java:719)
     at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:989)
     at org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:125)
     at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:109)
     at org.testng.TestRunner.privateRun(TestRunner.java:648)
     at org.testng.TestRunner.run(TestRunner.java:505)
     at org.testng.SuiteRunner.runTest(SuiteRunner.java:455)
     at org.testng.SuiteRunner.runSequentially(SuiteRunner.java:450)
     at org.testng.SuiteRunner.privateRun(SuiteRunner.java:415)
     at org.testng.SuiteRunner.run(SuiteRunner.java:364)
     at org.testng.SuiteRunnerWorker.runSuite(SuiteRunnerWorker.java:52)
     at org.testng.SuiteRunnerWorker.run(SuiteRunnerWorker.java:84)
     at org.testng.TestNG.runSuitesSequentially(TestNG.java:1208)
     at org.testng.TestNG.runSuitesLocally(TestNG.java:1137)
     at org.testng.TestNG.runSuites(TestNG.java:1049)
     at org.testng.TestNG.run(TestNG.java:1017)
     at org.testng.remote.AbstractRemoteTestNG.run(AbstractRemoteTestNG.java:115)
     at org.testng.remote.RemoteTestNG.initAndRun(RemoteTestNG.java:251)
     at org.testng.remote.RemoteTestNG.main(RemoteTestNG.java:77)

     FAILED: loginDDT("", "BlaBla")
     java.lang.NullPointerException
     at org.openqa.selenium.support.pagefactory.DefaultElementLocator.findElement(DefaultElementLocator.java:69)
     at org.openqa.selenium.support.pagefactory.internal.LocatingElementHandler.invoke(LocatingElementHandler.java:38)
     at com.sun.proxy.$Proxy8.sendKeys(Unknown Source)
     at com.AutomationTest.PageObjects.PageoneObjects.login(PageoneObjects.java:20)
     at com.AutomationTest.Testcases.TC_App_001.loginDDT(TC_App_001.java:25)
     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
     at java.lang.reflect.Method.invoke(Method.java:498)
     at org.testng.internal.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:124)
     at org.testng.internal.Invoker.invokeMethod(Invoker.java:583)
     at org.testng.internal.Invoker.invokeTestMethod(Invoker.java:719)
     at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:989)
     at org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:125)
     at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:109)
     at org.testng.TestRunner.privateRun(TestRunner.java:648)
     at org.testng.TestRunner.run(TestRunner.java:505)
     at org.testng.SuiteRunner.runTest(SuiteRunner.java:455)
     at org.testng.SuiteRunner.runSequentially(SuiteRunner.java:450)
     at org.testng.SuiteRunner.privateRun(SuiteRunner.java:415)
     at org.testng.SuiteRunner.run(SuiteRunner.java:364)
     at org.testng.SuiteRunnerWorker.runSuite(SuiteRunnerWorker.java:52)
     at org.testng.SuiteRunnerWorker.run(SuiteRunnerWorker.java:84)
     at org.testng.TestNG.runSuitesSequentially(TestNG.java:1208)
     at org.testng.TestNG.runSuitesLocally(TestNG.java:1137)
     at org.testng.TestNG.runSuites(TestNG.java:1049)
     at org.testng.TestNG.run(TestNG.java:1017)
     at org.testng.remote.AbstractRemoteTestNG.run(AbstractRemoteTestNG.java:115)
     at org.testng.remote.RemoteTestNG.initAndRun(RemoteTestNG.java:251)
     at org.testng.remote.RemoteTestNG.main(RemoteTestNG.java:77)

     FAILED: loginDDT("BlaBla", "BlaBla")
     java.lang.NullPointerException
     at org.openqa.selenium.support.pagefactory.DefaultElementLocator.findElement(DefaultElementLocator.java:69)
     at org.openqa.selenium.support.pagefactory.internal.LocatingElementHandler.invoke(LocatingElementHandler.java:38)
     at com.sun.proxy.$Proxy8.sendKeys(Unknown Source)
     at com.AutomationTest.PageObjects.PageoneObjects.login(PageoneObjects.java:20)
     at com.AutomationTest.Testcases.TC_App_001.loginDDT(TC_App_001.java:25)
     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
     at java.lang.reflect.Method.invoke(Method.java:498)
     at org.testng.internal.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:124)
     at org.testng.internal.Invoker.invokeMethod(Invoker.java:583)
     at org.testng.internal.Invoker.invokeTestMethod(Invoker.java:719)
     at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:989)
     at org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:125)
     at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:109)
     at org.testng.TestRunner.privateRun(TestRunner.java:648)
     at org.testng.TestRunner.run(TestRunner.java:505)
     at org.testng.SuiteRunner.runTest(SuiteRunner.java:455)
     at org.testng.SuiteRunner.runSequentially(SuiteRunner.java:450)
     at org.testng.SuiteRunner.privateRun(SuiteRunner.java:415)
     at org.testng.SuiteRunner.run(SuiteRunner.java:364)
     at org.testng.SuiteRunnerWorker.runSuite(SuiteRunnerWorker.java:52)
     at org.testng.SuiteRunnerWorker.run(SuiteRunnerWorker.java:84)
     at org.testng.TestNG.runSuitesSequentially(TestNG.java:1208)
     at org.testng.TestNG.runSuitesLocally(TestNG.java:1137)
     at org.testng.TestNG.runSuites(TestNG.java:1049)
     at org.testng.TestNG.run(TestNG.java:1017)
     at org.testng.remote.AbstractRemoteTestNG.run(AbstractRemoteTestNG.java:115)
     at org.testng.remote.RemoteTestNG.initAndRun(RemoteTestNG.java:251)
     at org.testng.remote.RemoteTestNG.main(RemoteTestNG.java:77)





    selenium-webdriver testng testng-dataprovider







    share|improve this question


























      0












      0








      0








      I am trying to read values for excel but my excel file contains some blank cells when I try to read values for those files using dataprovider then I get nullpointer



      Please let me know how to deal with these blank cells in excel file??



      Please find my excel file as below:-



      excel file



      Please find attached my Page object file code as :-



      Pageobject file



      Please find attached my excelutility code as below:- 



      public class XLUtility 

       public static FileInputStream fi;
       public static XSSFWorkbook wb;
       public static XSSFSheet ws;
       public static XSSFRow row;
       public static XSSFCell cell;

       public XLUtility(String xlfile,String xlsheet) throws IOException
       try 
       FileInputStream Excelfile=new FileInputStream(xlfile);
       wb=new XSSFWorkbook(Excelfile);
       ws=wb.getSheet(xlsheet);
       catch (Exception e) 
       e.getMessage();
       e.printStackTrace();
       
       

       public static void setExcelFile(String xlfile,String xlsheet) throws Exception 

       try 
       FileInputStream ExcelFile = new FileInputStream(xlfile);
       wb = new XSSFWorkbook(ExcelFile);
       ws = wb.getSheet(xlsheet);
       catch (Exception e)
       System.out.println("Exception occured is"+e);
       
       

       public int getRowCount() throws IOException 
       
       int rowcount=ws.getLastRowNum();
       return rowcount; 
       

       public int getCellCount(int rownum) 
       row=ws.getRow(rownum);
       int cellcount=row.getLastCellNum();
       return cellcount;
       

       public String getCelldata(int rownum,int colnum) 
       row=ws.getRow(rownum);
       cell=row.getCell(colnum);
       String data;
       try 
       
       DataFormatter formatter = new DataFormatter();
       String cellData = formatter.formatCellValue(cell);
       return cellData;
       
       catch (Exception e) 
       
       data="";
       
       return data;



      Please find my test class code as below:-



      Test class two



      Please find console output as below:- 



      [RemoteTestNG] detected TestNG version 6.14.3
      FAILED: loginDDT("BlaBla", "")
      java.lang.NullPointerException
       at org.openqa.selenium.support.pagefactory.DefaultElementLocator.findElement(DefaultElementLocator.java:69)
       at org.openqa.selenium.support.pagefactory.internal.LocatingElementHandler.invoke(LocatingElementHandler.java:38)
       at com.sun.proxy.$Proxy8.sendKeys(Unknown Source)
       at com.AutomationTest.PageObjects.PageoneObjects.login(PageoneObjects.java:20)
       at com.AutomationTest.Testcases.TC_App_001.loginDDT(TC_App_001.java:25)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
       at java.lang.reflect.Method.invoke(Method.java:498)
       at org.testng.internal.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:124)
       at org.testng.internal.Invoker.invokeMethod(Invoker.java:583)
       at org.testng.internal.Invoker.invokeTestMethod(Invoker.java:719)
       at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:989)
       at org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:125)
       at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:109)
       at org.testng.TestRunner.privateRun(TestRunner.java:648)
       at org.testng.TestRunner.run(TestRunner.java:505)
       at org.testng.SuiteRunner.runTest(SuiteRunner.java:455)
       at org.testng.SuiteRunner.runSequentially(SuiteRunner.java:450)
       at org.testng.SuiteRunner.privateRun(SuiteRunner.java:415)
       at org.testng.SuiteRunner.run(SuiteRunner.java:364)
       at org.testng.SuiteRunnerWorker.runSuite(SuiteRunnerWorker.java:52)
       at org.testng.SuiteRunnerWorker.run(SuiteRunnerWorker.java:84)
       at org.testng.TestNG.runSuitesSequentially(TestNG.java:1208)
       at org.testng.TestNG.runSuitesLocally(TestNG.java:1137)
       at org.testng.TestNG.runSuites(TestNG.java:1049)
       at org.testng.TestNG.run(TestNG.java:1017)
       at org.testng.remote.AbstractRemoteTestNG.run(AbstractRemoteTestNG.java:115)
       at org.testng.remote.RemoteTestNG.initAndRun(RemoteTestNG.java:251)
       at org.testng.remote.RemoteTestNG.main(RemoteTestNG.java:77)

       FAILED: loginDDT("", "BlaBla")
       java.lang.NullPointerException
       at org.openqa.selenium.support.pagefactory.DefaultElementLocator.findElement(DefaultElementLocator.java:69)
       at org.openqa.selenium.support.pagefactory.internal.LocatingElementHandler.invoke(LocatingElementHandler.java:38)
       at com.sun.proxy.$Proxy8.sendKeys(Unknown Source)
       at com.AutomationTest.PageObjects.PageoneObjects.login(PageoneObjects.java:20)
       at com.AutomationTest.Testcases.TC_App_001.loginDDT(TC_App_001.java:25)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
       at java.lang.reflect.Method.invoke(Method.java:498)
       at org.testng.internal.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:124)
       at org.testng.internal.Invoker.invokeMethod(Invoker.java:583)
       at org.testng.internal.Invoker.invokeTestMethod(Invoker.java:719)
       at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:989)
       at org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:125)
       at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:109)
       at org.testng.TestRunner.privateRun(TestRunner.java:648)
       at org.testng.TestRunner.run(TestRunner.java:505)
       at org.testng.SuiteRunner.runTest(SuiteRunner.java:455)
       at org.testng.SuiteRunner.runSequentially(SuiteRunner.java:450)
       at org.testng.SuiteRunner.privateRun(SuiteRunner.java:415)
       at org.testng.SuiteRunner.run(SuiteRunner.java:364)
       at org.testng.SuiteRunnerWorker.runSuite(SuiteRunnerWorker.java:52)
       at org.testng.SuiteRunnerWorker.run(SuiteRunnerWorker.java:84)
       at org.testng.TestNG.runSuitesSequentially(TestNG.java:1208)
       at org.testng.TestNG.runSuitesLocally(TestNG.java:1137)
       at org.testng.TestNG.runSuites(TestNG.java:1049)
       at org.testng.TestNG.run(TestNG.java:1017)
       at org.testng.remote.AbstractRemoteTestNG.run(AbstractRemoteTestNG.java:115)
       at org.testng.remote.RemoteTestNG.initAndRun(RemoteTestNG.java:251)
       at org.testng.remote.RemoteTestNG.main(RemoteTestNG.java:77)

       FAILED: loginDDT("BlaBla", "BlaBla")
       java.lang.NullPointerException
       at org.openqa.selenium.support.pagefactory.DefaultElementLocator.findElement(DefaultElementLocator.java:69)
       at org.openqa.selenium.support.pagefactory.internal.LocatingElementHandler.invoke(LocatingElementHandler.java:38)
       at com.sun.proxy.$Proxy8.sendKeys(Unknown Source)
       at com.AutomationTest.PageObjects.PageoneObjects.login(PageoneObjects.java:20)
       at com.AutomationTest.Testcases.TC_App_001.loginDDT(TC_App_001.java:25)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
       at java.lang.reflect.Method.invoke(Method.java:498)
       at org.testng.internal.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:124)
       at org.testng.internal.Invoker.invokeMethod(Invoker.java:583)
       at org.testng.internal.Invoker.invokeTestMethod(Invoker.java:719)
       at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:989)
       at org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:125)
       at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:109)
       at org.testng.TestRunner.privateRun(TestRunner.java:648)
       at org.testng.TestRunner.run(TestRunner.java:505)
       at org.testng.SuiteRunner.runTest(SuiteRunner.java:455)
       at org.testng.SuiteRunner.runSequentially(SuiteRunner.java:450)
       at org.testng.SuiteRunner.privateRun(SuiteRunner.java:415)
       at org.testng.SuiteRunner.run(SuiteRunner.java:364)
       at org.testng.SuiteRunnerWorker.runSuite(SuiteRunnerWorker.java:52)
       at org.testng.SuiteRunnerWorker.run(SuiteRunnerWorker.java:84)
       at org.testng.TestNG.runSuitesSequentially(TestNG.java:1208)
       at org.testng.TestNG.runSuitesLocally(TestNG.java:1137)
       at org.testng.TestNG.runSuites(TestNG.java:1049)
       at org.testng.TestNG.run(TestNG.java:1017)
       at org.testng.remote.AbstractRemoteTestNG.run(AbstractRemoteTestNG.java:115)
       at org.testng.remote.RemoteTestNG.initAndRun(RemoteTestNG.java:251)
       at org.testng.remote.RemoteTestNG.main(RemoteTestNG.java:77)





      selenium-webdriver testng testng-dataprovider







      share|improve this question
















      I am trying to read values for excel but my excel file contains some blank cells when I try to read values for those files using dataprovider then I get nullpointer



      Please let me know how to deal with these blank cells in excel file??



      Please find my excel file as below:-



      excel file



      Please find attached my Page object file code as :-



      Pageobject file



      Please find attached my excelutility code as below:- 



      public class XLUtility 

       public static FileInputStream fi;
       public static XSSFWorkbook wb;
       public static XSSFSheet ws;
       public static XSSFRow row;
       public static XSSFCell cell;

       public XLUtility(String xlfile,String xlsheet) throws IOException
       try 
       FileInputStream Excelfile=new FileInputStream(xlfile);
       wb=new XSSFWorkbook(Excelfile);
       ws=wb.getSheet(xlsheet);
       catch (Exception e) 
       e.getMessage();
       e.printStackTrace();
       
       

       public static void setExcelFile(String xlfile,String xlsheet) throws Exception 

       try 
       FileInputStream ExcelFile = new FileInputStream(xlfile);
       wb = new XSSFWorkbook(ExcelFile);
       ws = wb.getSheet(xlsheet);
       catch (Exception e)
       System.out.println("Exception occured is"+e);
       
       

       public int getRowCount() throws IOException 
       
       int rowcount=ws.getLastRowNum();
       return rowcount; 
       

       public int getCellCount(int rownum) 
       row=ws.getRow(rownum);
       int cellcount=row.getLastCellNum();
       return cellcount;
       

       public String getCelldata(int rownum,int colnum) 
       row=ws.getRow(rownum);
       cell=row.getCell(colnum);
       String data;
       try 
       
       DataFormatter formatter = new DataFormatter();
       String cellData = formatter.formatCellValue(cell);
       return cellData;
       
       catch (Exception e) 
       
       data="";
       
       return data;



      Please find my test class code as below:-



      Test class two



      Please find console output as below:- 



      [RemoteTestNG] detected TestNG version 6.14.3
      FAILED: loginDDT("BlaBla", "")
      java.lang.NullPointerException
       at org.openqa.selenium.support.pagefactory.DefaultElementLocator.findElement(DefaultElementLocator.java:69)
       at org.openqa.selenium.support.pagefactory.internal.LocatingElementHandler.invoke(LocatingElementHandler.java:38)
       at com.sun.proxy.$Proxy8.sendKeys(Unknown Source)
       at com.AutomationTest.PageObjects.PageoneObjects.login(PageoneObjects.java:20)
       at com.AutomationTest.Testcases.TC_App_001.loginDDT(TC_App_001.java:25)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
       at java.lang.reflect.Method.invoke(Method.java:498)
       at org.testng.internal.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:124)
       at org.testng.internal.Invoker.invokeMethod(Invoker.java:583)
       at org.testng.internal.Invoker.invokeTestMethod(Invoker.java:719)
       at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:989)
       at org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:125)
       at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:109)
       at org.testng.TestRunner.privateRun(TestRunner.java:648)
       at org.testng.TestRunner.run(TestRunner.java:505)
       at org.testng.SuiteRunner.runTest(SuiteRunner.java:455)
       at org.testng.SuiteRunner.runSequentially(SuiteRunner.java:450)
       at org.testng.SuiteRunner.privateRun(SuiteRunner.java:415)
       at org.testng.SuiteRunner.run(SuiteRunner.java:364)
       at org.testng.SuiteRunnerWorker.runSuite(SuiteRunnerWorker.java:52)
       at org.testng.SuiteRunnerWorker.run(SuiteRunnerWorker.java:84)
       at org.testng.TestNG.runSuitesSequentially(TestNG.java:1208)
       at org.testng.TestNG.runSuitesLocally(TestNG.java:1137)
       at org.testng.TestNG.runSuites(TestNG.java:1049)
       at org.testng.TestNG.run(TestNG.java:1017)
       at org.testng.remote.AbstractRemoteTestNG.run(AbstractRemoteTestNG.java:115)
       at org.testng.remote.RemoteTestNG.initAndRun(RemoteTestNG.java:251)
       at org.testng.remote.RemoteTestNG.main(RemoteTestNG.java:77)

       FAILED: loginDDT("", "BlaBla")
       java.lang.NullPointerException
       at org.openqa.selenium.support.pagefactory.DefaultElementLocator.findElement(DefaultElementLocator.java:69)
       at org.openqa.selenium.support.pagefactory.internal.LocatingElementHandler.invoke(LocatingElementHandler.java:38)
       at com.sun.proxy.$Proxy8.sendKeys(Unknown Source)
       at com.AutomationTest.PageObjects.PageoneObjects.login(PageoneObjects.java:20)
       at com.AutomationTest.Testcases.TC_App_001.loginDDT(TC_App_001.java:25)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
       at java.lang.reflect.Method.invoke(Method.java:498)
       at org.testng.internal.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:124)
       at org.testng.internal.Invoker.invokeMethod(Invoker.java:583)
       at org.testng.internal.Invoker.invokeTestMethod(Invoker.java:719)
       at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:989)
       at org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:125)
       at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:109)
       at org.testng.TestRunner.privateRun(TestRunner.java:648)
       at org.testng.TestRunner.run(TestRunner.java:505)
       at org.testng.SuiteRunner.runTest(SuiteRunner.java:455)
       at org.testng.SuiteRunner.runSequentially(SuiteRunner.java:450)
       at org.testng.SuiteRunner.privateRun(SuiteRunner.java:415)
       at org.testng.SuiteRunner.run(SuiteRunner.java:364)
       at org.testng.SuiteRunnerWorker.runSuite(SuiteRunnerWorker.java:52)
       at org.testng.SuiteRunnerWorker.run(SuiteRunnerWorker.java:84)
       at org.testng.TestNG.runSuitesSequentially(TestNG.java:1208)
       at org.testng.TestNG.runSuitesLocally(TestNG.java:1137)
       at org.testng.TestNG.runSuites(TestNG.java:1049)
       at org.testng.TestNG.run(TestNG.java:1017)
       at org.testng.remote.AbstractRemoteTestNG.run(AbstractRemoteTestNG.java:115)
       at org.testng.remote.RemoteTestNG.initAndRun(RemoteTestNG.java:251)
       at org.testng.remote.RemoteTestNG.main(RemoteTestNG.java:77)

       FAILED: loginDDT("BlaBla", "BlaBla")
       java.lang.NullPointerException
       at org.openqa.selenium.support.pagefactory.DefaultElementLocator.findElement(DefaultElementLocator.java:69)
       at org.openqa.selenium.support.pagefactory.internal.LocatingElementHandler.invoke(LocatingElementHandler.java:38)
       at com.sun.proxy.$Proxy8.sendKeys(Unknown Source)
       at com.AutomationTest.PageObjects.PageoneObjects.login(PageoneObjects.java:20)
       at com.AutomationTest.Testcases.TC_App_001.loginDDT(TC_App_001.java:25)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
       at java.lang.reflect.Method.invoke(Method.java:498)
       at org.testng.internal.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:124)
       at org.testng.internal.Invoker.invokeMethod(Invoker.java:583)
       at org.testng.internal.Invoker.invokeTestMethod(Invoker.java:719)
       at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:989)
       at org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:125)
       at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:109)
       at org.testng.TestRunner.privateRun(TestRunner.java:648)
       at org.testng.TestRunner.run(TestRunner.java:505)
       at org.testng.SuiteRunner.runTest(SuiteRunner.java:455)
       at org.testng.SuiteRunner.runSequentially(SuiteRunner.java:450)
       at org.testng.SuiteRunner.privateRun(SuiteRunner.java:415)
       at org.testng.SuiteRunner.run(SuiteRunner.java:364)
       at org.testng.SuiteRunnerWorker.runSuite(SuiteRunnerWorker.java:52)
       at org.testng.SuiteRunnerWorker.run(SuiteRunnerWorker.java:84)
       at org.testng.TestNG.runSuitesSequentially(TestNG.java:1208)
       at org.testng.TestNG.runSuitesLocally(TestNG.java:1137)
       at org.testng.TestNG.runSuites(TestNG.java:1049)
       at org.testng.TestNG.run(TestNG.java:1017)
       at org.testng.remote.AbstractRemoteTestNG.run(AbstractRemoteTestNG.java:115)
       at org.testng.remote.RemoteTestNG.initAndRun(RemoteTestNG.java:251)
       at org.testng.remote.RemoteTestNG.main(RemoteTestNG.java:77)





      selenium-webdriver testng testng-dataprovider




      selenium-webdriver testng testng-dataprovider






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Mar 26 at 3:49







      keshav dwivedi

















      asked Mar 26 at 3:18









      keshav dwivedikeshav dwivedi

      287 bronze badges




      287 bronze badges






















          1 Answer
          1






          active

          oldest

          votes


















          0














          when reading for cell, need to cross check cell type. like below



           public String getCellData(String sheetName,int colNum,int rowNum)
           try
           catch(Exception e)

           e.printStackTrace();
           return "row "+rowNum+" or column "+colNum +" does not exist in xls";






          share|improve this answer






















            Your Answer






            StackExchange.ifUsing("editor", function ()
            StackExchange.using("externalEditor", function ()
            StackExchange.using("snippets", function ()
            StackExchange.snippets.init();
            );
            );
            , "code-snippets");

            StackExchange.ready(function()
            var channelOptions =
            tags: "".split(" "),
            id: "1"
            ;
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function()
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled)
            StackExchange.using("snippets", function()
            createEditor();
            );

            else
            createEditor();

            );

            function createEditor()
            StackExchange.prepareEditor(
            heartbeatType: 'answer',
            autoActivateHeartbeat: false,
            convertImagesToLinks: true,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: 10,
            bindNavPrevention: true,
            postfix: "",
            imageUploader:
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            ,
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            );



            );













            draft saved

            draft discarded


















            StackExchange.ready(
            function ()
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55349355%2funable-to-handle-blank-cells-while-reading-blank-cell-from-excel-in-selenium%23new-answer', 'question_page');

            );

            Post as a guest















            Required, but never shown

























            1 Answer
            1






            active

            oldest

            votes








            1 Answer
            1






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes









            0














            when reading for cell, need to cross check cell type. like below



             public String getCellData(String sheetName,int colNum,int rowNum)
             try
             catch(Exception e)

             e.printStackTrace();
             return "row "+rowNum+" or column "+colNum +" does not exist in xls";






            share|improve this answer



























              0














              when reading for cell, need to cross check cell type. like below



               public String getCellData(String sheetName,int colNum,int rowNum)
               try
               catch(Exception e)

               e.printStackTrace();
               return "row "+rowNum+" or column "+colNum +" does not exist in xls";






              share|improve this answer

























                0












                0








                0







                when reading for cell, need to cross check cell type. like below



                 public String getCellData(String sheetName,int colNum,int rowNum)
                 try
                 catch(Exception e)

                 e.printStackTrace();
                 return "row "+rowNum+" or column "+colNum +" does not exist in xls";






                share|improve this answer













                when reading for cell, need to cross check cell type. like below



                 public String getCellData(String sheetName,int colNum,int rowNum)
                 try
                 catch(Exception e)

                 e.printStackTrace();
                 return "row "+rowNum+" or column "+colNum +" does not exist in xls";







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Mar 26 at 6:21









                murali seleniummurali selenium

                3,3262 gold badges7 silver badges18 bronze badges




                3,3262 gold badges7 silver badges18 bronze badges


















                    Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.







                    Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.



















                    draft saved

                    draft discarded
















































                    Thanks for contributing an answer to Stack Overflow!


                    • Please be sure to answer the question. Provide details and share your research!

                    But avoid …


                    • Asking for help, clarification, or responding to other answers.

                    • Making statements based on opinion; back them up with references or personal experience.

                    To learn more, see our tips on writing great answers.




                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function ()
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55349355%2funable-to-handle-blank-cells-while-reading-blank-cell-from-excel-in-selenium%23new-answer', 'question_page');

                    );

                    Post as a guest















                    Required, but never shown





















































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown

































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown







                    -

                    Popular posts from this blog

                    SQL error code 1064 with creating Laravel foreign keysForeign key constraints: When to use ON UPDATE and ON DELETEDropping column with foreign key Laravel error: General error: 1025 Error on renameLaravel SQL Can't create tableLaravel Migration foreign key errorLaravel php artisan migrate:refresh giving a syntax errorSQLSTATE[42S01]: Base table or view already exists or Base table or view already exists: 1050 Tableerror in migrating laravel file to xampp serverSyntax error or access violation: 1064:syntax to use near 'unsigned not null, modelName varchar(191) not null, title varchar(191) not nLaravel cannot create new table field in mysqlLaravel 5.7:Last migration creates table but is not registered in the migration table

                    Image
                    Does a multiclassed wizard start with a spellbook? Minimizing medical costs with HSA Boss has banned cycling to work because he thinks it's unsafe Is there a typical layout to blocking installed for backing in new construction framing? In the Seventh Seal why does Death let the chess game happen? Why has Novell never written its own boot loader? Should I warn my boss I might take sick leave Why is the saxophone not common in classical repertoire? Is it possible to spoof an IP address to an exact number? Motorcyle Chain needs to be cleaned every time you lube it? Bypass with wrong cvv of debit card and getting OTP Do we have a much compact and generalized version of erase–remove idiom? how can i make this execution plan more efficient? Why did moving the mouse cursor cause Windows 95 to run more quickly? What's the big deal about the Nazgûl losing their horses? Has chattel slavery ever been used as a criminal punishment in the USA since the passag...
                    Read more

                    용인 삼성생명 블루밍스 목차 통계 역대 감독 선수단 응원단 경기장 같이 보기 외부 링크 둘러보기 메뉴samsungblueminx.comeh선수 명단용인 삼성생명 블루밍스용인 삼성생명 블루밍스ehsamsungblueminx.comeheheheh

                    Image
                    수원 삼성생명 비추미광주 신세계 쿨캣수원 삼성생명 비추미안산 신한은행 에스버드안산 신한은행 에스버드안산 신한은행 에스버드춘천 우리은행 한새춘천 우리은행 한새춘천 우리은행 한새춘천 우리은행 한새아산 우리은행 위비아산 우리은행 위비청주 KB 스타즈 한국 여자 농구 연맹 팀1977년 설립...
                    Read more

                    155 수학 과학 기타 둘러보기 메뉴eh추가해eh문서를 완성해

                    Image
                    0123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369...
                    Read more