| Package | Description |
|---|---|
| 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
Related Documentation
For overviews, tutorials, examples, guides, and tool documentation, please see:
Apache POI Project
|
| 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 |
| Class and Description |
|---|
| CellStyle |
| Class and Description |
|---|
| HeaderFooter |
| Class and Description |
|---|
| 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.
|
| Header
Common definition of a HSSF or XSSF page header.
|
| HeaderFooter |
| 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.
|
| Class and Description |
|---|
| Color |
| Class and Description |
|---|
| Cell
High level representation of a cell in a row of a spreadsheet.
|
| Class and Description |
|---|
| Workbook
High level representation of a Excel workbook.
|
| Class and Description |
|---|
| DataFormatter
DataFormatter contains methods for formatting the value stored in an
Cell.
|
| Class and Description |
|---|
| 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.
|
| 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.
|
| 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.
|
| Class and Description |
|---|
| Chart
High level representation of a chart.
|
| Sheet
High level representation of a Excel worksheet.
|
| Class and Description |
|---|
| 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.
|
| Class and Description |
|---|
| Cell
High level representation of a cell in a row of a spreadsheet.
|
| Sheet
High level representation of a Excel worksheet.
|
| Class and Description |
|---|
| DataFormatter
DataFormatter contains methods for formatting the value stored in an
Cell.
|
| 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 |
| 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.
|
| Class and Description |
|---|
| 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.
|
| 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.
|
| 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.
|
| Class and Description |
|---|
| Chart
High level representation of a chart.
|
| Class and Description |
|---|
| 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 |
| 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.
|
| Class and Description |
|---|
| CellStyle |
Copyright 2014 The Apache Software Foundation or its licensors, as applicable.