| Package | Description |
|---|---|
| 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 |
The 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 |
The usermodel package maps HSSF low level structures to familiar workbook/sheet model
|
| org.apache.poi.hssf.util |
The util package contains tools needed for writing HSSF files that are not necesarily "real" HSSF concepts.
|
| 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.helpers | |
| org.apache.poi.ss.util | |
| org.apache.poi.ss.util.cellwalk |
| Class and Description |
|---|
| HeaderFooter |
| Class and Description |
|---|
| SheetVisibility
Specifies sheet visibility
|
| Workbook
High level representation of a Excel workbook.
|
| Class and Description |
|---|
| CellType |
| FormulaError
Enumerates error values in SpreadsheetML formula calculations.
|
| IconMultiStateFormatting.IconSet |
| Class and Description |
|---|
| FormulaError
Enumerates error values in SpreadsheetML formula calculations.
|
| Class and Description |
|---|
| IconMultiStateFormatting.IconSet |
| 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.
|
| CellBase
Common implementation-independent logic shared by all implementations of
Cell. |
| CellCopyContext
Used when the cells are being copied from one workbook to another.
|
| CellCopyPolicy |
| CellRange
Represents a rectangular region of a
Sheet |
| CellReferenceType
Types of cell references.
|
| 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 a
Cell.
|
| 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 |
| 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 |
| 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.
|
| PageMargin
Enumeration which represents the various margins which are present within an
Excel worksheet
|
| PaneType
Type of pane used in sheet.
|
| 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.
|
| WorkbookProvider |
| Class and Description |
|---|
| Color |
| 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.
|
| Class and Description |
|---|
| Cell
High level representation of a cell in a row of a spreadsheet.
|
| CellType |
| 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.
|
| Class and Description |
|---|
| Workbook
High level representation of a Excel workbook.
|
| Class and Description |
|---|
| DataFormatter
DataFormatter contains methods for formatting the value stored in a
Cell.
|
| 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 |
| CellPropertyCategory
The CellPropertyCategory enum represents the different categories of cell properties.
|
| CellPropertyType
The CellPropertyType enum represents the different types of cell properties that can be applied to a cell.
|
| CellRange
Represents a rectangular region of a
Sheet |
| CellReferenceType
Types of cell references.
|
| 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 |
| 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.
|
| PageMargin
Enumeration which represents the various margins which are present within an
Excel worksheet
|
| PageOrder
Specifies printed page order.
|
| PaneType
Type of pane used in sheet.
|
| 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.
|
| WorkbookProvider |
| Class and Description |
|---|
| Sheet
High level representation of a Excel worksheet.
|
| 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.
|
| CellCopyContext
Used when the cells are being copied from one workbook to another.
|
| CellCopyPolicy |
| CellPropertyType
The CellPropertyType enum represents the different types of cell properties that can be applied to a cell.
|
| CellRange
Represents a rectangular region of a
Sheet |
| CellStyle |
| DataFormatter
DataFormatter contains methods for formatting the value stored in a
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.
|
| PaneType
Type of pane used in sheet.
|
| 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.
|
| Class and Description |
|---|
| Cell
High level representation of a cell in a row of a spreadsheet.
|
| Sheet
High level representation of a Excel worksheet.
|