|
|||||||||
| PREV PACKAGE NEXT PACKAGE | FRAMES NO FRAMES | ||||||||
| 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. |
| ChildAnchor | Common interface for anchors. |
| 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. |
| 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. |
| DataBarFormatting | High level representation for the DataBar Formatting component of Conditional Formatting settings |
| DataFormat | |
| DataValidation | |
| DataValidationConstraint | |
| DataValidationHelper | |
| 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. |
| 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. |
| 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 |
| 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. |
| Textbox | Deprecated. 3.16 beta1. |
| Workbook | High level representation of a Excel workbook. |
| Class Summary | |
|---|---|
| BuiltinFormats | Utility to identify built-in formats. |
| 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 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. |
| 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 "#/###" |
| ShapeTypes | All known types of automatic shapes in DrawingML |
| Enum Summary | |
|---|---|
| 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. |
| CellType | |
| ClientAnchor.AnchorType | |
| ConditionalFormattingThreshold.RangeType | |
| ConditionFilterType | Used primarily for XSSF conditions, which defines a multitude of additional "filter" types for conditional formatting. |
| 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. |
| 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. |
| 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. |
|
|||||||||
| PREV PACKAGE NEXT PACKAGE | FRAMES NO FRAMES | ||||||||