jsp在excel导入sql 2000数据库时的诡异错误

[苦苦的潜行者]

导入正常，但是在控制台报错。
百度谷歌都没有搜到类似的错误。哦对了，搜到一个也是excel导入的下标异常错误，说是jar包太旧了，我换成最新的jxl.jar包还是不行。
错误如下

Warning:  Exception when parsing URL I2"I2".  Using default.
java.lang.ArrayIndexOutOfBoundsException
	at java.lang.System.arraycopy(Native Method)
	at jxl.biff.StringHelper.getUnicodeString(StringHelper.java:189)
	at jxl.read.biff.HyperlinkRecord.<init>(HyperlinkRecord.java:191)
	at jxl.read.biff.SheetReader.read(SheetReader.java:435)
	at jxl.read.biff.SheetImpl.readSheet(SheetImpl.java:716)
	at jxl.read.biff.WorkbookParser.getSheet(WorkbookParser.java:257)
	at com.dsxx.dao.ExcelDao.upExcelDb(ExcelDao.java:239)
	at com.dsxx.service.ExcelService.upExcelToDb(ExcelService.java:60)
	at com.dsxx.actions.PreWorkAction.getUploadPath(PreWorkAction.java:72)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270)
	at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:187)
	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
	at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:654)
	at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:445)
	at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:379)
	at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:292)
	at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1085)
	at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:398)
	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:241)
	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
	at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.dsxx.util.EncodingFilter.doFilter(EncodingFilter.java:19)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:581)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
	at java.lang.Thread.run(Thread.java:619)

[雨天要吃饭]

下标越界啊

看你循环时候取得的下标是不是超过范围了。

[sally-wang]

java.lang.ArrayIndexOutOfBoundsException
一看就是下标越界了啊。

[苦苦的潜行者]

有没有人帮忙啊，真的很郁闷啊...



-----------------------------
我是猴嫂派来监视猴哥的...

[苦苦的潜行者]

真的不是下标越界..
附上代码文件和原始xls表。
http://download.csdn.net/source/3533968
请帮忙看一下，O(∩_∩)O谢谢



-----------------------------
我是猴嫂派来监视猴哥的...

[飞跃颠峰]

这个包我没用过，不过看起来是Jxl的缺陷。网上有两个不同的解决方案，你可以看看是否适用于你的情况。

http://blog.csdn.net/kunshan_shenbin/article/details/5611477

http://suky.iteye.com/blog/622272

[苦苦的潜行者]

[Quote=引用 5 楼 alexandertech 的回复:]
这个包我没用过，不过看起来是Jxl的缺陷。网上有两个不同的解决方案，你可以看看是否适用于你的情况。

http://blog.csdn.net/kunshan_shenbin/article/details/5611477

http://suky.iteye.com/blog/622272
[/Quote]

看来是jxl包的问题了,但是至今未解决.不过既然能正常使用,我就先不管他了.

[苦苦的潜行者]

观察了好几天,终于发现是什么原因了!
Exception when parsing URL I2"I2". Using default.
这个单元格的数据有超链接,所以在转换带有超链接的单元格(I2)时抛出异常,但是jxl包用using default,去掉他的连接属性,这样虽然报错,但是还是能够正常导入数据.

希望有能人来帮忙改一下代码,使得在导入之前先把单元格中的超链接属性去掉,老是抛出错误,心里不舒服

[苦苦的潜行者]

[Quote=引用 8 楼 k_kid9157 的回复:]

想学习LZ导入excel的代码
可否分享一下？
[/Quote]

网上搜jxl.jar导入导出excel,太多了

[k_kid9157]

[Quote=引用 9 楼 xiaolinyouni 的回复:]

引用 8 楼 k_kid9157 的回复:

想学习LZ导入excel的代码
可否分享一下？


网上搜jxl.jar导入导出excel,太多了
[/Quote]

谢谢

[k_kid9157]

想学习LZ导入excel的代码
可否分享一下？