在java中用jxl操作EXCEL
Workbook book = Workbook.getWorkbook(new File("D:\\project.xls"));
Sheet sheet = book.getSheet(0);
Cell cell=sheet.getCell(0,4);
String result=cell.getContents();
System.out.println("########################### " +result);
为什么在程序执行到Sheet sheet = book.getSheet(0);时,会抛NullPointerException呢?读取其他excel都没有
问题,下面是出错的详细信息:
java.lang.NullPointerException
at jxl.biff.drawing.Drawing.initialize(Drawing.java:249)
at jxl.biff.drawing.Drawing.<init>(Drawing.java:157)
at jxl.read.biff.SheetReader.read(SheetReader.java:737)
at jxl.read.biff.SheetImpl.readSheet(SheetImpl.java:620)
at jxl.read.biff.WorkbookParser.getSheet(WorkbookParser.java:230)
at com.ERP5I5J.Action.Business.Section.Upload.ReadSectionExcel.main(ReadSectionExcel.java:464)
有谁碰到过这个问题啊!!!!
Workbook book = Workbook.getWorkbook(new File("D:\\project.xls"));
Sheet sheet = book.getSheet(0);
Cell cell=sheet.getCell(0,4);
String result=cell.getContents();
System.out.println("########################### " +result);
为什么在程序执行到Sheet sheet = book.getSheet(0);时,会抛NullPointerException呢?读取其他excel都没有
问题,下面是出错的详细信息:
java.lang.NullPointerException
at jxl.biff.drawing.Drawing.initialize(Drawing.java:249)
at jxl.biff.drawing.Drawing.<init>(Drawing.java:157)
at jxl.read.biff.SheetReader.read(SheetReader.java:737)
at jxl.read.biff.SheetImpl.readSheet(SheetImpl.java:620)
at jxl.read.biff.WorkbookParser.getSheet(WorkbookParser.java:230)
at com.ERP5I5J.Action.Business.Section.Upload.ReadSectionExcel.main(ReadSectionExcel.java:464)
有谁碰到过这个问题啊!!!!
java.lang.IndexOutOfBoundsException: Index: 11, Size: 4
at java.util.ArrayList.RangeCheck(Unknown Source)
at java.util.ArrayList.get(Unknown Source)
at jxl.read.biff.WorkbookParser.getSheet(WorkbookParser.java:228)
at com.ERP5I5J.Action.Business.Section.Upload.ReadSectionExcel.main(ReadSectionExcel.java:464)所以这个sheet还是存在的
加入 if(book==null)System.out.println("book is null. xls not found");Sheet sheet = book.getSheet(0); 看看有没有打印信息。可能是这个文件d:\project.xls不存在。本地没问题的话,看看服务器上是不是有这个文件。