Uses of Package
org.apache.poi.ss.usermodel

Packages that use org.apache.poi.ss.usermodel

Package	Description
org.apache.poi.hssf.converter
org.apache.poi.hssf.extractor
org.apache.poi.hssf.model	Provides low level API structures for reading, writing, modifying XLS files.
org.apache.poi.hssf.record	Record package contains class representations for XLS binary strutures.
org.apache.poi.hssf.record.aggregates	record aggregates are not real "records" but collections of records that act as a single record.
org.apache.poi.hssf.record.cf
org.apache.poi.hssf.usermodel	usermodel package maps HSSF low level strutures to familiar workbook/sheet model
org.apache.poi.hssf.util	util package contains tools needed for writing HSSF files that are not necesarily "real" HSSF concepts.
org.apache.poi.poifs.crypt.temp
org.apache.poi.ss.extractor
org.apache.poi.ss.format	This package contains classes that implement cell formatting
org.apache.poi.ss.formula	This package contains common internal POI code for manipulating formulas.
org.apache.poi.ss.formula.eval.forked
org.apache.poi.ss.formula.functions
org.apache.poi.ss.usermodel
org.apache.poi.ss.usermodel.charts
org.apache.poi.ss.usermodel.helpers
org.apache.poi.ss.util
org.apache.poi.ss.util.cellwalk
org.apache.poi.util	Top-level util package are classes that are useful throughout the project.
org.apache.poi.xssf.binary	The org.apache.poi.xssf.binary package includes necessary underlying components for streaming/read-only processing of xlsb files.
org.apache.poi.xssf.eventusermodel
org.apache.poi.xssf.model
org.apache.poi.xssf.streaming
org.apache.poi.xssf.usermodel
org.apache.poi.xssf.usermodel.charts
org.apache.poi.xssf.usermodel.extensions
org.apache.poi.xssf.usermodel.helpers

Classes in org.apache.poi.ss.usermodel used by org.apache.poi.hssf.converter

Class and Description
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.
CellStyle
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.
Sheet High level representation of a Excel worksheet.

Classes in org.apache.poi.ss.usermodel used by org.apache.poi.hssf.extractor

Class and Description
HeaderFooter Common interface for Header and Footer.

Classes in org.apache.poi.ss.usermodel used by org.apache.poi.hssf.model

Class and Description
SheetVisibility Specifies sheet visibility
Workbook High level representation of a Excel workbook.

Classes in org.apache.poi.ss.usermodel used by org.apache.poi.hssf.record

Class and Description
FormulaError Enumerates error values in SpreadsheetML formula calculations.
IconMultiStateFormatting.IconSet

Classes in org.apache.poi.ss.usermodel used by org.apache.poi.hssf.record.aggregates

Class and Description
FormulaError Enumerates error values in SpreadsheetML formula calculations.

Classes in org.apache.poi.ss.usermodel used by org.apache.poi.hssf.record.cf

Class and Description
IconMultiStateFormatting.IconSet

Classes in org.apache.poi.ss.usermodel used by org.apache.poi.hssf.usermodel

Class and Description
AutoFilter Represents autofiltering for the specified worksheet.
BorderFormatting High level representation for Border Formatting component of Conditional Formatting settings
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.
Cell High level representation of a cell in a row of a spreadsheet.
CellRange Represents a rectangular region of a Sheet
CellStyle
CellType
CellValue Mimics the 'data view' of a cell.
ChildAnchor Common interface for anchors.
ClientAnchor A client anchor is attached to an excel worksheet.
ClientAnchor.AnchorType
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.
ConditionalFormattingThreshold.RangeType
ConditionFilterData These values are needed by various conditional formatting evaluation filter types
ConditionFilterType Used primarily for XSSF conditions, which defines a multitude of additional "filter" types for conditional formatting.
ConditionType Represents a type of a conditional formatting rule
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
DataFormatter DataFormatter contains methods for formatting the value stored in an Cell.
DataValidation
DataValidationConstraint
DataValidationHelper
DateUtil Contains methods for dealing with Excel dates.
DifferentialStyleProvider Interface for classes providing differential style definitions, such as conditional format rules and table/pivot table styles.
Drawing High level representation of spreadsheet drawing.
ExcelNumberFormat Object to hold a number format index and string, for various formatting evaluations
ExtendedColor Represents a XSSF-style color (based on either a XSSFColor or a ExtendedColor
FillPatternType The enumeration value indicating the style of fill pattern being used for a cell format.
Font
FontFormatting High level representation for Font Formatting component of Conditional Formatting settings
Footer Common definition of a HSSF or XSSF page footer.
FormulaError Enumerates error values in SpreadsheetML formula calculations.
FormulaEvaluator Evaluates formula cells.
Header Common definition of a HSSF or XSSF page header.
HeaderFooter Common interface for Header and Footer.
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.
Hyperlink Represents an Excel hyperlink.
IconMultiStateFormatting High level representation for the Icon / Multi-State Formatting component of Conditional Formatting settings
IconMultiStateFormatting.IconSet
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
RangeCopier
RichTextString Rich text unicode string.
Row High level representation of a row of a spreadsheet.
Row.MissingCellPolicy Used to specify the different possible policies if for the case of null and blank cells
Shape Common interface for all drawing shapes
ShapeContainer A common interface for shape groups.
Sheet High level representation of a Excel worksheet.
SheetConditionalFormatting The 'Conditional Formatting' facet of Sheet
SheetVisibility Specifies sheet visibility
SimpleShape A common interface for simple shapes.
Table XSSF Only! High level abstraction of table in a workbook.
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.
Workbook High level representation of a Excel workbook.
WorkbookFactory Factory for creating the appropriate kind of Workbook (be it HSSFWorkbook or XSSFWorkbook), by auto-detecting from the supplied input.

Classes in org.apache.poi.ss.usermodel used by org.apache.poi.hssf.util

Class and Description
Color

Classes in org.apache.poi.ss.usermodel used by org.apache.poi.poifs.crypt.temp

Class and Description
Workbook High level representation of a Excel workbook.

Classes in org.apache.poi.ss.usermodel used by org.apache.poi.ss.extractor

Class and Description
Picture Repersents a picture in a SpreadsheetML document
Shape Common interface for all drawing shapes
ShapeContainer A common interface for shape groups.
Sheet High level representation of a Excel worksheet.

Classes in org.apache.poi.ss.usermodel used by org.apache.poi.ss.format

Class and Description
Cell High level representation of a cell in a row of a spreadsheet.
CellType

Classes in org.apache.poi.ss.usermodel used by org.apache.poi.ss.formula

Class and Description
Cell High level representation of a cell in a row of a spreadsheet.
CellType
CellValue Mimics the 'data view' of a cell.
ConditionalFormatting The ConditionalFormatting class encapsulates all settings of Conditional Formatting.
ConditionalFormattingRule Represents a description of a conditional formatting rule
ConditionType Represents a type of a conditional formatting rule
DataValidation
ExcelNumberFormat Object to hold a number format index and string, for various formatting evaluations
FormulaEvaluator Evaluates formula cells.
Name Represents a defined name for a range of cells.
RichTextString Rich text unicode string.
Sheet High level representation of a Excel worksheet.
Table XSSF Only! High level abstraction of table in a workbook.
Workbook High level representation of a Excel workbook.

Classes in org.apache.poi.ss.usermodel used by org.apache.poi.ss.formula.eval.forked

Class and Description
Workbook High level representation of a Excel workbook.

Classes in org.apache.poi.ss.usermodel used by org.apache.poi.ss.formula.functions

Class and Description
DataFormatter DataFormatter contains methods for formatting the value stored in an Cell.

Classes in org.apache.poi.ss.usermodel used by org.apache.poi.ss.usermodel

Class and Description
AutoFilter Represents autofiltering for the specified worksheet.
BorderExtent The enumeration value indicating which borders to draw in a Property Template
BorderFormatting High level representation for Border Formatting component of Conditional Formatting settings
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.
Cell High level representation of a cell in a row of a spreadsheet.
CellCopyPolicy
CellCopyPolicy.Builder
CellRange Represents a rectangular region of a Sheet
CellStyle
CellType
CellValue Mimics the 'data view' of a cell.
ChildAnchor Common interface for anchors.
ClientAnchor A client anchor is attached to an excel worksheet.
ClientAnchor.AnchorType
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.
ConditionalFormattingThreshold.RangeType
ConditionFilterData These values are needed by various conditional formatting evaluation filter types
ConditionFilterType Used primarily for XSSF conditions, which defines a multitude of additional "filter" types for conditional formatting.
ConditionType Represents a type of a conditional formatting rule
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
DataConsolidateFunction Enum mapping the values of STDataConsolidateFunction
DataFormat
DataValidation
DataValidationConstraint
DataValidationHelper
DifferentialStyleProvider Interface for classes providing differential style definitions, such as conditional format rules and table/pivot table styles.
Drawing High level representation of spreadsheet drawing.
ExcelNumberFormat Object to hold a number format index and string, for various formatting evaluations
ExtendedColor Represents a XSSF-style color (based on either a XSSFColor or a ExtendedColor
FillPatternType The enumeration value indicating the style of fill pattern being used for a cell format.
Font
FontCharset Deprecated. enum will be replaced by common version org.apache.poi.common.usermodel.FontCharset
FontFamily The font family this font belongs to.
FontFormatting High level representation for Font Formatting component of Conditional Formatting settings
FontScheme Defines the font scheme to which this font belongs.
FontUnderline the different types of possible underline formatting
Footer Common definition of a HSSF or XSSF page footer.
FormulaError Enumerates error values in SpreadsheetML formula calculations.
FormulaEvaluator Evaluates formula cells.
Header Common definition of a HSSF or XSSF page header.
HeaderFooter Common interface for Header and Footer.
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.
Hyperlink Represents an Excel hyperlink.
IconMultiStateFormatting High level representation for the Icon / Multi-State Formatting component of Conditional Formatting settings
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.
Name Represents a defined name for a range of cells.
ObjectData Common interface for OLE shapes, i.e.
PageOrder Specifies printed page order.
PaperSize The enumeration value indicating the possible paper size for a sheet
PatternFormatting
Picture Repersents a picture in a SpreadsheetML document
PictureData
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.
PrintSetup
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
RichTextString Rich text unicode string.
Row High level representation of a row of a spreadsheet.
Row.MissingCellPolicy Used to specify the different possible policies if for the case of null and blank cells
Shape Common interface for all drawing shapes
ShapeContainer A common interface for shape groups.
Sheet High level representation of a Excel worksheet.
SheetConditionalFormatting The 'Conditional Formatting' facet of Sheet
SheetVisibility Specifies sheet visibility
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.
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.
Workbook High level representation of a Excel workbook.

Classes in org.apache.poi.ss.usermodel used by org.apache.poi.ss.usermodel.charts

Class and Description
Chart Deprecated.
Sheet High level representation of a Excel worksheet.

Classes in org.apache.poi.ss.usermodel used by org.apache.poi.ss.usermodel.helpers

Class and Description
Sheet High level representation of a Excel worksheet.

Classes in org.apache.poi.ss.usermodel used by org.apache.poi.ss.util

Class and 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.
Cell High level representation of a cell in a row of a spreadsheet.
CellRange Represents a rectangular region of a Sheet
CellStyle
DataFormatter DataFormatter contains methods for formatting the value stored in an Cell.
Font
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.
Picture Repersents a picture in a SpreadsheetML document
Row High level representation of a row of a spreadsheet.
Sheet High level representation of a Excel worksheet.
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.
Workbook High level representation of a Excel workbook.

Classes in org.apache.poi.ss.usermodel used by org.apache.poi.ss.util.cellwalk

Class and Description
Cell High level representation of a cell in a row of a spreadsheet.
Sheet High level representation of a Excel worksheet.

Classes in org.apache.poi.ss.usermodel used by org.apache.poi.util

Class and Description
Workbook High level representation of a Excel workbook.

Classes in org.apache.poi.ss.usermodel used by org.apache.poi.xssf.binary

Class and Description
DataFormatter DataFormatter contains methods for formatting the value stored in an Cell.
RichTextString Rich text unicode string.

Classes in org.apache.poi.ss.usermodel used by org.apache.poi.xssf.eventusermodel

Class and Description
DataFormatter DataFormatter contains methods for formatting the value stored in an Cell.
RichTextString Rich text unicode string.

Classes in org.apache.poi.ss.usermodel used by org.apache.poi.xssf.model

Class and Description
Color
Name Represents a defined name for a range of cells.
RichTextString Rich text unicode string.
TableStyle Data table style definition.

Classes in org.apache.poi.ss.usermodel used by org.apache.poi.xssf.streaming

Class and Description
AutoFilter Represents autofiltering for the specified worksheet.
Cell High level representation of a cell in a row of a spreadsheet.
CellRange Represents a rectangular region of a Sheet
CellStyle
CellType
ClientAnchor A client anchor is attached to an excel worksheet.
Comment
CreationHelper An object that handles instantiating concrete classes of the various instances one needs for HSSF and XSSF.
DataFormat
DataValidation
DataValidationHelper
Drawing High level representation of spreadsheet drawing.
ExtendedColor Represents a XSSF-style color (based on either a XSSFColor or a ExtendedColor
Font
Footer Common definition of a HSSF or XSSF page footer.
FormulaEvaluator Evaluates formula cells.
Header Common definition of a HSSF or XSSF page header.
Hyperlink Represents an Excel hyperlink.
Name Represents a defined name for a range of cells.
ObjectData Common interface for OLE shapes, i.e.
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.
Row.MissingCellPolicy Used to specify the different possible policies if for the case of null and blank cells
Shape Common interface for all drawing shapes
ShapeContainer A common interface for shape groups.
Sheet High level representation of a Excel worksheet.
SheetConditionalFormatting The 'Conditional Formatting' facet of Sheet
SheetVisibility Specifies sheet visibility
Workbook High level representation of a Excel workbook.

Classes in org.apache.poi.ss.usermodel used by org.apache.poi.xssf.usermodel

Class and Description
AutoFilter Represents autofiltering for the specified worksheet.
BorderFormatting High level representation for Border Formatting component of Conditional Formatting settings
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.
Cell High level representation of a cell in a row of a spreadsheet.
CellCopyPolicy
CellRange Represents a rectangular region of a Sheet
CellStyle
CellType
CellValue Mimics the 'data view' of a cell.
Chart Deprecated.
ChildAnchor Common interface for anchors.
ClientAnchor A client anchor is attached to an excel worksheet.
ClientAnchor.AnchorType
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.
ConditionalFormattingThreshold.RangeType
ConditionFilterData These values are needed by various conditional formatting evaluation filter types
ConditionFilterType Used primarily for XSSF conditions, which defines a multitude of additional "filter" types for conditional formatting.
ConditionType Represents a type of a conditional formatting rule
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
DataConsolidateFunction Enum mapping the values of STDataConsolidateFunction
DataFormat
DataValidation
DataValidationConstraint
DataValidationHelper
DifferentialStyleProvider Interface for classes providing differential style definitions, such as conditional format rules and table/pivot table styles.
Drawing High level representation of spreadsheet drawing.
ExcelNumberFormat Object to hold a number format index and string, for various formatting evaluations
ExtendedColor Represents a XSSF-style color (based on either a XSSFColor or a ExtendedColor
FillPatternType The enumeration value indicating the style of fill pattern being used for a cell format.
Font
FontCharset Deprecated. enum will be replaced by common version org.apache.poi.common.usermodel.FontCharset
FontFamily The font family this font belongs to.
FontFormatting High level representation for Font Formatting component of Conditional Formatting settings
FontScheme Defines the font scheme to which this font belongs.
FontUnderline the different types of possible underline formatting
Footer Common definition of a HSSF or XSSF page footer.
FormulaError Enumerates error values in SpreadsheetML formula calculations.
FormulaEvaluator Evaluates formula cells.
Header Common definition of a HSSF or XSSF page header.
HeaderFooter Common interface for Header and Footer.
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.
Hyperlink Represents an Excel hyperlink.
IconMultiStateFormatting High level representation for the Icon / Multi-State Formatting component of Conditional Formatting settings
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.
Name Represents a defined name for a range of cells.
ObjectData Common interface for OLE shapes, i.e.
PageOrder Specifies printed page order.
PaperSize The enumeration value indicating the possible paper size for a sheet
PatternFormatting
Picture Repersents a picture in a SpreadsheetML document
PictureData
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.
PrintSetup
RangeCopier
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
RichTextString Rich text unicode string.
Row High level representation of a row of a spreadsheet.
Row.MissingCellPolicy Used to specify the different possible policies if for the case of null and blank cells
Shape Common interface for all drawing shapes
ShapeContainer A common interface for shape groups.
Sheet High level representation of a Excel worksheet.
SheetConditionalFormatting The 'Conditional Formatting' facet of Sheet
SheetVisibility Specifies sheet visibility
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.
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.
Workbook High level representation of a Excel workbook.
WorkbookFactory Factory for creating the appropriate kind of Workbook (be it HSSFWorkbook or XSSFWorkbook), by auto-detecting from the supplied input.

Classes in org.apache.poi.ss.usermodel used by org.apache.poi.xssf.usermodel.charts

Class and Description
Chart Deprecated.

Classes in org.apache.poi.ss.usermodel used by org.apache.poi.xssf.usermodel.extensions

Class and Description
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.
HeaderFooter Common interface for Header and Footer.
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.
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
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.

Classes in org.apache.poi.ss.usermodel used by org.apache.poi.xssf.usermodel.helpers

Class and Description
CellStyle
IgnoredErrorType Types of ignored workbook and worksheet error.