org.zkoss.zss.model
Interface Worksheet

All Superinterfaces:

java.lang.Iterable<org.zkoss.poi.ss.usermodel.Row>, org.zkoss.poi.ss.usermodel.Sheet

All Known Implementing Classes:

HSSFSheetImpl, XSSFSheetImpl

public interface Worksheet
extends org.zkoss.poi.ss.usermodel.Sheet

ZK Spreadsheet sheet.

Author:

henrichen

Field Summary

Fields inherited from interface org.zkoss.poi.ss.usermodel.Sheet

BottomMargin, FooterMargin, HeaderMargin, LeftMargin, PANE_LOWER_LEFT, PANE_LOWER_RIGHT, PANE_UPPER_LEFT, PANE_UPPER_RIGHT, RightMargin, TopMargin

Method Summary

Book	getBook() Returns the associated ZK Spreadsheet Book of this ZK Spreadsheet Sheet.
java.util.List<org.zkoss.poi.ss.usermodel.Chart>	getCharts() Returns charts in this ZK Spreadsheet sheet.
java.util.List<org.zkoss.poi.ss.usermodel.DataValidation>	getDataValidations() Returns validations in this ZK Spreadsheet sheet.
java.util.List<org.zkoss.poi.ss.usermodel.Picture>	getPictures() Returns pictures in this ZK Spreadsheet sheet.
java.util.List<org.zkoss.poi.ss.usermodel.PivotTable>	getPivotTables() Returns

Methods inherited from interface org.zkoss.poi.ss.usermodel.Sheet

addMergedRegion, addValidationData, autoSizeColumn, autoSizeColumn, createDrawingPatriarch, createFreezePane, createFreezePane, createPivotTable, createRow, createSplitPane, getAutobreaks, getAutoFilter, getCellComment, getColumnBreaks, getColumnStyle, getColumnWidth, getDataValidation, getDataValidationHelper, getDefaultColumnWidth, getDefaultRowHeight, getDefaultRowHeightInPoints, getDisplayGuts, getFirstRowNum, getFitToPage, getFooter, getForceFormulaRecalculation, getHeader, getHorizontallyCenter, getLastRowNum, getLeftCol, getMargin, getMergedRegion, getNumMergedRegions, getPaneInformation, getPhysicalNumberOfRows, getPrintSetup, getProtect, getRow, getRowBreaks, getRowSumsBelow, getRowSumsRight, getScenarioProtect, getSheetConditionalFormatting, getSheetName, getTopRow, getVerticallyCenter, getWorkbook, groupColumn, groupRow, isAutoFilterMode, isColumnBroken, isColumnHidden, isDisplayFormulas, isDisplayGridlines, isDisplayRowColHeadings, isDisplayZeros, isPrintGridlines, isRightToLeft, isRowBroken, isSelected, protectSheet, removeArrayFormula, removeAutoFilter, removeColumnBreak, removeMergedRegion, removeRow, removeRowBreak, removeValidationData, rowIterator, setArrayFormula, setAutobreaks, setAutoFilter, setColumnBreak, setColumnGroupCollapsed, setColumnHidden, setColumnWidth, setDefaultColumnStyle, setDefaultColumnWidth, setDefaultRowHeight, setDefaultRowHeightInPoints, setDisplayFormulas, setDisplayGridlines, setDisplayGuts, setDisplayRowColHeadings, setDisplayZeros, setFitToPage, setForceFormulaRecalculation, setHorizontallyCenter, setMargin, setPrintGridlines, setRightToLeft, setRowBreak, setRowGroupCollapsed, setRowSumsBelow, setRowSumsRight, setSelected, setVerticallyCenter, setZoom, shiftRows, shiftRows, showInPane, ungroupColumn, ungroupRow

Methods inherited from interface java.lang.Iterable

iterator

Method Detail

getBook

Book getBook()

Returns the associated ZK Spreadsheet Book of this ZK Spreadsheet Sheet.

Returns:

the associated ZK Spreadsheet Book of this ZK Spreadsheet Sheet.

getPictures

java.util.List<org.zkoss.poi.ss.usermodel.Picture> getPictures()

Returns pictures in this ZK Spreadsheet sheet.

Returns:

pictures in this ZK Spreadsheet sheet.

getCharts

java.util.List<org.zkoss.poi.ss.usermodel.Chart> getCharts()

Returns charts in this ZK Spreadsheet sheet.

Returns:

charts in this ZK Spreadsheet sheet.

getDataValidations

java.util.List<org.zkoss.poi.ss.usermodel.DataValidation> getDataValidations()

Returns validations in this ZK Spreadsheet sheet.

Specified by:

getDataValidations in interface org.zkoss.poi.ss.usermodel.Sheet

Returns:

validations in this ZK Spreadsheet sheet.

getPivotTables

java.util.List<org.zkoss.poi.ss.usermodel.PivotTable> getPivotTables()

Returns

Specified by:

getPivotTables in interface org.zkoss.poi.ss.usermodel.Sheet

Returns: