# 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 |
  Chart | Deprecated
  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 |
  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.
  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.
  Workbook | High level representation of a Excel workbook.
  WorkbookFactory.CreateWorkbook0 |
  WorkbookFactory.CreateWorkbook1<T> |
  WorkbookFactory.CreateWorkbook2<T,U> |

- Class Summary
  Class | Description
  --- | ---
  BuiltinFormats | Utility to identify built-in formats.
  CellBase | Common implementation-independent logic shared by all implementations of `Cell`.
  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 "#/###"
  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.

- 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.
  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.
  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.

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