Overview | Package | Class | Use | Tree | Deprecated | Index | Help
PREV NEXT | FRAMES NO FRAMES

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

Packages that use org.apache.poi.ss.usermodel
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.usermodel.helpers |
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
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.

Classes in org.apache.poi.ss.usermodel used by org.apache.poi.hssf.extractor
HeaderFooter Common interface for `Header` and `Footer`.

Classes in org.apache.poi.ss.usermodel used by org.apache.poi.hssf.model
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
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
FormulaError Enumerates error values in SpreadsheetML formula calculations.

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

Classes in org.apache.poi.ss.usermodel used by org.apache.poi.hssf.usermodel
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.
Chart High level representation of a chart.
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
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.

Classes in org.apache.poi.ss.usermodel used by org.apache.poi.hssf.usermodel.helpers
Row High level representation of a row of a spreadsheet.

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

Classes in org.apache.poi.ss.usermodel used by org.apache.poi.poifs.crypt.temp
Workbook High level representation of a Excel workbook.

Classes in org.apache.poi.ss.usermodel used by org.apache.poi.ss.extractor
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
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
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
Workbook High level representation of a Excel workbook.

Classes in org.apache.poi.ss.usermodel used by org.apache.poi.ss.formula.functions
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
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.
Chart High level representation of a chart.
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
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
Chart High level representation of a chart.
Sheet High level representation of a Excel worksheet.

Classes in org.apache.poi.ss.usermodel used by org.apache.poi.ss.usermodel.helpers
Row High level representation of 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.ss.util
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
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
Workbook High level representation of a Excel workbook.

Classes in org.apache.poi.ss.usermodel used by org.apache.poi.xssf.binary
DataFormatter DataFormatter contains methods for formatting the value stored in an Cell.

Classes in org.apache.poi.ss.usermodel used by org.apache.poi.xssf.eventusermodel
DataFormatter DataFormatter contains methods for formatting the value stored in an Cell.

Classes in org.apache.poi.ss.usermodel used by org.apache.poi.xssf.model
Name Represents a defined name for a range of cells.
TableStyle Data table style definition.

Classes in org.apache.poi.ss.usermodel used by org.apache.poi.xssf.streaming
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
Chart High level representation of a chart.
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
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 High level representation of a chart.
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
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.xssf.usermodel.charts
Chart High level representation of a chart.

Classes in org.apache.poi.ss.usermodel used by org.apache.poi.xssf.usermodel.extensions
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.
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
CellStyle
IgnoredErrorType Types of ignored workbook and worksheet error.
Row High level representation of a row of a spreadsheet.

Overview | Package | Class | Use | Tree | Deprecated | Index | Help
PREV NEXT | FRAMES NO FRAMES

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