User:Sphota/sandbox

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 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 and was awarded 2nd 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 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 supported by ZK Spreadsheet are compatible with their Microsoft Excel counter parts. 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. The project itself relies on Apache POI for accessing Microsoft document format.