Package | Description |
---|---|
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.usermodel.helpers | |
org.apache.poi.ss.formula |
This package contains common internal POI code for manipulating formulas.
|
org.apache.poi.ss.formula.eval | |
org.apache.poi.ss.formula.eval.forked | |
org.apache.poi.ss.formula.functions | |
org.apache.poi.ss.formula.ptg |
The formula package contains binary PTG structures used in Formulas
|
org.apache.poi.ss.usermodel | |
org.apache.poi.ss.usermodel.helpers | |
org.apache.poi.xssf.streaming | |
org.apache.poi.xssf.usermodel | |
org.apache.poi.xssf.usermodel.helpers |
Class and Description |
---|
EvaluationWorkbook.ExternalName |
EvaluationWorkbook.ExternalSheet |
FormulaParseException
This exception thrown when a supplied formula has incorrect syntax (or syntax currently not
supported by POI).
|
FormulaShifter
Updates Formulas as rows or sheets are shifted
|
FormulaType
Enumeration of various formula types.
|
Class and Description |
---|
Formula
Encapsulates an encoded formula token array.
|
Class and Description |
---|
FormulaShifter
Updates Formulas as rows or sheets are shifted
|
Class and Description |
---|
Formula
Encapsulates an encoded formula token array.
|
Class and Description |
---|
BaseFormulaEvaluator
Common functionality across file formats for evaluating formula cells.
|
EvaluationCell
Abstracts a cell for the purpose of formula evaluation.
|
EvaluationName
Abstracts a name record for formula evaluation.
For POI internal use only |
EvaluationSheet
Abstracts a sheet for the purpose of formula evaluation.
For POI internal use only |
EvaluationWorkbook
Abstracts a workbook for the purpose of formula evaluation.
For POI internal use only |
EvaluationWorkbook.ExternalName |
EvaluationWorkbook.ExternalSheet |
FormulaParsingWorkbook
Abstracts a workbook for the purpose of formula parsing.
For POI internal use only |
FormulaRenderingWorkbook
Abstracts a workbook for the purpose of converting formula to text.
For POI internal use only |
IStabilityClassifier
Used to help optimise cell evaluation result caching by allowing applications to specify which
parts of a workbook are final.
The term final is introduced here to denote immutability or 'having constant definition'. |
SheetIdentifier |
WorkbookEvaluatorProvider
Provides access to a
WorkbookEvaluator , eg for use with
CollaboratingWorkbooksEnvironment |
Class and Description |
---|
FormulaShifter
Updates Formulas as rows or sheets are shifted
|
Class and Description |
---|
BaseFormulaEvaluator
Common functionality across file formats for evaluating formula cells.
|
CollaboratingWorkbooksEnvironment
Manages a collection of
WorkbookEvaluator s, in order to support
evaluation of formulas across spreadsheets. |
CollaboratingWorkbooksEnvironment.WorkbookNotFoundException |
DataValidationEvaluator
Evaluates Data Validation constraints.
|
DataValidationEvaluator.DataValidationContext
This class organizes and encapsulates all the pieces of information related to a single
data validation configuration for a single cell.
|
DataValidationEvaluator.OperatorEnum
Not calling it OperatorType to avoid confusion for now with DataValidationConstraint.OperatorType.
|
DataValidationEvaluator.ValidationEnum
Not calling it ValidationType to avoid confusion for now with DataValidationConstraint.ValidationType.
|
EvaluationCell
Abstracts a cell for the purpose of formula evaluation.
|
EvaluationConditionalFormatRule
Abstracted and cached version of a Conditional Format rule for use with a
ConditionalFormattingEvaluator . |
EvaluationConditionalFormatRule.OperatorEnum
Not calling it OperatorType to avoid confusion for now with other classes.
|
EvaluationConditionalFormatRule.ValueAndFormat
Note: this class has a natural ordering that is inconsistent with equals.
|
EvaluationName
Abstracts a name record for formula evaluation.
For POI internal use only |
EvaluationSheet
Abstracts a sheet for the purpose of formula evaluation.
For POI internal use only |
EvaluationWorkbook
Abstracts a workbook for the purpose of formula evaluation.
For POI internal use only |
EvaluationWorkbook.ExternalName |
EvaluationWorkbook.ExternalSheet |
Formula
Encapsulates an encoded formula token array.
|
FormulaParsingWorkbook
Abstracts a workbook for the purpose of formula parsing.
For POI internal use only |
FormulaRenderingWorkbook
Abstracts a workbook for the purpose of converting formula to text.
For POI internal use only |
FormulaShifter
Updates Formulas as rows or sheets are shifted
|
FormulaType
Enumeration of various formula types.
|
IStabilityClassifier
Used to help optimise cell evaluation result caching by allowing applications to specify which
parts of a workbook are final.
The term final is introduced here to denote immutability or 'having constant definition'. |
NameIdentifier |
SheetIdentifier |
SheetRange |
ThreeDEval
Optional Extension to the likes of
AreaEval and
AreaEvalBase ,
which allows for looking up 3D (sheet+row+column) evaluations |
TwoDEval
Common interface of
AreaEval and AreaEvalBase ,
for 2D (row+column) evaluations |
WorkbookEvaluator
Evaluates formula cells.
For performance reasons, this class keeps a cache of all previously calculated intermediate
cell values.
|
WorkbookEvaluatorProvider
Provides access to a
WorkbookEvaluator , eg for use with
CollaboratingWorkbooksEnvironment |
Class and Description |
---|
EvaluationCell
Abstracts a cell for the purpose of formula evaluation.
|
EvaluationName
Abstracts a name record for formula evaluation.
For POI internal use only |
SheetRange |
ThreeDEval
Optional Extension to the likes of
AreaEval and
AreaEvalBase ,
which allows for looking up 3D (sheet+row+column) evaluations |
TwoDEval
Common interface of
AreaEval and AreaEvalBase ,
for 2D (row+column) evaluations |
Class and Description |
---|
IStabilityClassifier
Used to help optimise cell evaluation result caching by allowing applications to specify which
parts of a workbook are final.
The term final is introduced here to denote immutability or 'having constant definition'. |
Class and Description |
---|
OperationEvaluationContext
Contains all the contextual information required to evaluate an operation
within a formula
For POI internal use only
|
Class and Description |
---|
ExternSheetReferenceToken
Should be implemented by any
Ptg subclass that needs has an extern sheet index For POI internal use only |
FormulaRenderingWorkbook
Abstracts a workbook for the purpose of converting formula to text.
For POI internal use only |
SheetIdentifier |
WorkbookDependentFormula
Should be implemented by any
Ptg subclass that needs a workbook to render its formula. |
Class and Description |
---|
ConditionalFormattingEvaluator
Evaluates Conditional Formatting constraints.
|
FormulaParseException
This exception thrown when a supplied formula has incorrect syntax (or syntax currently not
supported by POI).
|
Class and Description |
---|
FormulaShifter
Updates Formulas as rows or sheets are shifted
|
Class and Description |
---|
BaseFormulaEvaluator
Common functionality across file formats for evaluating formula cells.
|
EvaluationCell
Abstracts a cell for the purpose of formula evaluation.
|
EvaluationSheet
Abstracts a sheet for the purpose of formula evaluation.
For POI internal use only |
EvaluationWorkbook
Abstracts a workbook for the purpose of formula evaluation.
For POI internal use only |
FormulaParseException
This exception thrown when a supplied formula has incorrect syntax (or syntax currently not
supported by POI).
|
FormulaParsingWorkbook
Abstracts a workbook for the purpose of formula parsing.
For POI internal use only |
FormulaRenderingWorkbook
Abstracts a workbook for the purpose of converting formula to text.
For POI internal use only |
IStabilityClassifier
Used to help optimise cell evaluation result caching by allowing applications to specify which
parts of a workbook are final.
The term final is introduced here to denote immutability or 'having constant definition'. |
WorkbookEvaluatorProvider
Provides access to a
WorkbookEvaluator , eg for use with
CollaboratingWorkbooksEnvironment |
Class and Description |
---|
BaseFormulaEvaluator
Common functionality across file formats for evaluating formula cells.
|
EvaluationCell
Abstracts a cell for the purpose of formula evaluation.
|
EvaluationName
Abstracts a name record for formula evaluation.
For POI internal use only |
EvaluationSheet
Abstracts a sheet for the purpose of formula evaluation.
For POI internal use only |
EvaluationWorkbook
Abstracts a workbook for the purpose of formula evaluation.
For POI internal use only |
EvaluationWorkbook.ExternalName |
EvaluationWorkbook.ExternalSheet |
FormulaParsingWorkbook
Abstracts a workbook for the purpose of formula parsing.
For POI internal use only |
FormulaRenderingWorkbook
Abstracts a workbook for the purpose of converting formula to text.
For POI internal use only |
IStabilityClassifier
Used to help optimise cell evaluation result caching by allowing applications to specify which
parts of a workbook are final.
The term final is introduced here to denote immutability or 'having constant definition'. |
SheetIdentifier |
WorkbookEvaluator
Evaluates formula cells.
For performance reasons, this class keeps a cache of all previously calculated intermediate
cell values.
|
WorkbookEvaluatorProvider
Provides access to a
WorkbookEvaluator , eg for use with
CollaboratingWorkbooksEnvironment |
Class and Description |
---|
FormulaShifter
Updates Formulas as rows or sheets are shifted
|
Copyright 2020 The Apache Software Foundation or its licensors, as applicable.