The ZK Spreadsheet Component"

From Documentation
m (Created page with '{{ZKCalendarEssentialsPageHeader}} ===The ZK Spreadsheet Component=== In this section, a brief overview is given on how developers work with the ZK Spreadsheet component. ====The…')
 
 
(25 intermediate revisions by 5 users not shown)
Line 1: Line 1:
{{ZKCalendarEssentialsPageHeader}}
+
{{ZKSpreadsheetEssentialsPageHeader}}
===The ZK Spreadsheet Component===
+
 
In this section, a brief overview is given on how developers work with the ZK Spreadsheet component.
+
 
====The Bare Spreadsheet Component====
+
{{Deprecated|url=http://books.zkoss.org/wiki/ZK_Spreadsheet_Essentials}}
----
+
 
 +
 
 +
__TOC__
 +
===Purpose===
 +
A brief overview on how to work with the ZK Spreadsheet component.
 +
 
 +
===ZUML===
 +
 
 
ZK Spreadsheet is a single ZK component. Developers could declare it within any ZK container components, such as Window,  tabs, groupbox, etc.
 
ZK Spreadsheet is a single ZK component. Developers could declare it within any ZK container components, such as Window,  tabs, groupbox, etc.
  
 
For example:<br>
 
For example:<br>
 
<source lang="xml">
 
<source lang="xml">
<window title="Bare ZK Spreadsheet" border="normal" height="600px">
+
<window title="Bare ZK Spreadsheet" border="normal" height="500px">
 
<spreadsheet src="/demo_sample.xls"
 
<spreadsheet src="/demo_sample.xls"
 
maxrows="200"  
 
maxrows="200"  
 
maxcolumns="40"
 
maxcolumns="40"
width="500px"
+
width="100%"
height="300px"></spreadsheet>
+
height="450px"></spreadsheet>
 
</window>
 
</window>
 
</source>
 
</source>
which renders:<br/>
+
Note: View the complete source of ZUML [http://code.google.com/p/zkbooks/source/browse/trunk/zssessentials/examples/WebContent/gettingstarted/bare.zul here]
[[Image: bareSpreadsheet.png]]<br/>
 
  
====Spreadsheet Component Attributes====
 
----
 
 
Developers customize the spreadsheet component by declaring its attributes, for example:
 
Developers customize the spreadsheet component by declaring its attributes, for example:
 
*the source file of the spreadsheet, for example src="/demo_sample.xls"
 
*the source file of the spreadsheet, for example src="/demo_sample.xls"
 
*the maximum number of rows of this spread sheet, for example maxrows="200"  
 
*the maximum number of rows of this spread sheet, for example maxrows="200"  
 
*the maximum number of columns of  this spread sheet, for example maxcolumns="40"
 
*the maximum number of columns of  this spread sheet, for example maxcolumns="40"
*size of the spreadsheet component, for example: width="500px" height="300px"
+
*the size of the spreadsheet component, for example: width="500px" height="300px"
 +
 
 +
 
 +
which renders:<br/>
 +
[[Image: bareSpreadsheet.png]]<br/>
 +
[https://code.google.com/p/zkbooks/source/browse/trunk/zssessentials/examples/WebContent/gettingstarted/bare.zul bare.zul]
 +
 
 +
=Version History=
 +
{{LastUpdated}}
 +
{| border='1px' | width="100%"
 +
! Version !! Date !! Content
 +
|-
 +
| &nbsp;
 +
| &nbsp;
 +
| &nbsp;
 +
|}
 +
 
 +
{{ZKSpreadsheetEssentialsPageFooter}}

Latest revision as of 06:35, 22 August 2013


The ZK Spreadsheet Component




Stop.png This article is out of date, please refer to http://books.zkoss.org/wiki/ZK_Spreadsheet_Essentials for more up to date information.


Purpose

A brief overview on how to work with the ZK Spreadsheet component.

ZUML

ZK Spreadsheet is a single ZK component. Developers could declare it within any ZK container components, such as Window, tabs, groupbox, etc.

For example:

<window title="Bare ZK Spreadsheet" border="normal" height="500px">
<spreadsheet src="/demo_sample.xls"	
			maxrows="200" 
			maxcolumns="40"
			width="100%"
			height="450px"></spreadsheet>
</window>

Note: View the complete source of ZUML here

Developers customize the spreadsheet component by declaring its attributes, for example:

  • the source file of the spreadsheet, for example src="/demo_sample.xls"
  • the maximum number of rows of this spread sheet, for example maxrows="200"
  • the maximum number of columns of this spread sheet, for example maxcolumns="40"
  • the size of the spreadsheet component, for example: width="500px" height="300px"


which renders:
BareSpreadsheet.png
bare.zul

Version History

Last Update : 2013/08/22


Version Date Content
     


All source code listed in this book is at Github.


Last Update : 2013/08/22

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