Query on null pointer Exception

[akshitha Akki]

package library;

import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.util.Iterator;
import java.util.List;
import java.util.Properties;
import java.util.concurrent.TimeUnit;

import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.openqa.selenium.By;
import org.openqa.selenium.support.ui.ExpectedConditions;
import org.openqa.selenium.support.ui.WebDriverWait;
import org.testng.annotations.DataProvider;
import org.testng.annotations.Test;

import test.SeleneseTest;

public class TestDataprovider extends SeleneseTest {

	@Test(dataProvider = "testData")
	public void testLogin(String uname, String pword)
	{
		driver.manage().timeouts().implicitlyWait(2000,TimeUnit.SECONDS);
		driver.get("http://yahoomail.com");
		driver.findElement(By.id("username")).sendKeys("uname");
		driver.findElement(By.id("passwd")).sendKeys("pword");

		boolean res = driver.findElement(By.id("persistent")).isSelected();
		System.out.println(res + "----------------");
		if(res == true)
			driver.findElement(By.id("persistent")).clear();
		else
		{
			driver.findElement(By.id("persistent")).click();
			driver.findElement(By.id("persistent")).click();
		}

		driver.findElement(By.xpath("//*[@id='.save']")).submit();

		WebDriverWait wait = new WebDriverWait(driver, 90);
		wait.until(ExpectedConditions.visibilityOf(driver.findElement(By.id("yucs-logo_link"))));
		System.out.println("done");
	}

	@DataProvider
	public Object[][] testData()  
	//public void testData()  
	{
		Object data[][] = new Object[2][];
		String str[][]= new String[2][];
		Properties prop = System.getProperties(); 
		System.out.println(prop.getProperty("java.class.path", null)); // to get the class path 
		XSSFWorkbook workbook = null;
		String url = "C:\\Trial_workspace\\testProject\\resources\\data.xlsx";
		try {
			workbook = new XSSFWorkbook(new FileInputStream(url));
			int sheetNumber = workbook.getNumberOfSheets();
			XSSFSheet sheet = workbook.getSheetAt(0);

			String sheetName = sheet.getSheetName();
			Iterator<Row> rowIterator = sheet.iterator();
			while (rowIterator.hasNext()) 
			{
				Row row = rowIterator.next();
				int rows = 0;
				Iterator<Cell> cellIterator = row.cellIterator();
				int colms = 0;
				while(cellIterator.hasNext())
				{
					Cell cell = cellIterator.next();
					switch(cell.getCellType())
					{
						case Cell.CELL_TYPE_BOOLEAN:
							//System.out.println(cell.getBooleanCellValue());
							break;
						case Cell.CELL_TYPE_NUMERIC:
							//System.out.println(cell.getNumericCellValue());
							break;
						case Cell.CELL_TYPE_STRING:
							//System.out.println(cell.getStringCellValue());
							if (colms == 0)
								str[rows][colms] = cell.getStringCellValue();
								//System.out.println(cell.getStringCellValue());
							if (colms == 1)
								str[rows][colms] = cell.getStringCellValue();
								//System.out.println(cell.getStringCellValue());
							break;
					}
					colms ++;
				}
				rows ++;
				System.out.println("");
			}
		} catch (FileNotFoundException e) {
			e.printStackTrace();
			System.out.println("FileNotFoundException");
		} catch (IOException e) {
			e.printStackTrace();
			System.out.println("IOException");
		}
		return data;
	}

}

I am getting Nullpointer exception. could someone please help in letting me know how to fix it.

[Paul Clapham]

First step is to find out what line of code is throwing the exception. The stack trace will tell you that -- and I see that your code is printing the stack trace for you.

(This isn't a Scala question, so I'm moving it to a better forum.)