-
FEATURED COMPONENTS
First time here? Check out the FAQ!
my project with ZK Spreadsheet framework, and i download the demo from website.it is running be ok.but when i import a excel file,then system throws exception,
anybody know this exception why?
2013-1-7 13:26:39 org.zkoss.zk.ui.impl.UiEngineImpl getResponses:1416 严重: java.lang.IndexOutOfBoundsException: Index: 0, Size: 0 at java.util.ArrayList.RangeCheck(ArrayList.java:547) at java.util.ArrayList.get(ArrayList.java:322) at org.zkoss.poi.ss.format.CellFormat.<init>(CellFormat.java:228) at org.zkoss.poi.ss.format.CellFormat.getInstance(CellFormat.java:171) at org.zkoss.zss.model.impl.BookHelper.getFormatText(BookHelper.java:1024) at org.zkoss.zss.model.impl.RangeImpl.getFormatText(RangeImpl.java:271)
Dear Killfen,
I have the same your exception. The problem is in Excel file have some Cell with "custom format", you can use Excel to move each to check it format. I not sure the same you problem, but hope to help you.
2013-1-7 14:26:56 org.apache.catalina.core.AprLifecycleListener init 信息: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files\Java\jdk1.6.0_05\bin;D:\tomcat-6.0.18\bin 2013-1-7 14:26:57 org.apache.coyote.http11.Http11Protocol init 信息: Initializing Coyote HTTP/1.1 on http-80 2013-1-7 14:26:57 org.apache.catalina.startup.Catalina load 信息: Initialization processed in 1757 ms 2013-1-7 14:26:57 org.apache.catalina.core.StandardService start 信息: Starting service Catalina 2013-1-7 14:26:57 org.apache.catalina.core.StandardEngine start 信息: Starting Servlet Engine: Apache Tomcat/6.0.18 2013-1-7 14:27:04 com.sun.faces.config.ConfigureListener contextInitialized 信息: Initializing Sun's JavaServer Faces implementation (1.2_04-b07-FCS) for context '/tzk' 2013-1-7 14:27:05 org.apache.catalina.core.ApplicationContext log 信息: Initializing Spring root WebApplicationContext log4j:WARN No appenders could be found for logger (org.springframework.web.context.ContextLoader). log4j:WARN Please initialize the log4j system properly. 2013-1-7 14:27:07 org.zkoss.zk.ui.http.WebManager <init>:115 信息: Starting ZK 6.5.0 CE (build: 2012091217) 2013-1-7 14:27:07 org.zkoss.zk.ui.sys.ConfigParser parseConfigXml:160 信息: Loading system default 2013-1-7 14:27:07 org.zkoss.zk.ui.sys.ConfigParser parse:267 信息: Parsing jndi:/localhost/tzk/WEB-INF/zk.xml 2013-1-7 14:27:18 org.zkoss.zk.ui.http.WebManager <init>:115 信息: Starting ZK 6.5.0 CE (build: 2012091217) 2013-1-7 14:27:18 org.zkoss.zk.ui.sys.ConfigParser parseConfigXml:160 信息: Loading system default 2013-1-7 14:27:19 org.zkoss.zk.ui.sys.ConfigParser parse:267 信息: Parsing jndi:/localhost/zk/WEB-INF/zk.xml 2013-1-7 14:27:21 org.apache.catalina.core.ApplicationContext log 信息: Initializing Spring root WebApplicationContext AbandonedObjectPool is used (org.apache.commons.dbcp.AbandonedObjectPool@1628d93) LogAbandoned: true RemoveAbandoned: true RemoveAbandonedTimeout: 5 2013-1-7 14:27:31 org.apache.coyote.http11.Http11Protocol start 信息: Starting Coyote HTTP/1.1 on http-80 2013-1-7 14:27:31 org.apache.jk.common.ChannelSocket init 信息: JK: ajp13 listening on /0.0.0.0:8009 2013-1-7 14:27:31 org.apache.jk.server.JkMain start 信息: Jk running ID=0 time=0/94 config=null 2013-1-7 14:27:31 org.apache.catalina.startup.Catalina start 信息: Server startup in 33740 ms
Hi Killfen,
Which version of ZK you are using?
I think your issue will be resolved when you will use zk version 6.5.1.
Asked: 2013-01-07 05:38:01 +0800
Seen: 115 times
Last updated: Mar 22 '13
http://yangchao.ming-soft.net/test.rar (download excel)
killfen ( 2013-01-07 06:30:35 +0800 )editthanks ashishd ,I'll be waiting for your reply
killfen ( 2013-01-07 06:32:06 +0800 )edithelp.....help....
killfen ( 2013-01-08 02:32:55 +0800 )editHi Killfen,
Is there any chart/ image in your spread sheet.
If yes then it is a bug in zk. link text
iamsudhir4u ( 2013-03-22 05:36:58 +0800 )editPreviously you are telling its version issue now you have a new answer are you sure whats the issue and ever you used ExcelSheet in project
sjoshi ( 2013-03-22 05:47:50 +0800 )edit