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 这里应该说的很清楚