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
...全文
3761 7 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
7 条回复
切换为时间正序
请发表友善的回复…
发表回复
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
这个警告应该是中文处理问题
linux excel 中文乱码,jxl linux 下中文乱码救命！
当前位置:我的异常网» Java Web开发»jxl linux 下中文乱码救命！jxl linux 下中文乱码救命！...excel文件数据导入oracle数据库，在window下发布是正常的，resin，red hand，环境，将本地文件上传至下面路径：/a...
easyexcel 读取指定行数据_惊了！7 行代码优雅地实现 Excel 文件导出功能？
点击上方蓝色字体，选择“置顶公众号”优质文章，第一时间送达作者:犬小哈目录一、前言二、Apache poi、jxl 的缺陷三...Excel 文件，可以说是大多数服务中都需要集成的功能。那么，要如何优雅快速地(偷懒地)去实现这...
java向xlsx文件写数据,如何用java向指定的Excel中写入数据!java从excel读取数据
1.java操作excel三方开源包很多，比如poi，javaExcel，OpenXls等；2.你可以上述的某个包，然后直接看它的API就ok了，单元格内容是最基础的方法，很容易的。希望对你有所帮助~~java简单创建exceljxl或者poi的一个jar...
如何优雅地生成那些花里胡哨的复杂样式 Excel 文件？
问题来了，这里面包括一些复杂文件的生成，如带有复杂样式的 Excel 文件，比如下面这个样子的： 这种复杂样式的 Excel, 如果说放到各个业务线去实现还是好办的，因为站在各个业务组的角度，场景变化不会太多，按照...
7 行代码实现 Excel 文件导出
除了上面说的，Apache poi、jxl 都存在生成 excel 文件不够简单优雅快速外，它们都还存在一个严重的问题，那就是 非常耗内存 ， 严重时会导致内存溢出 。 POI 虽然目前来说，是 excel 解析框架中被使用最广泛的，但...
Web 开发

81,122

社区成员

341,744

社区内容

发帖
与我相关
我的任务
社区描述
Java Web 开发
社区管理员
  • Web 开发社区
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章