Package org.apache.poi.ss.usermodel

Interface Summary
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  
Chart High level representation of a chart.
ClientAnchor A client anchor is attached to an excel worksheet.
Color  
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.
CreationHelper An object that handles instantiating concrete classes of the various instances one needs for HSSF and XSSF.
DataBarFormatting High level representation for the DataBar Formatting component of Conditional Formatting settings
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.
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.
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
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.
ConditionType Represents a type of a conditional formatting rule
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.
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 "#/###"
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
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.
ConditionalFormattingThreshold.RangeType  
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.
IconMultiStateFormatting.IconSet  
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.
 



Copyright 2015 The Apache Software Foundation or its licensors, as applicable.