Working with Spreadsheet"

From Documentation
 
(6 intermediate revisions by the same user not shown)
Line 7: Line 7:
 
__TOC__
 
__TOC__
  
Just like other ZK components, you can control Spreadsheet via its APIs programmatically, and register event listeners to act on specific events in order to perform customized business logic. Besides that, its model classes (<javadoc>Book</javadoc> and <javadoc>Sheet</javadoc>) and utility classes (<javadoc directory="zss">org.zkoss.zss.api.Ranges</javadoc> and <javadoc directory="zss">org.zkoss.zss.api.Range</javadoc>) can be used to change Spreadsheet's book model and the UI will be updated automatically. With above utilities, you can customize Spreadsheet furthermore upon your requirement. Over and above, you can create your own customized formulas in Java and use them as other built-in formulas.
+
Just like other ZK components, you can control Spreadsheet via its APIs programmatically and register event listeners to act on specific events in order to perform customized business logic. Besides that, its model classes (<javadoc directory="zss">org.zkoss.zss.api.model.Book</javadoc> and <javadoc directory="zss">org.zkoss.zss.api.model.Sheet</javadoc>) and utility classes (<javadoc directory="zss">org.zkoss.zss.api.Ranges</javadoc> and <javadoc directory="zss">org.zkoss.zss.api.Range</javadoc>) can be used to change Spreadsheet's book model and the UI will be updated automatically. With above API, you can customize Spreadsheet furthermore upon your requirement. Besides, you can create your own customized functions in Java and use them as other built-in functions.
  
In addition to run a standalone Spreadsheet, you can also integrate Spreadsheet with your back-end server databases and resources easily. Moreover, You can make cells reference to another Spreadsheet's data model, the back-end Java beans, and Spring-managed beans. So, any changes on the back-end data will automatically reflect on Spreadsheet.  
+
In addition to run a standalone Spreadsheet, you can also integrate Spreadsheet with your back-end server databases and resources easily. Moreover, You can make cells reference to another Spreadsheet's data model, the back-end JavaBeans, and Spring-managed beans. So, any changes on the back-end data will automatically reflect on Spreadsheet.  
  
In the following sections, we will show you how to use such APIs, how to register event listeners, and how to control the Spreadsheet component.
+
In the following sections, we will show you the capability of Spreadsheet API under ZK framework including how to control the Spreadsheet component, how to register event listeners, and how to hande Spreadsheet data model. Actually, those APIs about handling data model can also be used in JSP and JSF.
  
  

Latest revision as of 03:44, 2 April 2014


Working with Spreadsheet






Just like other ZK components, you can control Spreadsheet via its APIs programmatically and register event listeners to act on specific events in order to perform customized business logic. Besides that, its model classes (Book and Sheet) and utility classes (Ranges and Range) can be used to change Spreadsheet's book model and the UI will be updated automatically. With above API, you can customize Spreadsheet furthermore upon your requirement. Besides, you can create your own customized functions in Java and use them as other built-in functions.

In addition to run a standalone Spreadsheet, you can also integrate Spreadsheet with your back-end server databases and resources easily. Moreover, You can make cells reference to another Spreadsheet's data model, the back-end JavaBeans, and Spring-managed beans. So, any changes on the back-end data will automatically reflect on Spreadsheet.

In the following sections, we will show you the capability of Spreadsheet API under ZK framework including how to control the Spreadsheet component, how to register event listeners, and how to hande Spreadsheet data model. Actually, those APIs about handling data model can also be used in JSP and JSF.




All source code listed in this book is at Github.


Last Update : 2014/04/02

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