JXL读取EXCEL报错: Warning: Text Object on sheet "sheet0" not supported - omitting

Warning:  Text Object on sheet "sheet0" 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 example.ExcelUtil.readExcel(ExcelUtil.java:31)
at Test.main(Test.java:14)
Exception in thread "main" 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 example.ExcelUtil.readExcel(ExcelUtil.java:31)

at Test.main(Test.java:14)

网上查了,大概就是说excel中有不能识别的格式,jxl不能识别。

后来我把所有单元格中的内容都转成了文本格式还是不行。

纠结了3个小时之后，终于找到原因。

excel中有好多个空白的文本框，删除即可。

然后delete ，全部删除就好了。