I am using Apache POI to read the excel.While reading the null value from excel, selenium script is stopped and its not continue.
@Test(priority = 1)
public void Signin() throws IOException, InterruptedException {
SoftAssert softAssert = new SoftAssert();
ExcelRead();
sheet = workbook.getSheetAt(0);
for (int i = 1; i <= sheet.getLastRowNum(); i++) {
try {
cell = getCellValue(i, 1);
String cellValue = cell.getStringCellValue();
wait.until(ExpectedConditions.elementToBeClickable(By.id("LG")));
driver.findElement(By.id("LG")).clear();
driver.findElement(By.id("LG")).sendKeys(cellValue);
cell = getCellValue(i, 2);
String cellValue1 = cell.getStringCellValue();
driver.findElement(By.id("PWD")).clear();
driver.findElement(By.id("PWD")).sendKeys(cellValue1);
driver.findElement(By.id("btnSubmit")).click();
Here
String cellValue = cell.getStringCellValue(); is not accept the values.