Package org.apache.poi.ss.usermodel

Interface Summary

Interface	Description
AutoFilter	Represents autofiltering for the specified worksheet.
BorderFormatting	High level representation for Border Formatting component of Conditional Formatting settings
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
ChildAnchor	Common interface for anchors.
ClientAnchor	A client anchor is attached to an excel worksheet.
Color
ColorFilter
ColorScaleFormatting	High level representation for the Color Scale / Colour Scale / Color Gradient Formatting component of Conditional Formatting settings
Comment
ConditionalFormatting	The ConditionalFormatting class encapsulates all settings of Conditional Formatting.
ConditionalFormattingRule	Represents a description of a conditional formatting rule
ConditionalFormattingThreshold	The Threshold / CFVO / Conditional Formatting Value Object.
ConditionFilterData	These values are needed by various conditional formatting evaluation filter types
CreationHelper	An object that handles instantiating concrete classes of the various instances one needs for HSSF and XSSF.
CustomFilter	CustomFilter
CustomFilters
DataBarFormatting	High level representation for the DataBar Formatting component of Conditional Formatting settings
DataFormat
DataValidation
DataValidationConstraint
DataValidationHelper
Date1904Support
DifferentialStyleProvider	Interface for classes providing differential style definitions, such as conditional format rules and table/pivot table styles.
Drawing<T extends Shape>	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.
Header	Common definition of a HSSF or XSSF page header.
HeaderFooter	Common interface for Header and Footer.
Hyperlink	Represents an Excel hyperlink.
IconMultiStateFormatting	High level representation for the Icon / Multi-State Formatting component of Conditional Formatting settings
Name	Represents a defined name for a range of cells.
NamedStyle	CellStyle with a name.
ObjectData	Common interface for OLE shapes, i.e.
PatternFormatting
Picture	Repersents a picture in a SpreadsheetML document
PictureData
PrintSetup
RichTextString	Rich text unicode string.
Row	High level representation of a row of a spreadsheet.
Shape	Common interface for all drawing shapes
ShapeContainer<T extends Shape>	A common interface for shape groups.
Sheet	High level representation of a Excel worksheet.
SheetConditionalFormatting	The 'Conditional Formatting' facet of Sheet
SheetProtection	Enhanced sheet protection.
SimpleShape	A common interface for simple shapes.
Table	XSSF Only! High level abstraction of table in a workbook.
TableStyle	Data table style definition.
TableStyleInfo	style information for a specific table instance, referencing the document style and indicating which optional portions of the style to apply.
Top10Filter
Workbook	High level representation of a Excel workbook.
WorkbookProvider

Class Summary

Class	Description
BuiltinFormats	Utility to identify built-in formats.
CellBase	Common implementation-independent logic shared by all implementations of Cell.
CellCopyContext	Used when the cells are being copied from one workbook to another.
CellCopyPolicy
CellCopyPolicy.Builder
CellValue	Mimics the 'data view' of a cell.
ComparisonOperator	The conditional format operators used for "Highlight Cells That Contain..." rules.
ConditionType	Represents a type of a conditional formatting rule
DataFormatter	DataFormatter contains methods for formatting the value stored in a 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.
ExcelGeneralNumberFormat	A format that formats a double as Excel would, ignoring FieldPosition.
ExcelNumberFormat	Object to hold a number format index and string, for various formatting evaluations
ExcelStyleDateFormatter	A wrapper around a SimpleDateFormat instance, which handles a few Excel-style extensions that are not supported by SimpleDateFormat.
ExtendedColor	Represents a XSSF-style color (based on either a XSSFColor or a ExtendedColor
FractionFormat	Format class that handles Excel style fractions, such as "# #/#" and "#/###"
RangeCopier
ShapeTypes	All known types of automatic shapes in DrawingML
WorkbookFactory	Factory for creating the appropriate kind of Workbook (be it HSSFWorkbook or XSSFWorkbook), by auto-detecting from the supplied input.
ZssContext	Keikai Spreadsheet context for cell evaluation, etc.

Enum Summary

Enum	Description
BorderExtent	The enumeration value indicating which borders to draw in a Property Template
BorderStyle	The enumeration value indicating the line style of a border in a cell, i.e., whether it is bordered 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.
CellReferenceType	Types of cell references.
CellType
ClientAnchor.AnchorType
ConditionalFormattingThreshold.RangeType
ConditionFilterType	Used primarily for XSSF conditions, which defines a multitude of additional "filter" types for conditional formatting.
CustomFilter.Operator
DataConsolidateFunction	Enum mapping the values of STDataConsolidateFunction
FillPatternType	The enumeration value indicating the style of fill pattern being used for a cell format.
FontCharset	Deprecated. enum will be replaced by common version org.apache.poi.common.usermodel.FontCharset
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.
IconMultiStateFormatting.IconSet
IgnoredErrorType	Types of ignored workbook and worksheet error.
IndexedColors	A deprecated indexing scheme for colours that is still required for some records, and for backwards compatibility with OLE2 formats.
PageMargin	Enumeration which represents the various margins which are present within an Excel worksheet
PageOrder	Specifies printed page order.
PaneType	Type of pane used in sheet.
PaperSize	The enumeration value indicating the possible paper size for a sheet
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.
ReadingOrder	The enumeration value indicating reading order of a cell, i.e., whether the reading order is Context(Default), Left To Right or Right To Left
Row.MissingCellPolicy	Used to specify the different possible policies if for the case of null and blank cells
SheetVisibility	Specifies sheet visibility
TableStyleType	Ordered list of table style elements, for both data tables and pivot tables.
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.