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.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.ss.format	This package contains classes that implement cell formatting
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.util
org.apache.poi.ss.util.cellwalk
org.apache.poi.xssf.eventusermodel
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

CellStyle

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

AutoFilter
Represents autofiltering for the specified worksheet.

BorderFormatting

Cell
High level representation of a cell in a row of a spreadsheet.

CellRange
Represents a rectangular region of a Sheet

CellStyle

CellValue
Mimics the 'data view' of a cell.

Chart
High level representation of a chart.

ClientAnchor
A client anchor is attached to an excel worksheet.

Comment

ConditionalFormatting
The ConditionalFormatting class encapsulates all settings of Conditional Formatting.

ConditionalFormattingRule
Represents a description of a conditional formatting rule

CreationHelper
An object that handles instantiating concrete classes of the various instances one needs for HSSF and XSSF.

DataFormat

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

DataValidation

DataValidationConstraint

DataValidationHelper

DateUtil
Contains methods for dealing with Excel dates.

Drawing
High level representation of spreadsheet drawing.

ErrorConstants
Contains raw Excel error codes (as defined in OOO's excelfileformat.pdf (2.5.6)

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.

For performance reasons, this class keeps a cache of all previously calculated intermediate cell values.

Header
Common definition of a HSSF or XSSF page header.

HeaderFooter
Common interface for Header and Footer.

Hyperlink
Represents an Excel hyperlink.

Name
Represents a defined name for a range of cells.

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

Sheet
High level representation of a Excel worksheet.

SheetConditionalFormatting
The 'Conditional Formatting' facet of Sheet

Workbook
High level representation of a Excel workbook.

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

Cell
High level representation of a cell in a row of a spreadsheet.

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.

BorderFormatting

BorderStyle
The enumeration value indicating the line style of a border in a cell, i.e., whether it is borded 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

CellValue
Mimics the 'data view' of a cell.

Chart
High level representation of a chart.

ClientAnchor
A client anchor is attached to an excel worksheet.

Color

Comment

ConditionalFormatting
The ConditionalFormatting class encapsulates all settings of Conditional Formatting.

ConditionalFormattingRule
Represents a description of a conditional formatting rule

CreationHelper
An object that handles instantiating concrete classes of the various instances one needs for HSSF and XSSF.

DataFormat

DataValidation

DataValidationConstraint

DataValidationHelper

Drawing
High level representation of spreadsheet drawing.

FillPatternType
The enumeration value indicating the style of fill pattern being used for a cell format.

Font

FontCharset
Charset represents the basic set of characters associated with a font (that it can display), and corresponds to the ANSI codepage (8-bit or DBCS) of that character set used by a given language.

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.

For performance reasons, this class keeps a cache of all previously calculated intermediate cell values.

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.

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.

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

Sheet
High level representation of a Excel worksheet.

SheetConditionalFormatting
The 'Conditional Formatting' facet of Sheet

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

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

Row
High level representation of a row of a spreadsheet.

Sheet
High level representation of a Excel worksheet.

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

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.

Font

Footer
Common definition of a HSSF or XSSF page footer.

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.

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

Sheet
High level representation of a Excel worksheet.

SheetConditionalFormatting
The 'Conditional Formatting' facet of Sheet

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

BorderStyle
The enumeration value indicating the line style of a border in a cell, i.e., whether it is borded 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

CellValue
Mimics the 'data view' of a cell.

Chart
High level representation of a chart.

ClientAnchor
A client anchor is attached to an excel worksheet.

Color

Comment

ConditionalFormatting
The ConditionalFormatting class encapsulates all settings of Conditional Formatting.

ConditionalFormattingRule
Represents a description of a conditional formatting rule

CreationHelper
An object that handles instantiating concrete classes of the various instances one needs for HSSF and XSSF.

DataFormat

DataValidation

DataValidationConstraint

DataValidationHelper

Drawing
High level representation of spreadsheet drawing.

FillPatternType
The enumeration value indicating the style of fill pattern being used for a cell format.

Font

FontCharset
Charset represents the basic set of characters associated with a font (that it can display), and corresponds to the ANSI codepage (8-bit or DBCS) of that character set used by a given language.

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.

For performance reasons, this class keeps a cache of all previously calculated intermediate cell values.

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.

Name
Represents a defined name for a range of cells.

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

Sheet
High level representation of a Excel worksheet.

SheetConditionalFormatting
The 'Conditional Formatting' facet of Sheet

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