jxl 遭遇读取sheet错误，不能getRows jxl.common.AssertionFailed

转：http://blog.youkuaiyun.com/zb0567/article/details/6367889

Warning:  Text Object on sheet "Sheet1" not supported - omitting  
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)  

测试时候是没有问题的，但是粘贴了大量数据的excel文件就有问题了。。。如上所述

后来搜索无果，多种途径无果，最后问题解决，是excel里包含了程序无法识别的文件，把excel重新拷贝然后选择性粘贴（数值）就ok了