Couldn't execute ZK Spreadsheet

asked 2009-12-01 04:41:29 +0800

per4ez
30

Hello, Community!

I'm trying to explore ZK Spreadsheet. And I faced to the problem.
I want to create simple application with zk spreadsheet component using Eclipse. I followed next steps:

1) downloaded ZK Spreadsheet binary files (zk-zss-bin-1.0.0-RC2.zip)

2) unziped and copied zss.jar to WEB-INF\lib
I also tried to copy all files from dist folder to $CATALINA_HOME\lib but got an error while starting Tomcat:
*********
SEVERE: Failed to load jar:file:/C:/Program%20Files/Apache%20Software%20Foundation/Tomcat%206.0/lib/zssex.jar!/metainfo/zk/lang-addon.xml
>>java.lang.IllegalArgumentException: class org.zkoss.zssex.ui.widget.WidgetCtrl must implement interface org.zkoss.zk.ui.Component
>> at org.zkoss.zk.ui.metainfo.impl.ComponentDefinitionImpl.<init>(ComponentDefinitionImpl.java:100)
>> at org.zkoss.zk.ui.metainfo.DefinitionLoaders.parseLang(DefinitionLoaders.java:413)
>> at org.zkoss.zk.ui.metainfo.DefinitionLoaders.load0(DefinitionLoaders.java:162)
>> at org.zkoss.zk.ui.metainfo.DefinitionLoaders.load(DefinitionLoaders.java:123)
>> at org.zkoss.zk.ui.metainfo.LanguageDefinition.init(LanguageDefinition.java:265)
>> at org.zkoss.zk.ui.metainfo.LanguageDefinition.getAll(LanguageDefinition.java:244)
>>...
**************
I couldn't solve this problem and deleted this libs: zssjxl.jar, zssex.jar.

3) next, I created index.zul with next source code:
<?page title="Auto Generated index.zul"?>
<window>
<spreadsheet id="balance" url="/BalanceSheet.xls" maxrow="20" maxcolumn="20" height="600px" width="800px" />
</window>

4) and finally start this app on server and get this error, which put me at a stand:
******************************
SEVERE: Failed to assign [maxrow=20] to <Spreadsheet balance>
jxl/read/biff/ZssWorkbookParser
01.12.2009 13:31:09 org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Servlet.service() for servlet zkLoader threw exception
java.lang.ClassNotFoundException: jxl.read.biff.ZssWorkbookParser
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1387)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1233)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)
at org.zkoss.zss.model.impl.ExcelImporter.importFromStream(ExcelImporter.java:93)
at org.zkoss.zss.model.impl.ExcelImporter.importFromURL(ExcelImporter.java:169)
at org.zkoss.zss.model.impl.ExcelImporter.imports(ExcelImporter.java:69)
at org.zkoss.zss.ui.Spreadsheet.getBook(Spreadsheet.java:369)
at org.zkoss.zss.ui.Spreadsheet.getSelectedSheet(Spreadsheet.java:454)
at org.zkoss.zss.ui.Spreadsheet.setMaxrows(Spreadsheet.java:600)
at org.zkoss.zss.ui.Spreadsheet.setMaxrow(Spreadsheet.java:626)
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.zkoss.zk.ui.metainfo.Property.assign0(Property.java:260)
at org.zkoss.zk.ui.metainfo.Property.assign(Property.java:175)
at org.zkoss.zk.ui.metainfo.ComponentInfo.applyProperties(ComponentInfo.java:769)
at org.zkoss.zk.ui.impl.AbstractUiFactory.newComponent(AbstractUiFactory.java:95)
at org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild0(UiEngineImpl.java:616)
at org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild(UiEngineImpl.java:587)
at org.zkoss.zk.ui.impl.UiEngineImpl.execCreate0(UiEngineImpl.java:531)
at org.zkoss.zk.ui.impl.UiEngineImpl.execCreate(UiEngineImpl.java:498)
at org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild0(UiEngineImpl.java:631)
at org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild(UiEngineImpl.java:587)
at org.zkoss.zk.ui.impl.UiEngineImpl.execCreate0(UiEngineImpl.java:531)
at org.zkoss.zk.ui.impl.UiEngineImpl.execCreate(UiEngineImpl.java:498)
at org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage0(UiEngineImpl.java:378)
at org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage(UiEngineImpl.java:299)
at org.zkoss.zk.ui.http.DHtmlLayoutServlet.process(DHtmlLayoutServlet.java:230)
at org.zkoss.zk.ui.http.DHtmlLayoutServlet.doGet(DHtmlLayoutServlet.java:166)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
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.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
at java.lang.Thread.run(Thread.java:619)
******************************

What I'm doing wrong or it is a bug?

Additional info:
1) Eclipse Galileo with ZK Studio Eclipse Plugins 0.9.5.v200907031701
2) apache-tomcat-6.0.20
3) a BalanceSheet.xls file located in project Web-Content folder

Thanks a lot for ZK Framework!