java.lang.NullPointerExceptionatjxl.read.biff.File.(File.java:91)atjxl.Workbook.getWorkbWorkbookwb=null;try{//文件路径InputStreamis=VMListCreate.class.getResourceAsStream("/resources/experimentdata.xls");wb=Workbook.getWorkbook(is);

Question

java.lang.NullPointerException at jxl.read.biff.File.(File.java:91) at jxl.Workbook.getWorkb
Workbook wb=null;
try {
// 文件路径
InputStream is = VMListCreate.class.getResourceAsStream("/resources/experiment data.xls");
wb = Workbook.getWorkbook(is);
Sheet sheet = wb.getSheet(0); // 第几张表格从零开始
if (sheet = null) {
int rsRows = sheet.getRows();// 获取表格总行数
for (int rowNum = 1; rowNum < rsRows; rowNum++) {
Cell[] cells = sheet.getRow(rowNum);//获取整行的内容,并存储到数组cells中
mips[rowNum-1] = Integer.parseInt(cells[2].getContents());//将excel中的mips值解析后赋值给变量数组
ram[rowNum-1] = Integer.parseInt(cells[4].getContents());//将excel中的ram值解析后赋值给变量数组
}
}
wb.close();

Answer 1

wb=workbook.getWorkbook(is);如果/resources/experiment data.xls这个不存在,那么is就是空的,调用getWorkbook方法时,就可能报这个错误.
调试一下,看看是不是is是null的,在wb = Workbook.getWorkbook(is);这一行报错了