一、使用jxl读取excel数据时,由于添加了数据有效性验证,在Wookbook.getSheet(0)的时候出现空指针异常:
Warning: Cell at A6 not present - adding a blank
Warning: Some cells exceeded the specified bounds. Resizing sheet dimensions from 6x2 to 6x6
解决方法:在创建wookbook时,去掉excel的数据有效性即可,代码如下:
WorkbookSettings ws = new WorkbookSettings();
//去除wookbook的读取excel时数据的有效性
ws.setCellValidationDisabled(true);
Workbook wb=Workbook.getWorkbook(new File(“path”)