jxl读EXCEL文件问题???急!!!!!!!!!!1

ietttt 2009-02-05 08:15:15
Warning: Cannot read name ranges for 翀 - setting to empty
Warning: Cannot read name ranges for f? - setting to empty
Warning: Cannot read name ranges for R - setting to empty
Warning: Cannot read name ranges for 罷 - setting to empty
Warning: Cannot read name ranges for FU罷 - setting to empty
Warning: Shared template formula is null - trying most recent formula template
Warning: Shared template formula is null - trying most recent formula template
Warning: Shared template formula is null - trying most recent formula template
Warning: Shared template formula is null - trying most recent formula template
Warning: Shared template formula is null - trying most recent formula template
Warning: Shared template formula is null - trying most recent formula template
Warning: Shared template formula is null - trying most recent formula template
Warning: Shared template formula is null - trying most recent formula template
Warning: Shared template formula is null - trying most recent formula template
Warning: Shared template formula is null - trying most recent formula template
Warning: Shared template formula is null - trying most recent formula template
Warning: Shared template formula is null - trying most recent formula template
Warning: Shared template formula is null - trying most recent formula template
Warning: Shared template formula is null - trying most recent formula template
Warning: Shared template formula is null - trying most recent formula template
Warning: Shared template formula is null - trying most recent formula template
Warning: Shared template formula is null - trying most recent formula template
Warning: Shared template formula is null - trying most recent formula template
Warning: Shared template formula is null - trying most recent formula template
Warning: Cannot find drawing record - using continue record
Warning: Cannot find drawing record - using continue record
Warning: Cannot find drawing record - using continue record
Warning: Cannot find drawing record - using continue record
Warning: Cannot find drawing record - using continue record
Warning: Cannot find drawing record - using continue record
Warning: Cannot find drawing record - using continue record
Warning: Cannot find drawing record - using continue record
Warning: Cannot find drawing record - using continue record
Warning: Cannot find drawing record - using continue record
Warning: Cannot find drawing record - using continue record
Warning: Cannot find drawing record - using continue record
Warning: Cannot find drawing record - using continue record
Warning: Cannot find drawing record - using continue record
Warning: Cannot find drawing record - using continue record
Warning: Cannot find drawing record - using continue record
Warning: Cannot find drawing record - using continue record
Warning: Cannot find drawing record - using continue record
Warning: Cannot find drawing record - using continue record
Warning: Cannot find drawing record - using continue record
Warning: Cannot find drawing record - using continue record
Warning: Cannot find drawing record - using continue record
Warning: Cannot find drawing record - using continue record
Warning: Cannot find drawing record - using continue record
Warning: Cannot find drawing record - using continue record
Warning: Cannot find drawing record - using continue record
Warning: Cannot find drawing record - using continue record
Warning: Cannot find drawing record - using continue record
Warning: Cannot find drawing record - using continue record
Warning: Cannot find drawing record - using continue record
Warning: Cannot find drawing record - using continue record
Warning: Cannot find drawing record - using continue record
common.AssertionFailed
at common.Assert.verify(Assert.java:37)
at jxl.read.biff.WorkbookParser.getName(WorkbookParser.java:1118)
at jxl.biff.formula.NameRange.read(NameRange.java:88)
at jxl.biff.formula.TokenFormulaParser.parseSubExpression(TokenFormulaParser.java:214)
at jxl.biff.formula.TokenFormulaParser.parse(TokenFormulaParser.java:111)
at jxl.biff.formula.FormulaParser.parse(FormulaParser.java:110)
at jxl.biff.DVParser.<init>(DVParser.java:431)
at jxl.biff.DataValiditySettingsRecord.initialize(DataValiditySettingsRecord.java:141)
at jxl.biff.DataValiditySettingsRecord.getFirstColumn(DataValiditySettingsRecord.java:235)
at jxl.read.biff.SheetReader.read(SheetReader.java:1025)
at jxl.read.biff.SheetImpl.readSheet(SheetImpl.java:716)
at jxl.read.biff.WorkbookParser.getSheet(WorkbookParser.java:252)
at org.embry.util.ExcelImportDB.addJLXlsForm(ExcelImportDB.java:29)
at org.embry.util.Test.main(Test.java:10)


哪个大虾帮忙看看啊!!!急急急急急急急急急急急急急急急急急急!!!!!!!!!!!!!!!!!!!111
...全文
3152 点赞 收藏 7
写回复
7 条回复
切换为时间正序
当前发帖距今超过3年，不再开放新的回复
发表回复
binge527533052 2011-12-20
4楼的哥们都没有看清楚就说 什么poi啊 是jxl 心碎 我也报这个错误
 回复 赞
小呆 2011-08-25
有公式图片什么的，就是有问题，就是要复制粘贴到新的文件（最好是只留存文本的）
 回复 赞
xinhe2008 2010-04-29
遇到同一问题,,希望哪位高手出来解答一下
 回复 赞
ietttt 2009-02-06
我读的那个是复杂的Excel，包括筛选，公式。我读一个简单的Excel就成功了。
 回复 赞
loveunittesting 2009-02-06
具体不清楚，你可以看看poi支持的如何。
 回复 赞
猫头鹰之眼 2009-02-05
Warning: Shared template formula is null - trying most recent formula template
Warning: Shared template formula is null - trying most recent formula template
Warning: Shared template formula is null - trying most recent formula template
Warning: Shared template formula is null - trying most recent formula template
Warning: Shared template formula is null - trying most recent formula template
Warning: Shared template formula is null - trying most recent formula template
Warning: Shared template formula is null - trying most recent formula template
Warning: Shared template formula is null - trying most recent formula template
Warning: Shared template formula is null - trying most recent formula template
Warning: Shared template formula is null - trying most recent formula template
Warning: Shared template formula is null - trying most recent formula template
Warning: Shared template formula is null - trying most recent formula template
Warning: Shared template formula is null - trying most recent formula template
Warning: Shared template formula is null - trying most recent formula template
Warning: Shared template formula is null - trying most recent formula template
Warning: Shared template formula is null - trying most recent formula template
Warning: Shared template formula is null - trying most recent formula template
Warning: Shared template formula is null - trying most recent formula template
Warning: Shared template formula is null - trying most recent formula template
空指针，调试跟踪看看
 回复 赞
猫头鹰之眼 2009-02-05
Warning: Cannot read name ranges for 翀 - setting to empty
Warning: Cannot read name ranges for f? - setting to empty
Warning: Cannot read name ranges for R - setting to empty
Warning: Cannot read name ranges for 罷 - setting to empty
Warning: Cannot read name ranges for FU罷 - setting to empty
这个警告应该是中文处理问题
 回复 赞
相关推荐
如何优雅地生成那些花里胡哨的复杂样式 Excel 文件？ 问题来了，这里面包括一些复杂文件的生成，如带有复杂样式的 Excel 文件，比如下面这个样子的： 这种复杂样式的 Excel, 如果说放到各个业务线去实现还是好办的，因为站在各个业务组的角度，场景变化不会太多，按照...
7 行代码实现 Excel 文件导出 除了上面说的，Apache poi、jxl 都存在生成 excel 文件不够简单优雅快速外，它们都还存在一个严重的问题，那就是 非常耗内存 ， 严重时会导致内存溢出 。 POI 虽然目前来说，是 excel 解析框架中被使用最广泛的，但...
android安卓源码海量项目合集打包-1 │ │ 支持 SingleLine 模式的标签云效果，轻松实现知乎问题话题列表 标签云效果，可以设置为 SingleLine 模式.rar │ │ 标签云效果，可以设置为 SingleLine 模式，丰富的自定义样式选择，轻松实现知乎问题话题...
在JAVA中用EasyExcel对表格进行快速导入导出 关于导出 Excel 文件，可以说是大多数服务中都需要集成的功能。那么，要如何优雅快速地（偷懒地）去实现这个功能呢？ 通常情况下我们用 Apache 开源框架 poi, 或者 jxl 都可以实现啊。面向百度编程，把代码模板 ...
对 Jenkins+ANT+Jmeter 接口测试的实践 1、前言 最近感觉大家都在讲Jenkins+jmeter+ant或maven的使用，但没有说到具体怎么投入到项目使用，只有比较基本的流程说说，所以我今天要说的就是我是怎么将这个方案投入到实际中使用的，先说明一下，本人是今年4...
Jenkins+ANT+Jmeter 接口测试的实践（转载） 1、前言 最近感觉大家都在讲Jenkins+jmeter+ant或maven的使用，但没有说到具体怎么投入到项目使用，只有比较基本的流程说说，所以我今天要说的就是我是怎么将这个方案投入到实际中使用的，先说明一下，本人是今年4...
一些Java面试题 1)synchronized关键字可以作为函数的修饰符，也可作为函数内的语句，也就是平时说的同步方法和同步语句块。如果 再细的分类，synchronized可作用于instance变量、object reference（对象引用）、static函数和class ...
docker-common-1.13.1-203.git0be3e21.el7.centos.x86_64.rpm 离线安装包，亲测可用
openshift-ansible-3.10.48-1.git.0.c205bc1.el7.noarch.rpm 官方离线安装包，亲测可用
部编版2020-2021学年八年级语文第一学期期末考试试卷【含答案】.doc 部编版2020-2021学年八年级语文第一学期期末考试试卷【含答案】.doc
rubygem-parse-cron-doc-0.1.4-1.el7.noarch.rpm 官方离线安装包，亲测可用
openshift-ansible-3.10.30-1.git.0.696299c.noarch.rpm 官方离线安装包，亲测可用
sqlite2-devel-2.8.17-17.el7.x86_64.rpm 官方离线安装包，亲测可用
uw-imap-static-2007f-16.el7.x86_64.rpm 官方离线安装包，亲测可用
qpid-proton-cpp-0.29.0-2.el7.x86_64.rpm 官方离线安装包，亲测可用
re2c-0.14.3-3.el7.x86_64.rpm 官方离线安装包，亲测可用
qpid-proton-cpp-0.21.0-2.el7.x86_64.rpm 官方离线安装包，亲测可用
openshift-ansible-docs-3.10.43-1.git.0.4794155.el7.noarch.rpm 官方离线安装包，亲测可用
luogu P1092 虫食算（深搜+剪枝） luogu P1092 虫食算（深搜+剪枝）
kubernetes-1.5.2-0.7.git269f928.el7.x86_64.rpm 离线安装包，亲测可用
发帖
Web 开发
创建于2007-09-28

8.0w+

社区成员

34.1w+

社区内容

Java Web 开发
申请成为版主
帖子事件
创建了帖子
2009-02-05 08:15
社区公告
暂无公告