Working with Spreadsheet"

From Documentation
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
 
{{ZKSpreadsheetEssentials3.xPageHeader}}
 
{{ZKSpreadsheetEssentials3.xPageHeader}}
  
brief introduce following sections
 
* configure via xml
 
* control with API
 
* register event listener
 
* reference another book
 
* reference java Bean
 
  
  
= component api =
 
brief introduce some commonly-used API
 
* setSelectedSheet(String)
 
* getBook()
 
<javadoc>org.zkoss.zss.ui.Spreadsheet</javadoc>
 
  
 +
 +
__TOC__
  
== change sheet example ==
+
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, a core utility class, <javadoc directory="zss">org.zkoss.zss.api.Range</javadoc>, can be used to change the Spreadsheet data model and update the UI 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.
  
 +
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.
  
= spreadsheet model =
+
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.
* book
 
* sheet
 
* cell
 
* Range
 

Latest revision as of 08:12, 28 June 2013


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, a core utility class, Range, can be used to change the Spreadsheet data model and update the UI 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.

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 the following sections, we will show you how to use such APIs, how to register event listeners, and how to control the Spreadsheet component.