代码如下:
File tmpfile = file;
Workbook rwb = null;
InputStream is = null;
is = new FileInputStream(tmpfile);
rwb = Workbook.getWorkbook(is);
Sheet rs=null;
rs = rwb.getSheet(j);//此处抛出异常
抛出的异常为:
java.lang.IndexOutOfBoundsException: Index: 23, Size: 23
at java.util.ArrayList.RangeCheck(ArrayList.java:507)
at java.util.ArrayList.get(ArrayList.java:324)
at jxl.biff.FormattingRecords.getNumberFormat(FormattingRecords.java:247)
at jxl.read.biff.NumberRecord.<init>(NumberRecord.java:73)
at jxl.read.biff.SheetReader.read(SheetReader.java:503)
at jxl.read.biff.SheetImpl.readSheet(SheetImpl.java:716)
at jxl.read.biff.WorkbookParser.getSheet(WorkbookParser.java:257)
at com.lium.test.readExcel.parseExcel(readExcel.java:62)
at com.lium.test.readExcel.main(readExcel.java:194)
经跟踪调试发现是getsheet()时遇到number类型的单元格就抛出异常了,有遇到过类似问题的吗,急!如能够解决将分值追加到200!
三楼,,只要把文件打开,,什么也不做,只要点击保存,再读取就没有问题了,所以复制到别的excel文件上肯定就没有异常了。现在主要的问题是如何不做其它操作直接就能读取。