ZK Spreadsheet

ZK Spreadsheet
Initial release	January 2008 (2008-01)

Stable release	3.6 / October 21, 2014 (2014-10-21)
Written in	Java
Type	Open Source Online Spreadsheet
License	GPL, Commercial
Website	www.zkoss.org/product/zkspreadsheet

ZK Spreadsheet is an open source embeddable web-based spreadsheet that delivers the functionality of Microsoft Excel on browsers using pure Java. It differs from most online spreadsheets in that it can be extended and embedded into a webpage that's served by Java web technology rather than being used as an application in itself only. It provides a set of application programming interface for tasks such as user interface customization, event control, and data binding with back end data model. The spreadsheet component can also be used as a JSP tag or a JSF component.
The spreadsheet component has a set of built-in functions^[1] commonly used in finance, statistics, and engineering which are compatible with functions supported in Microsoft Excel. Microsoft Excel XLS and XLSX files can be imported to and exported from ZK Spreadsheet. The spreadsheet component has also been demonstrated to work together with IBM Lotus Domino Designer XPages^[2] and was awarded 2nd^[3] place for its strong integration in the IBM XPages Development Contest.

Java Web Component

ZK Spreadsheet is a spreadsheet component which can be embedded in a Java web application without plugins. It targets Java developers who wish to include a real-time collaborative online spreadsheet into a Java web application.

Application Programming Interface

The component exposes a comprehensive set of application programming interface^[4] for:

user and system event handling
cells, rows, columns, and sheets manipulation
data-binding to Java beans and Spring beans
charts
real-time collaboration configurations
import and export to Microsoft Excel XLS or XLSX files
export to Adobe PDF format
custom formula function
custom themes

As a Service

Other than employed as a web component, ZK Spreadsheet can also be deployed as a self-hosted SaaS spreadsheet.

Server Requirement

JVM compatible web server and web container that runs Java 5 or above

Client Requirement

Latest Google Chrome, Firefox, Internet Explorer 9 or above

Compatibility

From a functional perspective, ZK Spreadsheet is compatible with Microsoft Excel and Adobe PDF.

Microsoft Excel

Microsoft Excel XLS and XLSX files can be imported as ZK Spreadsheet workbooks.
A ZK Spreadsheet workbook can also be exported to XLS or XLSX format.
The 256 built-in function^[5] supported by ZK Spreadsheet are compatible with their Microsoft Excel counterparts.
A ZK Spreadsheet can also embed charts and images from Microsoft Excel files.

Adobe PDF

Sheets in a ZK Spreadsheet workbook can be exported to Adobe PDF format.
From a web application developer's perspective, it has been demonstrated to work with other Java-based web technologies and standards.

JavaServer Pages (JSP)

ZK Spreadsheet can be embedded in a JSP page as a JSP custom tag.

JavaServer Faces (JSF)

ZK Spreadsheet can be embedded in a JSF application as a JSF component.

Open Source Community

The source code of ZK Spreadsheet is available as an open source project on GitHub.^[6]
The project itself relies on Apache POI for accessing Microsoft document format.

Reference List

External links

This article is issued from Wikipedia - version of the 3/2/2016. The text is available under the Creative Commons Attribution/Share Alike but additional terms may apply for the media files.