Interface Summary Interface Description AutoFilterRepresents autofiltering for the specified worksheet. BorderFormattingHigh level representation for Border Formatting component of Conditional Formatting settings CellHigh level representation of a cell in a row of a spreadsheet. CellRange<C extends Cell>Represents a rectangular region of a
CellStyle Chart Deprecated. ChildAnchorCommon interface for anchors. ClientAnchorA client anchor is attached to an excel worksheet. Color ColorScaleFormattingHigh level representation for the Color Scale / Colour Scale / Color Gradient Formatting component of Conditional Formatting settings Comment ConditionalFormattingThe ConditionalFormatting class encapsulates all settings of Conditional Formatting. ConditionalFormattingRuleRepresents a description of a conditional formatting rule ConditionalFormattingThresholdThe Threshold / CFVO / Conditional Formatting Value Object. ConditionFilterDataThese values are needed by various conditional formatting evaluation filter types CreationHelperAn object that handles instantiating concrete classes of the various instances one needs for HSSF and XSSF. DataBarFormattingHigh level representation for the DataBar Formatting component of Conditional Formatting settings DataFormat DataValidation DataValidationConstraint DataValidationHelper DifferentialStyleProviderInterface 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. Font FontFormattingHigh level representation for Font Formatting component of Conditional Formatting settings FooterCommon definition of a HSSF or XSSF page footer. FormulaEvaluatorEvaluates formula cells. HeaderCommon definition of a HSSF or XSSF page header. HeaderFooter HyperlinkRepresents an Excel hyperlink. IconMultiStateFormattingHigh level representation for the Icon / Multi-State Formatting component of Conditional Formatting settings NameRepresents a defined name for a range of cells. ObjectDataCommon interface for OLE shapes, i.e. PatternFormatting PictureRepersents a picture in a SpreadsheetML document PictureData PrintSetup RichTextStringRich text unicode string. RowHigh level representation of a row of a spreadsheet. ShapeCommon interface for all drawing shapes ShapeContainer<T extends Shape>A common interface for shape groups. SheetHigh level representation of a Excel worksheet. SheetConditionalFormattingThe 'Conditional Formatting' facet of Sheet SimpleShapeA common interface for simple shapes. TableXSSF Only! High level abstraction of table in a workbook. TableStyleData table style definition. TableStyleInfostyle information for a specific table instance, referencing the document style and indicating which optional portions of the style to apply. WorkbookHigh level representation of a Excel workbook.
Class Summary Class Description BuiltinFormatsUtility to identify built-in formats. CellCopyPolicy CellCopyPolicy.Builder CellValueMimics the 'data view' of a cell. ComparisonOperatorThe conditional format operators used for "Highlight Cells That Contain..." rules. ConditionTypeRepresents a type of a conditional formatting rule DataFormatterDataFormatter contains methods for formatting the value stored in an Cell. DataValidation.ErrorStyleError style constants for error box DataValidationConstraint.OperatorTypeCondition operator enum DataValidationConstraint.ValidationTypeValidationType enum DateUtilContains methods for dealing with Excel dates. ExcelGeneralNumberFormatA format that formats a double as Excel would, ignoring FieldPosition. ExcelNumberFormatObject to hold a number format index and string, for various formatting evaluations ExcelStyleDateFormatter ExtendedColor FractionFormatFormat class that handles Excel style fractions, such as "# #/#" and "#/###" RangeCopier ShapeTypesAll known types of automatic shapes in DrawingML WorkbookFactoryFactory for creating the appropriate kind of Workbook (be it
HSSFWorkbookor XSSFWorkbook), by auto-detecting from the supplied input.
Enum Summary Enum Description BorderExtentThe enumeration value indicating which borders to draw in a Property Template BorderStyleThe 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. CellType ClientAnchor.AnchorType ConditionalFormattingThreshold.RangeType ConditionFilterTypeUsed primarily for XSSF conditions, which defines a multitude of additional "filter" types for conditional formatting. DataConsolidateFunctionEnum mapping the values of STDataConsolidateFunction FillPatternTypeThe 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 FontFamilyThe font family this font belongs to. FontSchemeDefines the font scheme to which this font belongs. FontUnderlinethe different types of possible underline formatting FormulaErrorEnumerates error values in SpreadsheetML formula calculations. HorizontalAlignmentThe 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 IgnoredErrorTypeTypes of ignored workbook and worksheet error. IndexedColorsA deprecated indexing scheme for colours that is still required for some records, and for backwards compatibility with OLE2 formats. PageOrderSpecifies printed page order. PaperSizeThe enumeration value indicating the possible paper size for a sheet PrintCellCommentsThese enumerations specify how cell comments shall be displayed for paper printing purposes. PrintOrientationThe enumeration value indicating the print orientation for a sheet. ReadingOrderThe 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.MissingCellPolicyUsed to specify the different possible policies if for the case of null and blank cells SheetVisibilitySpecifies sheet visibility TableStyleTypeOrdered list of table style elements, for both data tables and pivot tables. VerticalAlignmentThis enumeration value indicates the type of vertical alignment for a cell, i.e., whether it is aligned top, bottom, vertically centered, justified or distributed.