Java报错:
java.lang.NullPointerException: Attempt to invoke virtual method 'java.lang.String org.apache.poi.hssf.usermodel.HSSFCell.getStringCellValue()' on a null object reference
at java_excel.JavaToExcelPoi3_9.readExcelCellValueString(JavaToExcelPoi3_9.java:73)
at java_excel.JavaToExcelPoi3_9.fromRamToExcel(JavaToExcelPoi3_9.java:641)
at java_excel.JavaToExcelPoi3_9.main(JavaToExcelPoi3_9.java:56)
at java.lang.reflect.Method.invoke(Native Method)
at com.aide.ui.build.java.RunJavaActivity$1.run(SourceFile:108)
at java.lang.Thread.run(Thread.java:919)
原因是xls文件中的cell为空时,不是""而是null,所以获取的Cell对象Object为null,其实是碰到空cell了,程序运行是成功的!
解决方法:添加判断if(.getCell(0)==null) break;
或continue;