java读取Excel 错误: jxl.read.biff.BiffException: Unable to recognize OLE stream
来源:互联网 发布:模拟dj打碟机软件 编辑:程序博客网 时间:2024/05/16 09:44
异常信息:
jxl.read.biff.BiffException: Unable to recognize OLE stream
at jxl.read.biff.CompoundFile.<init>(CompoundFile.java:116)
at jxl.read.biff.File.<init>(File.java:127)
at jxl.Workbook.getWorkbook(Workbook.java:268)
at jxl.Workbook.getWorkbook(Workbook.java:253)
解决方法:
1、新建excel文件,手动复制原文件内容至新文件。然后删除原文件,并将新文件的文件改成原文件的文件名。然后用jxl读取成功。
2,打开源文件,随便输入几个空格后再删除,然后保存
这个Excel文件是从哪里来的,很可能是从一个页面上下载来的,而这个页面做的功能就是导出Excel,但做偷懒了,没有用jxl和POI等库,而是用直接用jsp生成html写的。重新建过一个文件就可以了.
原理:去除原excel中出错的非文本部分。
- java读取Excel 错误: jxl.read.biff.BiffException: Unable to recognize OLE stream
- java读取Excel 错误: jxl.read.biff.BiffException: Unable to recognize OLE stream
- java读取Excel 错误: jxl.read.biff.BiffException: Unable to recognize OLE stream
- java读取Excel 错误: jxl.read.biff.BiffException: Unable to recognize OLE stream
- java读取Excel 错误: jxl.read.biff.BiffException: Unable to recognize OLE stream
- 使用jxl读取excel报错记录:jxl.read.biff.BiffException: Unable to recognize OLE stream
- java解析excel文件出错jxl.read.biff.BiffException: Unable to recognize OLE stream
- jxl.read.biff.BiffException: Unable to recognize OLE stream
- jxl.read.biff.BiffException: Unable to recognize OLE stream
- jxl.read.biff.BiffException: Unable to recognize OLE stream
- jxl.read.biff.BiffException: Unable to recognize OLE stream:
- jxl.read.biff.BiffException: Unable to recognize OLE stream解决方法
- jxl.read.biff.BiffException: Unable to recognize OLE stream
- jxl导入Excel报jxl.read.biff.BiffException: Unable to recognize OLE stream
- 读入Excel报jxl.read.biff.BiffException: Unable to recognize OLE stream
- jxl.read.biff.BiffException: Unable to recognize OLE stream原因及解决方法
- java 读取excel 文件 Unable to recognize OLE stream 错误
- java 读取excel 文件 Unable to recognize OLE stream 错误
- web 安全认证-角色 权限 模块分配
- UML类图符号理解
- 如何注册协议(类似tencent://…)
- 被人忽视的intern
- 进程和线程的区别
- java读取Excel 错误: jxl.read.biff.BiffException: Unable to recognize OLE stream
- 数据库完整备份方案
- Java中的线程
- Modules in IIS 7
- Tomcat部署Java Web应用程序
- saas
- java 中 image 和 byte[] 相互转换
- Java设计模式-之Command命令模式
- linq to sql生成not in语句的小技巧