首页 > 解决方案 > 在 selenium 中使用 apache poi 读取 Excel 文件,但尝试在 java 中运行代码时显示 nullpointerException 错误

问题描述

运行此代码时显示 nullpointerException 错误

npackage.ReadindDataFromExcel.main(ReadindDataFromExcel.java:48) 处的线程“主”java.lang.NullPointerException 中的异常*

public static void main(String[] args) throws Exception
{

    System.setProperty("webdriver.chrome.driver", "C:\\chromedriver.exe");
    WebDriver driver = new ChromeDriver();
    driver.get("http://newtours.demoaut.com");

    //Excel File location
    FileInputStream file = new FileInputStream("C://Datafirst.xls");

    HSSFWorkbook workbook = new HSSFWorkbook(file);
    HSSFSheet sheet = workbook.getSheet("Sheet1");
    int noOfRows = sheet.getLastRowNum();
    System.out.println("No.of Records in the Excel Sheet:" + noOfRows);
    //int colcount=sheet.getRow(0).getLastCellNum();

    for (int row = 0; row <= noOfRows; row++)
    {
        HSSFRow currentrow = sheet.getRow(row);
        String First_name = currentrow.getCell(0).getStringCellValue();
    }
}

标签: javamultithreadingexceptionnullpointerexception

解决方案


推荐阅读