From Documentation

Jump to: navigation, search




  • Author
    Henri Chen, Principal Engineer, Potix Corporation
  • Date
    July 30, 2010
  • Version
    ZK 5.0 & ZK Spreadsheet 2.0 Beta2

Contents

Introduction

ZK Spreadsheet is an Ajax component that delivers the rich functionality of Excel on the Java Web application.

Being able to import and export Excel files are just the minimum. Unlike other on-line spreadsheet such as Google Docs or Office 2010 online suite, you can integrate ZK Spreadsheet with your enterprise back-end systems seamlessly and create collaborative and dynamic enterprise applications at minimal cost. You can call versatile Java APIs to control and configure the ZK Spreadsheet component(s). You can register event listeners so an action can be automatically triggered if any specified cell, range, or name changes. You can bind cells to the back-end Java beans, so any changes on the back-end data would be automatically reflected on the ZK Spreadsheet. You can create your own spreadsheet functions in Java and use them in the spreadsheet formulas. Actually, if you like, you can even create by yourselves an on line spreadsheet service with ZK Spreadsheet component.

ZK Spreadsheet is an extensible, customizable, and integratable Java Ajax Web spreadsheet solution, with both built in browser Ajax user interface and back-end server side Excel-like data and logic. None of ActiveX or plug-ins is needed.

Features

Since ZK Spreadsheet 2.0, we have changed the back-end data model from proprietary implementation(ZK Spreadsheet 1.0) to Apache POI for better scalability and more features.

With this POI-based 2.0, Excel 2007, hyperlink, rich text, row and column moving, hiding and un-hiding row/column headers, sorting, filtering, and many other features has been implemented:

Rich Texts and Bullet Texts in a Cell

ZK Spreadsheet can show rich texts and bullet texts in a cell. That is, you can show different font sizes, colors, and styles of texts in a cell.


Hide/Unhide Row Headers and/or Column Headers

As a component, sometimes you just do not want to see the row/column headers in the application.


Hyperlink Follow-up

If a hyperlink or HYPERLINK function is inputted in a spreadsheet cell, end user can click on the cell text to follow up the hyperlink. If you simply want to select the cell but not follow up the hyperlink, you have to click on the empty space of the cell or press and hold the cell until the mouse cursor changes. Besides that, ZK Spreadsheet also fire an onHyperlink event so application developer can do further operations if any.


Sort Rows/Columns

You can sort rows, columns, or a specified area.


Drag and Drop Editing of Rows/Columns/Area

You can drag rows, columns, or a specified area to its destination.


Insert Rows/Columns/Area

You can insert rows, columns, or a specified area. You can decide whether you want to shift cells down or shift cells right the inserted area.

Delete Rows/Columns/Area

You can delete rows, columns, or a specified area. You can decide whether you want to shift cells up or shift cells left the deleted area.


Downloads

ZK Spreadsheet 2.0 Beta2

Other Resource and Links

New Features of ZK Spreadsheet 1.0.0 RC2

New Features of ZK Spreadsheet 1.0.0 RC

Various Functions in Spreadsheet

Generate Huge Data Report in a Second

Integrate ZK Spreadsheet with Spring

Change the Style of Spreadsheet within 1 Min

Use JavaBean in Excel with ZK Spreadsheet

How to Build a Rich Excel Report with ZK Spreadsheet

A Preview Of ZK Spreadsheet 1.0(with live demo)



Copyright © Potix Corporation. This article is licensed under GNU Free Documentation License.
You got stuck here?
Let us know why!
For questions please use the forum