Package org.zkoss.poi.ss.usermodel

Interface Summary

Interface	Description
AutoFilter	Represents autofiltering for the specified worksheet.
BorderFormatting
Cell	High level representation of a cell in a row of a spreadsheet.
CellRange<C extends Cell>	Represents a rectangular region of a Sheet
CellStyle
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
CustomFilters
DataField
DataFormat
DataValidation
DataValidationConstraint
DataValidationHelper
Drawing	High level representation of spreadsheet drawing.
DxfCellStyle	Cell style for Dxfs
DynamicFilter
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. For performance reasons, this class keeps a cache of all previously calculated intermediate cell values.
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
PivotCache.CacheField
PivotCache.CacheRecord
PivotCache.SheetSource
PivotField
PivotField.FieldGroup
PivotField.Item
PivotTable
PivotTableHelper
PrintSetup
RichTextString	Rich text unicode string.
Row	High level representation of a row of a spreadsheet.
Sheet	High level representation of a Excel worksheet.
SheetConditionalFormatting	The 'Conditional Formatting' facet of Sheet
SheetProtection	Enhanced sheet protection.
TableStyle
TableStyleElem
Textbox
Top10Filter
Workbook	High level representation of a Excel workbook.
ZssChartX	Represents a chart in a SpreadsheetML document

Class Summary

Class	Description
BuiltinFonts	17 Built-in Fonts starting from index 5(1-based) beside 0~3 default fonts.
BuiltinFormats	Utility to identify built-in formats.
BuiltinStyles
CellValue	Mimics the 'data view' of a cell.
ComparisonOperator	The conditional format operators used for "Highlight Cells That Contain..." rules.
DataFormatter	DataFormatter contains methods for formatting the value stored in an Cell.
DataValidation.ErrorStyle	Error style constants for error box
DataValidationConstraint.OperatorType	Condition operator enum
DataValidationConstraint.ValidationType	ValidationType enum
DateUtil	Contains methods for dealing with Excel dates.
ErrorConstants	Contains raw Excel error codes (as defined in OOO's excelfileformat.pdf (2.5.6)
ExcelStyleDateFormatter	A wrapper around a SimpleDateFormat instance, which handles a few Excel-style extensions that are not supported by SimpleDateFormat.
Row.MissingCellPolicy	Used to specify the different possible policies if for the case of null and blank cells
ShapeTypes	All known types of automatic shapes in DrawingML
WorkbookFactory	Factory for creating the appropriate kind of Workbook (be it HSSFWorkbook or XSSFWorkbook), from the given input
ZssContext	Keikai Spreadsheet context for cell evaluation, etc.

Enum Summary

Enum	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.
Calculation
CustomFilter.Operator
FillPatternType	The enumeration value indicating the style of fill pattern being used for a cell format.
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.
FontScheme	Defines the font scheme to which this font belongs.
FontUnderline	the different types of possible underline formatting
FormulaError	Enumerates error values in SpreadsheetML formula calculations.
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.
IndexedColors	A deprecated indexing scheme for colours that is still required for some records, and for backwards compatibility with OLE2 formats.
PageOrder	Specifies printed page order.
PaperSize	The enumeration value indicating the possible paper size for a sheet
PivotField.Item.Type
PivotField.SortType
PivotField.Type
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.
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.