ZK spreadsheet is an online spreadsheet which enables users to import and export excel files and edit excel files within the browser. This can be thought to be similar to Google Spreadsheet. Only that it is open source and can be installed on your own server. Another very similar open source product which I came across was Sheetster but the setup was not very straight forward and also I was not really impressed with the UI and functionality.
Below, I give the steps for installing ZK spreadsheet on Debian Lenny:
# apt-get install tomcat5.5 tomcat5.5-webapps tomcat5.5-admin
Accessing http://localhost:8180/ should display the default Tomcat home page.
# unzip zk-spreadsheet-demo-2.0.0-Beta.zip # cd zk-spreadsheet-demo-2.0.0-Beta # mv zssapp.war zssdemo.war /var/lib/tomcat5.5/webapps/
... ... ... // These permissions apply to JULI grant codeBase "file:${catalina.home}/bin/tomcat-juli.jar" { ... ... ... permission java.io.FilePermission "${catalina.base}${file.separator}webapps${file.separator}zssapp${file.separator}WEB-INF${file.separator}classes${file.separator}logging.properties", "read"; permission java.io.FilePermission "${catalina.base}${file.separator}webapps${file.separator}zssdemo${file.separator}WEB-INF${file.separator}classes${file.separator}logging.properties", "read"; }; ... ... ... //added for zssapp webapp grant codeBase "file:${catalina.base}/webapps/zssapp/-" { permission java.security.AllPermission; };
# /etc/init.d/tomcat5.5 restart
The ZK spreadsheet should now be accessible at http://localhost:8180/zssapp/ and the demo at http://localhost:8180/zssdemo/.
# chmod 700 /var/lib/tomcat5.5/webapps/zssapp/
If you face any issues or have any queries reg. ZK Spreadsheet, you can post in the forum at http://www.zkoss.org/forum/.
References:
http://ostatic.com/question/open-source-web-spreadsheet
http://en.wikipedia.org/wiki/List_of_spreadsheet_software#Online_spreads...
http://en.wikipedia.org/wiki/List_of_online_spreadsheets
http://www.debianadmin.com/how-to-setup-apache-tomcat-55-on-debian-etch....
http://www.mkyong.com/tomcat/tomcat-javasecurityaccesscontrolexception-a...
http://www.zkoss.org/forum/listComment/9143
Add new comment