User:Geckooooo/sandbox

ZK Spreadsheet is an open-source Ajax Web Spreadsheet component created by zkoss.org.

History
Feb. 2008: First beta released on SourceForge Apr. 2009: ZK Spreadsheet 1.0 made available to the public Dec. 2010: 2.0 released supporting charts Nov. 2013: 3.0 released introducing freeze pane and undo/redo Jul. 2014: 3.5 released with API overhaul and performance enhancement May 2015: 3.8 released supporting text orientation and Excel Table format Jul 2016: 3.9 released supporting date, number and text filter Apr 2018: announced Keikai as the next generation of ZK Spreadsheet

Key Features

 * Control in Java
 * Real-time collaboration
 * Access from browsers
 * Import/export Excel xls/xlsx files, leveraging Apache POI
 * Export to PDF
 * Compatible with Excel formulas
 * Compatible with Excel charts

Usage
Typical usages of ZK Spreadsheet:
 * As a spreadsheet component embedded within other Java web applications
 * As a self-hosted collaborative web spreadsheet
 * As a formula-calculation or reporting engine

Integration
Integration is done through ZK Spreadsheet's Java API. Key APIs include: Importer, Range, CellOperationUtil, SheetOperationutil, Exporter

Award
winner of IBM XPages Development Contest

Contribution
ZK Spreadsheet developers contributed fixes to Apache POI