Introduction"

From Documentation
m (correct highlight (via JWB))
 
(12 intermediate revisions by 2 users not shown)
Line 7: Line 7:
 
= Overview =
 
= Overview =
  
ZK Spreadsheet is an AJAX component that delivers Excel-like experience for you Java web application. It has grid-like user interface with toolbar, formula bar, and sheet bar and it provides those necessary features such as editing text and styles, merging, sorting cells and inserting, deleting, and freezing rows and columns. Spreadsheet not only supports over 80% of Excel formulas, and you can even add yours. Some handy features like "auto fill", "auto filter", and protection are also included in Spreadsheet.
+
ZK Spreadsheet is an AJAX component that delivers Excel-like experience for you Java web application. It has a grid-like user interface with toolbar, formula bar, and sheet bar and it provides necessary features such as editing text and styles, merging, sorting cells and inserting, deleting, and freezing rows and columns. Spreadsheet not only supports over 75% of Excel formulas, and can even add your own. Some handy features like "auto fill", "auto filter", and protection are also included in Spreadsheet.
  
Being able to import and export Excel files are just the minimum. Unlike other online spreadsheet such as Google Docs or Microsoft 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 make cells reference to the backend Java beans, so any changes on the backend data can automatically reflect on ZK Spreadsheet. You can create your own customized formulas in Java and use them in the spreadsheet like other built-in formulas. You can even create by yourselves an online spreadsheet service with ZK Spreadsheet component.
+
Being able to import and export Excel files are just the top of the features iceberg. Unlike other online spreadsheet such as Google Docs or Microsoft 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 make cells reference to the backend Java beans, so any changes on the backend data can automatically reflect on ZK Spreadsheet. You can create your own customized formulas in Java and use them in the spreadsheet like other built-in formulas. You can even create an online spreadsheet service with ZK Spreadsheet component.
  
 
ZK Spreadsheet is an extensible, customizable, and integrable Java AJAX web spreadsheet solution, with both built-in browser AJAX user interface and back-end server side Excel-like data and logic. No ActiveX or other plug-ins are required.
 
ZK Spreadsheet is an extensible, customizable, and integrable Java AJAX web spreadsheet solution, with both built-in browser AJAX user interface and back-end server side Excel-like data and logic. No ActiveX or other plug-ins are required.
Line 19: Line 19:
 
ZK Spreadsheet component consists of three major parts -- the client-side UI , the server-side component, and the book data model with the formula evaluation engine. The UI is a grid like widget that you can in-place edit the content of each cell. The component is a server-side instance which your controller usually works with. The data model stores the actual Spreadsheet data. The formula evaluation engine is responsible for formula parsing and calculations.
 
ZK Spreadsheet component consists of three major parts -- the client-side UI , the server-side component, and the book data model with the formula evaluation engine. The UI is a grid like widget that you can in-place edit the content of each cell. The component is a server-side instance which your controller usually works with. The data model stores the actual Spreadsheet data. The formula evaluation engine is responsible for formula parsing and calculations.
  
= Using in JSP & JSF =
+
= Using in JSP or JSF =
You can use Spreadsheet in JSP  with custom tag library and interact with it by JQuery. For JSF, we provides a Spreadsheet JSF component which can be used within a JSF page and interact with other components by AJAX tag.
+
You can use Spreadsheet in JSP  with custom tag library and interact with it by writing Javascript. Please refer to [[ZK Spreadsheet Essentials 3/Using Spreadsheet in JSP| Using Spreadsheet in JSP]] for details. For JSF, we provides a Spreadsheet JSF component which can be used within a JSF page and interact with other components by AJAX tag.  Please refer to [[ZK Spreadsheet Essentials 3/Using Spreadsheet in JSF| Using Spreadsheet in JSF]] for details.
  
 
=Difference from 2.5.0 =
 
=Difference from 2.5.0 =
  
In 3.0.0, we simplify Spreadsheet APIs for accessing books, sheets, and cells, e.g. <javadoc>org.zkoss.zss.api.model.Book</javadoc>, and <javadoc>org.zkoss.zss.api.Range</javadoc>. They are all under <tt>org.zkoss.zss.api.*</tt> and we encourage you to use them.
+
In 3.0.0, we have made some significant changes including new APIs for accessing book model, event name change, and the new way to customize toolbar handling. For complete details, please refer to [http:// upgrade note].
  
 
= The Next =
 
= The Next =
Maybe you would like to [http://zssdemo.zkoss.org/zssdemo/index.zul take a look at Spreadsheet demo] or  
+
Maybe you would like to [http://zssdemo.zkoss.org/zssdemo take a look at Spreadsheet demo] or  
[[ZK Spreadsheet Essentials 3.x/Get Spreadsheet Up and Running Quickly| get Spreadsheet running at your local site ]] and [[ZK_Spreadsheet_Essentials_3/Working_with_Spreadsheet/Control_Components| adjust it upon your requirement]].
+
[[ZK Spreadsheet Essentials 3/Using Spreadsheet in ZK/Get Spreadsheet Up and Running Quickly| get Spreadsheet running at your local site ]].
  
 
= Example Source Code =  
 
= Example Source Code =  
The complete source code of this book can be accessed from [http:// ].
+
The complete source code of this book can be accessed from [https://code.google.com/p/zkbooks/source/browse/#svn%2Fbranches%2Fzssessentials%2F3%2Fzssessentials%253Fstate%253Dclosed google code ].  
The file for download is a zip file which contains a maven project, and there are several Excel files under <tt>/src/main/webapp/WEB-INF/books/</tt> of the project.
+
You can also [https://zkbooks.googlecode.com/files/zssessentialsProject-3.0.0.RC.zip download the whole project file] as a zip file which contains a maven project or [https://zkbooks.googlecode.com/files/zssessentials-3.0.0.RC.war a WAR file] for deployment, and there are several Excel files under <code>/src/main/webapp/WEB-INF/books/</code> of the project.
 +
 
 +
 
 +
 
 +
 
 +
{{ZKSpreadsheetEssentialsPageFooter}}

Latest revision as of 12:44, 19 January 2022



Overview

ZK Spreadsheet is an AJAX component that delivers Excel-like experience for you Java web application. It has a grid-like user interface with toolbar, formula bar, and sheet bar and it provides necessary features such as editing text and styles, merging, sorting cells and inserting, deleting, and freezing rows and columns. Spreadsheet not only supports over 75% of Excel formulas, and can even add your own. Some handy features like "auto fill", "auto filter", and protection are also included in Spreadsheet.

Being able to import and export Excel files are just the top of the features iceberg. Unlike other online spreadsheet such as Google Docs or Microsoft 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 make cells reference to the backend Java beans, so any changes on the backend data can automatically reflect on ZK Spreadsheet. You can create your own customized formulas in Java and use them in the spreadsheet like other built-in formulas. You can even create an online spreadsheet service with ZK Spreadsheet component.

ZK Spreadsheet is an extensible, customizable, and integrable Java AJAX web spreadsheet solution, with both built-in browser AJAX user interface and back-end server side Excel-like data and logic. No ActiveX or other plug-ins are required.

Architecture

Essentials-architecture.png

ZK Spreadsheet component consists of three major parts -- the client-side UI , the server-side component, and the book data model with the formula evaluation engine. The UI is a grid like widget that you can in-place edit the content of each cell. The component is a server-side instance which your controller usually works with. The data model stores the actual Spreadsheet data. The formula evaluation engine is responsible for formula parsing and calculations.

Using in JSP or JSF

You can use Spreadsheet in JSP with custom tag library and interact with it by writing Javascript. Please refer to Using Spreadsheet in JSP for details. For JSF, we provides a Spreadsheet JSF component which can be used within a JSF page and interact with other components by AJAX tag. Please refer to Using Spreadsheet in JSF for details.

Difference from 2.5.0

In 3.0.0, we have made some significant changes including new APIs for accessing book model, event name change, and the new way to customize toolbar handling. For complete details, please refer to [http:// upgrade note].

The Next

Maybe you would like to take a look at Spreadsheet demo or get Spreadsheet running at your local site .

Example Source Code

The complete source code of this book can be accessed from google code . You can also download the whole project file as a zip file which contains a maven project or a WAR file for deployment, and there are several Excel files under /src/main/webapp/WEB-INF/books/ of the project.



All source code listed in this book is at Github.


Last Update : 2022/01/19

Copyright © Potix Corporation. This article is licensed under GNU Free Documentation License.