Set Dimension of the Sheet"
From Documentation
m (→ZUML Example) |
m |
||
| Line 20: | Line 20: | ||
</div> | </div> | ||
</zk> | </zk> | ||
| + | </source> | ||
| + | |||
| + | ===Sheet name=== | ||
| + | We can get number of sheet from Book, and we can get sheet name by index. | ||
| + | <source lang="java" high="5,7"> | ||
| + | Combobox sheets; | ||
| + | Spreadsheet spreadsheet; | ||
| + | |||
| + | public void doAfterCompose(Component comp) throws Exception { | ||
| + | super.doAfterCompose(comp); | ||
| + | |||
| + | List<String> sheetNames = new ArrayList<String>(); | ||
| + | int sheetSize = spreadsheet.getBook().getNumberOfSheets(); | ||
| + | for (int i = 0; i < sheetSize; i++){ | ||
| + | sheetNames.add(spreadsheet.getSheet(i).getSheetName()); | ||
| + | } | ||
| + | |||
| + | BindingListModelList model = new BindingListModelList(sheetNames, true); | ||
| + | sheets.setModel(model); | ||
| + | } | ||
</source> | </source> | ||
Revision as of 11:32, 18 November 2010
ZK Spreadsheet can switch different sheet using Spreadsheet.setSelectedSheet();
Scenario
We use combobox to represent different sheets, user can click on it and select sheet.
ZUML Example
<zk>
<div height="100%" width="100%" apply="demo.SheetsComposer">
<combobox id="sheets"></combobox>
<spreadsheet id="spreadsheet" src="/demo_sample.xls"
maxrows="200"
maxcolumns="40"
width="100%"
height="450px"></spreadsheet>
</div>
</zk>
Sheet name
We can get number of sheet from Book, and we can get sheet name by index.
Combobox sheets;
Spreadsheet spreadsheet;
public void doAfterCompose(Component comp) throws Exception {
super.doAfterCompose(comp);
List<String> sheetNames = new ArrayList<String>();
int sheetSize = spreadsheet.getBook().getNumberOfSheets();
for (int i = 0; i < sheetSize; i++){
sheetNames.add(spreadsheet.getSheet(i).getSheetName());
}
BindingListModelList model = new BindingListModelList(sheetNames, true);
sheets.setModel(model);
}
Version History
| Version | Date | Content |
|---|---|---|
All source code listed in this book is at Github.