Handling Data Model"
From Documentation
m (correct highlight (via JWB)) |
|||
(One intermediate revision by the same user not shown) | |||
Line 5: | Line 5: | ||
Spreadsheet data model is the place where all Spreadsheet cell data stores. Spreadsheet is like a painter which paints its data model in grid-like layout for you. Every action you take on a Spreadsheet (e.g. insertion or deletion) involves a change to its data model. The following sections introduce those APIs to handle a Spreadsheet data model by corresponding user action. | Spreadsheet data model is the place where all Spreadsheet cell data stores. Spreadsheet is like a painter which paints its data model in grid-like layout for you. Every action you take on a Spreadsheet (e.g. insertion or deletion) involves a change to its data model. The following sections introduce those APIs to handle a Spreadsheet data model by corresponding user action. | ||
− | For each cell/row/column operation, you need to get a Range object. The helper class < | + | For each cell/row/column operation, you need to get a Range object. The helper class <code>Ranges</code> supports various methods to create a Range object like: |
<source lang='java'> | <source lang='java'> | ||
+ | // a book | ||
+ | Ranges.range(spreadsheet.getBook()); | ||
+ | // a sheet | ||
+ | Ranges.range(spreadsheet.getSelectedSheet()); | ||
+ | // a row | ||
+ | Ranges.range(spreadsheet.getSelectedSheet(), "A1").toRowRange(); | ||
+ | // multiple cells | ||
+ | Ranges.range(spreadsheet.getSelectedSheet(), "A1:B4"); | ||
+ | Ranges.range(spreadsheet.getSelectedSheet(), 0, 0, 3, 1); | ||
+ | // a cell | ||
+ | Ranges.range(spreadsheet.getSelectedSheet(), 3, 3); | ||
</source> | </source> | ||
{{ZKSpreadsheetEssentials3HeadingToc}} | {{ZKSpreadsheetEssentials3HeadingToc}} | ||
{{ZKSpreadsheetEssentialsPageFooter}} | {{ZKSpreadsheetEssentialsPageFooter}} |
Latest revision as of 12:51, 19 January 2022
Spreadsheet data model is the place where all Spreadsheet cell data stores. Spreadsheet is like a painter which paints its data model in grid-like layout for you. Every action you take on a Spreadsheet (e.g. insertion or deletion) involves a change to its data model. The following sections introduce those APIs to handle a Spreadsheet data model by corresponding user action.
For each cell/row/column operation, you need to get a Range object. The helper class Ranges
supports various methods to create a Range object like:
// a book
Ranges.range(spreadsheet.getBook());
// a sheet
Ranges.range(spreadsheet.getSelectedSheet());
// a row
Ranges.range(spreadsheet.getSelectedSheet(), "A1").toRowRange();
// multiple cells
Ranges.range(spreadsheet.getSelectedSheet(), "A1:B4");
Ranges.range(spreadsheet.getSelectedSheet(), 0, 0, 3, 1);
// a cell
Ranges.range(spreadsheet.getSelectedSheet(), 3, 3);
All source code listed in this book is at Github.