Uses of Package
org.zkoss.poi.ss.usermodel

Packages that use org.zkoss.poi.ss.usermodel

Package	Description
org.zkoss.poi.hssf.converter
org.zkoss.poi.hssf.extractor
org.zkoss.poi.hssf.usermodel	usermodel package maps HSSF low level strutures to familiar workbook/sheet model Related Documentation For overviews, tutorials, examples, guides, and tool documentation, please see: Apache POI Project
org.zkoss.poi.hssf.util	util package contains tools needed for writing HSSF files that are not necesarily "real" HSSF concepts.
org.zkoss.poi.ss.format	This package contains classes that implement cell formatting
org.zkoss.poi.ss.formula	This package contains common internal POI code for manipulating formulas.
org.zkoss.poi.ss.formula.eval
org.zkoss.poi.ss.formula.eval.forked
org.zkoss.poi.ss.usermodel
org.zkoss.poi.ss.usermodel.charts
org.zkoss.poi.ss.util
org.zkoss.poi.ss.util.cellwalk
org.zkoss.poi.xssf.eventusermodel
org.zkoss.poi.xssf.streaming
org.zkoss.poi.xssf.usermodel
org.zkoss.poi.xssf.usermodel.charts
org.zkoss.poi.xssf.usermodel.extensions
org.zkoss.poi.xssf.usermodel.helpers
org.zkoss.zpoiex.ss.usermodel.helpers
org.zkoss.zss.range.impl.imexp	ZK Spreadsheet Internal Range API Implementation classes.

Classes in org.zkoss.poi.ss.usermodel used by org.zkoss.poi.hssf.converter

Class and Description
CellStyle

Classes in org.zkoss.poi.ss.usermodel used by org.zkoss.poi.hssf.extractor

Class and Description
HeaderFooter Common interface for Header and Footer.

Classes in org.zkoss.poi.ss.usermodel used by org.zkoss.poi.hssf.usermodel

Class and Description
AutoFilter Represents autofiltering for the specified worksheet.
BorderFormatting
Cell High level representation of a cell in a row of a spreadsheet.
CellRange Represents a rectangular region of a Sheet
CellStyle
CellValue Mimics the 'data view' of a cell.
Chart High level representation of a chart.
ChartInfo Information regarding chart.
ClientAnchor A client anchor is attached to an excel worksheet.
Color
ColorFilter
Combo High level representation of a drop down list of a filter.
Comment
ConditionalFormatting The ConditionalFormatting class encapsulates all settings of Conditional Formatting.
ConditionalFormattingRule Represents a description of a conditional formatting rule
CreationHelper An object that handles instantiating concrete classes of the various instances one needs for HSSF and XSSF.
CustomFilters
DataFormat
DataFormatter DataFormatter contains methods for formatting the value stored in an Cell.
DataValidation
DataValidationConstraint
DataValidationHelper
DateUtil Contains methods for dealing with Excel dates.
Drawing High level representation of spreadsheet drawing.
DxfCellStyle Cell style for Dxfs
DynamicFilter
ErrorConstants Contains raw Excel error codes (as defined in OOO's excelfileformat.pdf (2.5.6)
FilterColumn Represent a filtered column.
Font
FontFormatting High level representation for Font Formatting component of Conditional Formatting settings
Footer Common definition of a HSSF or XSSF page footer.
FormulaEvaluator Evaluates formula cells.
Header Common definition of a HSSF or XSSF page header.
HeaderFooter Common interface for Header and Footer.
Hyperlink Represents an Excel hyperlink.
Name Represents a defined name for a range of cells.
NamedStyle CellStyle with a name.
PatternFormatting
Picture Repersents a picture in a SpreadsheetML document
PictureData
PivotCache
PivotTable
PrintSetup
RichTextString Rich text unicode string.
Row High level representation of a row of a spreadsheet.
Row.MissingCellPolicy Used to specify the different possible policies if for the case of null and blank cells
Sheet High level representation of a Excel worksheet.
SheetConditionalFormatting The 'Conditional Formatting' facet of Sheet
SheetProtection Enhanced sheet protection.
TableStyle
Top10Filter
Workbook High level representation of a Excel workbook.
ZssChartX Represents a chart in a SpreadsheetML document

Classes in org.zkoss.poi.ss.usermodel used by org.zkoss.poi.hssf.util

Class and Description
Color

Classes in org.zkoss.poi.ss.usermodel used by org.zkoss.poi.ss.format

Class and Description
Cell High level representation of a cell in a row of a spreadsheet.

Classes in org.zkoss.poi.ss.usermodel used by org.zkoss.poi.ss.formula

Class and Description
FormulaEvaluator Evaluates formula cells.
Hyperlink Represents an Excel hyperlink.

Classes in org.zkoss.poi.ss.usermodel used by org.zkoss.poi.ss.formula.eval

Class and Description
Hyperlink Represents an Excel hyperlink.

Classes in org.zkoss.poi.ss.usermodel used by org.zkoss.poi.ss.formula.eval.forked

Class and Description
Workbook High level representation of a Excel workbook.

Classes in org.zkoss.poi.ss.usermodel used by org.zkoss.poi.ss.usermodel

Class and Description
AutoFilter Represents autofiltering for the specified worksheet.
BorderFormatting
BorderStyle The enumeration value indicating the line style of a border in a cell, i.e., whether it is borded dash dot, dash dot dot, dashed, dotted, double, hair, medium, medium dash dot, medium dash dot dot, medium dashed, none, slant dash dot, thick or thin.
Calculation
Cell High level representation of a cell in a row of a spreadsheet.
CellRange Represents a rectangular region of a Sheet
CellStyle
CellValue Mimics the 'data view' of a cell.
Chart High level representation of a chart.
ChartInfo Information regarding chart.
ClientAnchor A client anchor is attached to an excel worksheet.
Color
ColorFilter
Comment
ConditionalFormatting The ConditionalFormatting class encapsulates all settings of Conditional Formatting.
ConditionalFormattingRule Represents a description of a conditional formatting rule
CreationHelper An object that handles instantiating concrete classes of the various instances one needs for HSSF and XSSF.
CustomFilter CustomFilter
CustomFilter.Operator
CustomFilters
DataField
DataFormat
DataValidation
DataValidationConstraint
DataValidationHelper
Drawing High level representation of spreadsheet drawing.
DxfCellStyle Cell style for Dxfs
DynamicFilter
FillPatternType The enumeration value indicating the style of fill pattern being used for a cell format.
FilterColumn Represent a filtered column.
Font
FontCharset Charset represents the basic set of characters associated with a font (that it can display), and corresponds to the ANSI codepage (8-bit or DBCS) of that character set used by a given language.
FontFamily The font family this font belongs to.
FontFormatting High level representation for Font Formatting component of Conditional Formatting settings
FontScheme Defines the font scheme to which this font belongs.
FontUnderline the different types of possible underline formatting
Footer Common definition of a HSSF or XSSF page footer.
FormulaError Enumerates error values in SpreadsheetML formula calculations.
FormulaEvaluator Evaluates formula cells.
Header Common definition of a HSSF or XSSF page header.
HeaderFooter Common interface for Header and Footer.
HorizontalAlignment The enumeration value indicating horizontal alignment of a cell, i.e., whether it is aligned general, left, right, horizontally centered, filled (replicated), justified, centered across multiple cells, or distributed.
Hyperlink Represents an Excel hyperlink.
IndexedColors A deprecated indexing scheme for colours that is still required for some records, and for backwards compatibility with OLE2 formats.
Name Represents a defined name for a range of cells.
NamedStyle CellStyle with a name.
PageOrder Specifies printed page order.
PaperSize The enumeration value indicating the possible paper size for a sheet
PatternFormatting
Picture Repersents a picture in a SpreadsheetML document
PictureData
PivotCache
PivotCache.CacheField
PivotCache.CacheRecord
PivotCache.SheetSource
PivotField
PivotField.FieldGroup
PivotField.Item
PivotField.Item.Type
PivotField.SortType
PivotField.Type
PivotTable
PrintCellComments These enumerations specify how cell comments shall be displayed for paper printing purposes.
PrintOrientation The enumeration value indicating the print orientation for a sheet.
PrintSetup
RichTextString Rich text unicode string.
Row High level representation of a row of a spreadsheet.
Row.MissingCellPolicy Used to specify the different possible policies if for the case of null and blank cells
Sheet High level representation of a Excel worksheet.
SheetConditionalFormatting The 'Conditional Formatting' facet of Sheet
SheetProtection Enhanced sheet protection.
TableStyle
Top10Filter
VerticalAlignment This enumeration value indicates the type of vertical alignment for a cell, i.e., whether it is aligned top, bottom, vertically centered, justified or distributed.
Workbook High level representation of a Excel workbook.
ZssChartX Represents a chart in a SpreadsheetML document
ZssContext ZK Spreadsheet context for cell evaluation, etc. for Locale and Two Digit Year interpretation.

Classes in org.zkoss.poi.ss.usermodel used by org.zkoss.poi.ss.usermodel.charts

Class and Description
Chart High level representation of a chart.
Sheet High level representation of a Excel worksheet.

Classes in org.zkoss.poi.ss.usermodel used by org.zkoss.poi.ss.util

Class and Description
Cell High level representation of a cell in a row of a spreadsheet.
CellRange Represents a rectangular region of a Sheet
CellStyle
DataFormatter DataFormatter contains methods for formatting the value stored in an Cell.
Font
PivotField.Item.Type
Row High level representation of a row of a spreadsheet.
Sheet High level representation of a Excel worksheet.
Workbook High level representation of a Excel workbook.

Classes in org.zkoss.poi.ss.usermodel used by org.zkoss.poi.ss.util.cellwalk

Class and Description
Cell High level representation of a cell in a row of a spreadsheet.
Sheet High level representation of a Excel worksheet.

Classes in org.zkoss.poi.ss.usermodel used by org.zkoss.poi.xssf.eventusermodel

Class and Description
DataFormatter DataFormatter contains methods for formatting the value stored in an Cell.

Classes in org.zkoss.poi.ss.usermodel used by org.zkoss.poi.xssf.streaming

Class and Description
AutoFilter Represents autofiltering for the specified worksheet.
Cell High level representation of a cell in a row of a spreadsheet.
CellRange Represents a rectangular region of a Sheet
CellStyle
Comment
CreationHelper An object that handles instantiating concrete classes of the various instances one needs for HSSF and XSSF.
DataFormat
DataValidation
DataValidationHelper
Drawing High level representation of spreadsheet drawing.
DxfCellStyle Cell style for Dxfs
Font
Footer Common definition of a HSSF or XSSF page footer.
Header Common definition of a HSSF or XSSF page header.
Hyperlink Represents an Excel hyperlink.
Name Represents a defined name for a range of cells.
NamedStyle CellStyle with a name.
PictureData
PivotCache
PivotTable
PrintSetup
RichTextString Rich text unicode string.
Row High level representation of a row of a spreadsheet.
Row.MissingCellPolicy Used to specify the different possible policies if for the case of null and blank cells
Sheet High level representation of a Excel worksheet.
SheetConditionalFormatting The 'Conditional Formatting' facet of Sheet
SheetProtection Enhanced sheet protection.
TableStyle
Workbook High level representation of a Excel workbook.

Classes in org.zkoss.poi.ss.usermodel used by org.zkoss.poi.xssf.usermodel

Class and Description
AutoFilter Represents autofiltering for the specified worksheet.
BorderFormatting
BorderStyle The enumeration value indicating the line style of a border in a cell, i.e., whether it is borded dash dot, dash dot dot, dashed, dotted, double, hair, medium, medium dash dot, medium dash dot dot, medium dashed, none, slant dash dot, thick or thin.
Calculation
Cell High level representation of a cell in a row of a spreadsheet.
CellRange Represents a rectangular region of a Sheet
CellStyle
CellValue Mimics the 'data view' of a cell.
Chart High level representation of a chart.
ChartInfo Information regarding chart.
ClientAnchor A client anchor is attached to an excel worksheet.
Color
ColorFilter
Combo High level representation of a drop down list of a filter.
Comment
ConditionalFormatting The ConditionalFormatting class encapsulates all settings of Conditional Formatting.
ConditionalFormattingRule Represents a description of a conditional formatting rule
CreationHelper An object that handles instantiating concrete classes of the various instances one needs for HSSF and XSSF.
CustomFilter CustomFilter
CustomFilter.Operator
CustomFilters
DataField
DataFormat
DataValidation
DataValidationConstraint
DataValidationHelper
Drawing High level representation of spreadsheet drawing.
DxfCellStyle Cell style for Dxfs
DynamicFilter
FillPatternType The enumeration value indicating the style of fill pattern being used for a cell format.
FilterColumn Represent a filtered column.
Font
FontCharset Charset represents the basic set of characters associated with a font (that it can display), and corresponds to the ANSI codepage (8-bit or DBCS) of that character set used by a given language.
FontFamily The font family this font belongs to.
FontFormatting High level representation for Font Formatting component of Conditional Formatting settings
FontScheme Defines the font scheme to which this font belongs.
FontUnderline the different types of possible underline formatting
Footer Common definition of a HSSF or XSSF page footer.
FormulaError Enumerates error values in SpreadsheetML formula calculations.
FormulaEvaluator Evaluates formula cells.
Header Common definition of a HSSF or XSSF page header.
HeaderFooter Common interface for Header and Footer.
HorizontalAlignment The enumeration value indicating horizontal alignment of a cell, i.e., whether it is aligned general, left, right, horizontally centered, filled (replicated), justified, centered across multiple cells, or distributed.
Hyperlink Represents an Excel hyperlink.
Name Represents a defined name for a range of cells.
NamedStyle CellStyle with a name.
PageOrder Specifies printed page order.
PaperSize The enumeration value indicating the possible paper size for a sheet
PatternFormatting
Picture Repersents a picture in a SpreadsheetML document
PictureData
PivotCache
PivotCache.CacheField
PivotCache.CacheRecord
PivotCache.SheetSource
PivotField
PivotField.FieldGroup
PivotField.Item
PivotField.Item.Type
PivotField.SortType
PivotField.Type
PivotTable
PrintCellComments These enumerations specify how cell comments shall be displayed for paper printing purposes.
PrintOrientation The enumeration value indicating the print orientation for a sheet.
PrintSetup
RichTextString Rich text unicode string.
Row High level representation of a row of a spreadsheet.
Row.MissingCellPolicy Used to specify the different possible policies if for the case of null and blank cells
Sheet High level representation of a Excel worksheet.
SheetConditionalFormatting The 'Conditional Formatting' facet of Sheet
SheetProtection Enhanced sheet protection.
TableStyle
Top10Filter
VerticalAlignment This enumeration value indicates the type of vertical alignment for a cell, i.e., whether it is aligned top, bottom, vertically centered, justified or distributed.
Workbook High level representation of a Excel workbook.
ZssChartX Represents a chart in a SpreadsheetML document

Classes in org.zkoss.poi.ss.usermodel used by org.zkoss.poi.xssf.usermodel.charts

Class and Description
Chart High level representation of a chart.

Classes in org.zkoss.poi.ss.usermodel used by org.zkoss.poi.xssf.usermodel.extensions

Class and Description
BorderStyle The enumeration value indicating the line style of a border in a cell, i.e., whether it is borded dash dot, dash dot dot, dashed, dotted, double, hair, medium, medium dash dot, medium dash dot dot, medium dashed, none, slant dash dot, thick or thin.
Color
HeaderFooter Common interface for Header and Footer.
HorizontalAlignment The enumeration value indicating horizontal alignment of a cell, i.e., whether it is aligned general, left, right, horizontally centered, filled (replicated), justified, centered across multiple cells, or distributed.
VerticalAlignment This enumeration value indicates the type of vertical alignment for a cell, i.e., whether it is aligned top, bottom, vertically centered, justified or distributed.

Classes in org.zkoss.poi.ss.usermodel used by org.zkoss.poi.xssf.usermodel.helpers

Class and Description
CellStyle
PivotCache
PivotTable
PivotTableHelper
Sheet High level representation of a Excel worksheet.
Workbook High level representation of a Excel workbook.

Classes in org.zkoss.poi.ss.usermodel used by org.zkoss.zpoiex.ss.usermodel.helpers

Class and Description
PivotTableHelper

Classes in org.zkoss.poi.ss.usermodel used by org.zkoss.zss.range.impl.imexp

Class and Description
AutoFilter Represents autofiltering for the specified worksheet.
Cell High level representation of a cell in a row of a spreadsheet.
CellStyle
ClientAnchor A client anchor is attached to an excel worksheet.
Color
ColorFilter
CustomFilters
DxfCellStyle Cell style for Dxfs
DynamicFilter
Font
Name Represents a defined name for a range of cells.
NamedStyle CellStyle with a name.
Picture Repersents a picture in a SpreadsheetML document
PictureData
RichTextString Rich text unicode string.
Row High level representation of a row of a spreadsheet.
Sheet High level representation of a Excel worksheet.
TableStyle
Top10Filter
Workbook High level representation of a Excel workbook.
ZssChartX Represents a chart in a SpreadsheetML document