Package org.apache.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.
ClientAnchor	A client anchor is attached to an excel worksheet.
Color
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.
DataFormat
DataValidation
DataValidationConstraint
DataValidationHelper
Drawing	High level representation of spreadsheet drawing.
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.
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.
Sheet	High level representation of a Excel worksheet.
SheetConditionalFormatting	The 'Conditional Formatting' facet of Sheet
Textbox
Workbook	High level representation of a Excel workbook.

Class Summary

Class	Description
BuiltinFormats	Utility to identify built-in formats.
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	Deprecated Use FormulaError instead where possible
ExcelStyleDateFormatter	A wrapper around a SimpleDateFormat instance, which handles a few Excel-style extensions that are not supported by SimpleDateFormat.
FractionFormat	Format class that handles Excel style fractions, such as "# #/#" and "#/###"
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), by auto-detecting from the supplied input.

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.
DataConsolidateFunction	Enum mapping the values of STDataConsolidateFunction
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
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.