java jxl importsheet 空指针_jxl importSheet 报common.AssertionFailed 异常的解决方法

当使用jxl 操作Excel，在拷贝的过程是先读取excel然后读取其内的所有sheet页。然后将这个sheet页放到importSheet方法中。

Workbook wb = Workbook.getWorkbook(new File("D:\\sdsdsddd.xls"));

WritableWorkbook wwb = Workbook.createWorkbook(new File("D:\\"+UUID.randomUUID().toString()+".xls"));

Sheet [] sheets = wb.getSheets();

for (int j = 0; j < sheets.length; j++) {

Sheet sheet = sheets[j];

wwb.importSheet(sheetName, wwb.getSheets().length, sheet);

}

但是这时却抛出AssertionFailed  异常如下：

jxl.common.AssertionFailed

at jxl.common.Assert.verify(Assert.java:37)

at jxl.read.biff.SheetReader.handleObjectRecord(SheetReader.java:1811)

at jxl.read.biff.SheetReader.read(SheetReader.java:1059)

at jxl.read.biff.SheetImpl.readSheet(SheetImpl.java:716)

at jxl.read.biff.WorkbookParser.getSheet(WorkbookParser.java:257)

at com.zz.dao.Excel.main(Excel.java:64)

jxl.common.AssertionFailed

at jxl.common.Assert.verify(Assert.java:37)

at jxl.read.biff.SheetReader.handleObjectRecord(SheetReader.java:1811)

at jxl.read.biff.SheetReader.read(SheetReader.java:1059)

at jxl.read.biff.SheetImpl.readSheet(SheetImpl.java:716)

at jxl.read.biff.WorkbookParser.getSheet(WorkbookParser.java:257)

at com.zz.dao.Excel.main(Excel.java:64)

根据http://blog.csdn.net/cheneyfeng3/article/details/6394325 ，而本人还是不知道他是如何处理的，他也没有明示他的解决方法(可能本人笨吧)。

而根据这个链接的提示：http://hi.baidu.com/zhangxuan1224/item/487edf25ee7669d50f37f940

为什么他这样写就对呢？所以本人只好把上述方法进行如下的修改：

Workbook wb = Workbook.getWorkbook(new File("D:\\sdsdsddd.xls"));

WritableWorkbook wwb = Workbook.createWorkbook(new File("D:\\"+UUID.randomUUID().toString()+".xls"));

//Sheet [] sheets = wb.getSheets();

int numberOfSheets = wb.getNumberOfSheets();

for (int j = 0; j < numberOfSheets; j++) {

Sheet sheet = wb.getSheet(j)

wwb.importSheet("sheet"+j, j, sheet);

}

这样写既然能解决抛出AssertionFailed  异常的问题。

关于具体的原因本人也不清楚。而http://blog.csdn.net/cheneyfeng3/article/details/6394325 这里应该说的很清楚