Search Java Classes and Packages

Search Java Frameworks and Libraries

255581 classes and counting ...
Search Tips Index Status



#Org.apache.poi.ss Classes and Interfaces - 380 results found.
NameDescriptionTypePackageFramework
AbstractFunctionPtgThis class provides the base functionality for Excel sheet functions There are two kinds of function Ptgs - tFunc and tFuncVarClassorg.apache.poi.ss.formula.ptgApache POI
AddPtgAddition operator PTG the + binomial operator.Classorg.apache.poi.ss.formula.ptgApache POI
AddressCreates a text reference as text, given specified row and column numbers.Classorg.apache.poi.ss.formula.functionsApache POI
AggregateFunctionClassorg.apache.poi.ss.formula.functionsApache POI
AggregatingUDFFinderClassorg.apache.poi.ss.formula.udfApache POI
AnalysisToolPakClassorg.apache.poi.ss.formula.atpApache POI
Area2DPtgBaseClassorg.apache.poi.ss.formula.ptgApache POI
Area3DPtgTitle: Area 3D Ptg - 3D reference (Sheet + Area) Description: Defined an area in Extern Sheet.Classorg.apache.poi.ss.formula.ptgApache POI
Area3DPxgTitle: XSSF Area 3D Reference (Sheet + Area) Description: Defined an area in an external or different sheet.Classorg.apache.poi.ss.formula.ptgApache POI
AreaErrPtgAreaErr - handles deleted cell area references.Classorg.apache.poi.ss.formula.ptgApache POI
AreaEvalInterfaceorg.apache.poi.ss.formula.evalApache POI
AreaEvalBaseClassorg.apache.poi.ss.formula.evalApache POI
AreaICommon interface for AreaPtg and Area3DPtg, and their child classes.Interfaceorg.apache.poi.ss.formula.ptgApache POI
AreaI .OffsetAreaClassorg.apache.poi.ss.formula.ptg.AreaIApache POI
AreaNPtgSpecifies a rectangular area of cells A1:A4 for instance.Classorg.apache.poi.ss.formula.ptgApache POI
AreaPtgSpecifies a rectangular area of cells A1:A4 for instance.Classorg.apache.poi.ss.formula.ptgApache POI
AreaPtgBaseSpecifies a rectangular area of cells A1:A4 for instance.Classorg.apache.poi.ss.formula.ptgApache POI
AreaReferenceClassorg.apache.poi.ss.utilApache POI
ArrayPtgArrayPtg - handles arrays The ArrayPtg is a little weird, the size of the Ptg when parsing initially onlyClassorg.apache.poi.ss.formula.ptgApache POI
AttrPtg"Special Attributes" This seems to be a Misc Stuff and Junk record.Classorg.apache.poi.ss.formula.ptgApache POI
AttrPtg .SpaceTypeClassorg.apache.poi.ss.formula.ptg.AttrPtgApache POI
AutoFilterRepresents autofiltering for the specified worksheet.Interfaceorg.apache.poi.ss.usermodelApache POI
AxisCrossBetweenenum AxisCrossBetweenSpecifies the possible crossing states of an axis.Classorg.apache.poi.ss.usermodel.chartsApache POI
AxisCrossesSpecifies the possible crossing points for an axis.Classorg.apache.poi.ss.usermodel.chartsApache POI
AxisOrientationenum AxisOrientationSpecifies the possible ways to place a picture on a data point, series, wall, or floor.Classorg.apache.poi.ss.usermodel.chartsApache POI
AxisPositionEnumeration of all possible axis positions.Classorg.apache.poi.ss.usermodel.chartsApache POI
AxisTickMarkEnumeration of possible axis tick marks.Classorg.apache.poi.ss.usermodel.chartsApache POI
BaseNumberUtilsSome utils for converting from and to any baseAuthor:cedric dot walter @ gmail dot comClassorg.apache.poi.ss.formula.functionsApache POI
Bin2Dec Syntax: Bin2Dec (number) Converts a binary number to decimal.Classorg.apache.poi.ss.formula.functionsApache POI
BlankEvalClassorg.apache.poi.ss.formula.evalApache POI
BooleanFunctionHere are the general rules concerning Boolean functions: Blanks are ignored (not either true or false) Strings are ignored if part of an area ref or cell ref, otherwise they must be 'true' or 'false' Numbers: 0 is false.Classorg.apache.poi.ss.formula.functionsApache POI
BoolEvalClassorg.apache.poi.ss.formula.evalApache POI
BoolPtgBoolean (boolean) Stores a (java) boolean value in a formula.Classorg.apache.poi.ss.formula.ptgApache POI
BorderFormattingHigh level representation for Border Formatting component of Conditional Formatting settingsInterfaceorg.apache.poi.ss.usermodelApache POI
BorderStyleThe enumeration value indicating the line style of a border in a cell, i.Classorg.apache.poi.ss.usermodelApache POI
BuiltinFormatsUtility to identify built-in formats.Classorg.apache.poi.ss.usermodelApache POI
CalendarFieldFunction Date - DAY, MONTH and YEAR Time - HOUR, MINUTE and SECONDClassorg.apache.poi.ss.formula.functionsApache POI
CellHigh level representation of a cell in a row of a spreadsheet.Interfaceorg.apache.poi.ss.usermodelApache POI
CellAddressThis class is a container for POI usermodel row=0 column=0 cell references.Classorg.apache.poi.ss.utilApache POI
CellCopyPolicyClassorg.apache.poi.ss.usermodelApache POI
CellCopyPolicy .BuilderClassorg.apache.poi.ss.usermodel.CellCopyPolicyApache POI
CellDateFormatterFormats a date value.Classorg.apache.poi.ss.formatApache POI
CellElapsedFormatterThis class implements printing out an elapsed time format.Classorg.apache.poi.ss.formatApache POI
CellFormatFormat a value according to the standard Excel behavior.Classorg.apache.poi.ss.formatApache POI
CellFormatConditionThis object represents a condition in a cell format.Classorg.apache.poi.ss.formatApache POI
CellFormatPartObjects of this class represent a single part of a cell format expression.Classorg.apache.poi.ss.formatApache POI
CellFormatResultThis object contains the result of applying a cell format or cell format partAuthor:Ken Arnold, Industrious Media LLCSee Also:CellFormatPart.Classorg.apache.poi.ss.formatApache POI
CellFormatterThis is the abstract supertype for the various cell formatters.Classorg.apache.poi.ss.formatApache POI
CellFormatTypeThe different kinds of formats that the formatter understands.Classorg.apache.poi.ss.formatApache POI
CellGeneralFormatterA formatter for the default "General" cell format.Classorg.apache.poi.ss.formatApache POI
CellHandlerRepresents callback for CellWalk traverse method.Interfaceorg.apache.poi.ss.util.cellwalkApache POI
CellNumberFormatterThis class implements printing out a value using a number format.Classorg.apache.poi.ss.formatApache POI
CellRangeInterfaceorg.apache.poi.ss.usermodelApache POI
CellRangeAddressSee OOO documentation: excelfileformat.Classorg.apache.poi.ss.utilApache POI
CellRangeAddressBaseSee OOO documentation: excelfileformat.Classorg.apache.poi.ss.utilApache POI
CellRangeAddressList in OpenOffice.Classorg.apache.poi.ss.utilApache POI
CellReferenceCommon conversion functions between Excel style A1, C27 style cell references, and POI usermodel style row=0, column=0Classorg.apache.poi.ss.utilApache POI
CellReference .NameTypeUsed to classify identifiers found in formulas as cell references or not.Classorg.apache.poi.ss.util.CellReferenceApache POI
CellStyleInterfaceorg.apache.poi.ss.usermodelApache POI
CellTextFormatterThis class implements printing out text.Classorg.apache.poi.ss.formatApache POI
CellUtilVarious utility functions that make working with a cells and rows easier.Classorg.apache.poi.ss.utilApache POI
CellValueMimics the 'data view' of a cell.Classorg.apache.poi.ss.usermodelApache POI
CellWalkTraverse cell range.Classorg.apache.poi.ss.util.cellwalkApache POI
CellWalkContextInterfaceorg.apache.poi.ss.util.cellwalkApache POI
ChartHigh level representation of a chart.Interfaceorg.apache.poi.ss.usermodelApache POI
ChartAxisHigh level representation of chart axis.Interfaceorg.apache.poi.ss.usermodel.chartsApache POI
ChartAxisFactoryA factory for different chart axis.Interfaceorg.apache.poi.ss.usermodel.chartsApache POI
ChartDataA base for all charts data types.Interfaceorg.apache.poi.ss.usermodel.chartsApache POI
ChartDataFactoryA factory for different charts data types.Interfaceorg.apache.poi.ss.usermodel.chartsApache POI
ChartDataSourceRepresents data model of the charts.Interfaceorg.apache.poi.ss.usermodel.chartsApache POI
ChartLegendHigh level representation of chart legend.Interfaceorg.apache.poi.ss.usermodel.chartsApache POI
ChartSeriesBasic settings for all chart series.Interfaceorg.apache.poi.ss.usermodel.chartsApache POI
ChooseClassorg.apache.poi.ss.formula.functionsApache POI
ClientAnchorA client anchor is attached to an excel worksheet.Interfaceorg.apache.poi.ss.usermodelApache POI
ClientAnchor .AnchorTypeDo Not Move or Resize With Underlying Rows/Columns (3)Don't Move but do Resize With Anchor Cells (1)Classorg.apache.poi.ss.usermodel.ClientAnchorApache POI
Code Syntax: CODE (text ) Returns a numeric code for the first character in a text string.Classorg.apache.poi.ss.formula.functionsApache POI
CollaboratingWorkbooksEnvironmentManages a collection of WorkbookEvaluators, in order to support evaluation of formulas across spreadsheets.Classorg.apache.poi.ss.formulaApache POI
CollaboratingWorkbooksEnvironment .WorkbookNotFoundExceptionClassorg.apache.poi.ss.formula.CollaboratingWorkbooksEnvironmentApache POI
ColorScaleFormattingHigh level representation for the Color Scale / Colour Scale / Color Gradient Formatting component of Conditional Formatting settingsInterfaceorg.apache.poi.ss.usermodelApache POI
ColumnClassorg.apache.poi.ss.formula.functionsApache POI
ColumnsClassorg.apache.poi.ss.formula.functionsApache POI
CommentInterfaceorg.apache.poi.ss.usermodelApache POI
ComparisonOperatorThe conditional format operators used for "Highlight Cells That Contain.Classorg.apache.poi.ss.usermodelApache POI
Complex Syntax: COMPLEX (real_num,i_num,suffix ) Converts real and imaginary coefficients into a complex number of the form x + yi or x + yj.Classorg.apache.poi.ss.formula.functionsApache POI
ConcatEvalClassorg.apache.poi.ss.formula.evalApache POI
ConcatPtgClassorg.apache.poi.ss.formula.ptgApache POI
ConditionalFormattingThe ConditionalFormatting class encapsulates all settings of Conditional Formatting.Interfaceorg.apache.poi.ss.usermodelApache POI
ConditionalFormattingRuleInterfaceorg.apache.poi.ss.usermodelApache POI
ConditionalFormattingThresholdThe Threshold / CFVO / Conditional Formatting Value Object.Interfaceorg.apache.poi.ss.usermodelApache POI
ConditionalFormattingThreshold .RangeTypeThe maximum value from the rangeThe minimum value from the rangeClassorg.apache.poi.ss.usermodel.ConditionalFormattingThresholdApache POI
ConditionTypeClassorg.apache.poi.ss.usermodelApache POI
ConstantValueParserTo support Constant Values (2.Classorg.apache.poi.ss.formula.constantApache POI
ControlPtgClassorg.apache.poi.ss.formula.ptgApache POI
CountCounts the number of cells that contain numeric data within the list of arguments.Classorg.apache.poi.ss.formula.functionsApache POI
CountaCounts the number of cells that contain data within the list of arguments.Classorg.apache.poi.ss.formula.functionsApache POI
CountblankClassorg.apache.poi.ss.formula.functionsApache POI
CountifClassorg.apache.poi.ss.formula.functionsApache POI
Countif .ErrorMatcherClassorg.apache.poi.ss.formula.functions.CountifApache POI
Countif .StringMatcherClassorg.apache.poi.ss.formula.functions.CountifApache POI
CountifsClassorg.apache.poi.ss.formula.functionsApache POI
CreationHelperAn object that handles instantiating concrete classes of the various instances one needs forInterfaceorg.apache.poi.ss.usermodelApache POI
DataBarFormattingHigh level representation for the DataBar Formatting component of Conditional Formatting settingsInterfaceorg.apache.poi.ss.usermodelApache POI
DataConsolidateFunctionenum DataConsolidateFunctionEnum mapping the values of STDataConsolidateFunctionClassorg.apache.poi.ss.usermodelApache POI
DataFormatInterfaceorg.apache.poi.ss.usermodelApache POI
DataFormatterDataFormatter contains methods for formatting the value stored in an Cell.Classorg.apache.poi.ss.usermodelApache POI
DataSourcesClassorg.apache.poi.ss.usermodel.chartsApache POI
DataValidationInterfaceorg.apache.poi.ss.usermodelApache POI
DataValidation .ErrorStyleClassorg.apache.poi.ss.usermodel.DataValidationApache POI
DataValidationConstraintInterfaceorg.apache.poi.ss.usermodelApache POI
DataValidationConstraint .OperatorTypeClassorg.apache.poi.ss.usermodel.DataValidationConstraintApache POI
DataValidationConstraint .ValidationTypeClassorg.apache.poi.ss.usermodel.DataValidationConstraintApache POI
DataValidationHelperInterfaceorg.apache.poi.ss.usermodelApache POI
DateFormatConverterConvert java DateFormat patterns into Excel custom number formats.Classorg.apache.poi.ss.utilApache POI
DateFormatConverter .DateFormatTokenizerClassorg.apache.poi.ss.util.DateFormatConverterApache POI
DateFuncClassorg.apache.poi.ss.formula.functionsApache POI
DateParserParser for java dates.Classorg.apache.poi.ss.formula.atpApache POI
DateUtilContains methods for dealing with Excel dates.Classorg.apache.poi.ss.usermodelApache POI
Days360Calculates the number of days between two dates based on a 360-day year (twelve 30-day months), which is used in some accounting calculations.Classorg.apache.poi.ss.formula.functionsApache POI
Dec2Bin Syntax: Bin2Dec (number,[places] ) Converts a decimal number to binary.Classorg.apache.poi.ss.formula.functionsApache POI
Dec2Hex Syntax: DEC2HEX (number,places ) Converts a decimal number to hexadecimal.Classorg.apache.poi.ss.formula.functionsApache POI
DefaultUDFFinderDefault UDF finder - for adding your own user defined functions.Classorg.apache.poi.ss.formula.udfApache POI
Deleted3DPxgClassorg.apache.poi.ss.formula.ptgApache POI
DeletedArea3DPtgTitle: Deleted Area 3D Ptg - 3D referecnce (Sheet + Area) Description: Defined a area in Extern Sheet.Classorg.apache.poi.ss.formula.ptgApache POI
DeletedRef3DPtgTitle: Deleted Reference 3D Ptg Description: Defined a cell in extern sheet.Classorg.apache.poi.ss.formula.ptgApache POI
Delta Syntax: DELTA (number1,number2 ) Tests whether two values are equal.Classorg.apache.poi.ss.formula.functionsApache POI
DGet Finds the value of a column in an area with given conditions.Classorg.apache.poi.ss.formula.functionsApache POI
DividePtgThis PTG implements the standard binomial divide "/"Author:Andrew C.Classorg.apache.poi.ss.formula.ptgApache POI
DMin Finds the minimum value of a column in an area with given conditions.Classorg.apache.poi.ss.formula.functionsApache POI
DrawingHigh level representation of spreadsheet drawing.Interfaceorg.apache.poi.ss.usermodelApache POI
DStarRunnerThis class performs a D* calculation.Classorg.apache.poi.ss.formula.functionsApache POI
DStarRunner .DStarAlgorithmEnumClassorg.apache.poi.ss.formula.functions.DStarRunnerApache POI
EDateClassorg.apache.poi.ss.formula.functionsApache POI
EOMonth EOMONTH() returns the date of the last day of a month.Classorg.apache.poi.ss.formula.functionsApache POI
EqualPtgClassorg.apache.poi.ss.formula.ptgApache POI
ErrorConstantRepresents a constant error code value as encoded in a constant values array.Classorg.apache.poi.ss.formula.constantApache POI
ErrorConstantsContains raw Excel error codes (as defined in OOO's excelfileformat.Classorg.apache.poi.ss.usermodelApache POI
ErrorEvalClassorg.apache.poi.ss.formula.evalApache POI
Errortype ERROR.Classorg.apache.poi.ss.formula.functionsApache POI
ErrPtgClassorg.apache.poi.ss.formula.ptgApache POI
EvaluationCellAbstracts a cell for the purpose of formula evaluation.Interfaceorg.apache.poi.ss.formulaApache POI
EvaluationExceptionThis class is used to simplify error handling logic within operator and function implementations.Classorg.apache.poi.ss.formula.evalApache POI
EvaluationNameAbstracts a name record for formula evaluation.Interfaceorg.apache.poi.ss.formulaApache POI
EvaluationSheetAbstracts a sheet for the purpose of formula evaluation.Interfaceorg.apache.poi.ss.formulaApache POI
EvaluationWorkbookAbstracts a workbook for the purpose of formula evaluation.Interfaceorg.apache.poi.ss.formulaApache POI
EvaluationWorkbook .ExternalNameClassorg.apache.poi.ss.formula.EvaluationWorkbookApache POI
EvaluationWorkbook .ExternalSheetClassorg.apache.poi.ss.formula.EvaluationWorkbookApache POI
EvaluationWorkbook .ExternalSheetRangeClassorg.apache.poi.ss.formula.EvaluationWorkbookApache POI
EvenClassorg.apache.poi.ss.formula.functionsApache POI
ExcelExtractorInterfaceorg.apache.poi.ss.extractorApache POI
ExcelGeneralNumberFormatA format that formats a double as Excel would, ignoring FieldPosition.Classorg.apache.poi.ss.usermodelApache POI
ExcelStyleDateFormatterA wrapper around a SimpleDateFormat instance, which handles a few Excel-style extensions thatClassorg.apache.poi.ss.usermodelApache POI
ExpPtgClassorg.apache.poi.ss.formula.ptgApache POI
ExtendedColorClassorg.apache.poi.ss.usermodelApache POI
ExternalNameEvalClassorg.apache.poi.ss.formula.evalApache POI
ExternSheetReferenceTokenShould be implemented by any Ptg subclass that needs has an extern sheet index For POI internal use onlyInterfaceorg.apache.poi.ss.formulaApache POI
FactDouble Syntax: FACTDOUBLE (number) Returns the double factorial of a number.Classorg.apache.poi.ss.formula.functionsApache POI
FillPatternTypeenum FillPatternTypeThe enumeration value indicating the style of fill pattern being used for a cell format.Classorg.apache.poi.ss.usermodelApache POI
FinanceClassorg.apache.poi.ss.formula.functionsApache POI
FinanceFunctionClassorg.apache.poi.ss.formula.functionsApache POI
FinanceLibClassorg.apache.poi.ss.formula.functionsApache POI
FixedClassorg.apache.poi.ss.formula.functionsApache POI
Fixed0ArgFunctionConvenience base class for functions that only take zero arguments.Classorg.apache.poi.ss.formula.functionsApache POI
Fixed1ArgFunctionConvenience base class for functions that must take exactly one argument.Classorg.apache.poi.ss.formula.functionsApache POI
Fixed2ArgFunctionConvenience base class for functions that must take exactly two arguments.Classorg.apache.poi.ss.formula.functionsApache POI
Fixed3ArgFunctionConvenience base class for functions that must take exactly three arguments.Classorg.apache.poi.ss.formula.functionsApache POI
Fixed4ArgFunctionConvenience base class for functions that must take exactly four arguments.Classorg.apache.poi.ss.formula.functionsApache POI
FontInterfaceorg.apache.poi.ss.usermodelApache POI
FontCharsetCharset 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.Classorg.apache.poi.ss.usermodelApache POI
FontFamilyThe font family this font belongs to.Classorg.apache.poi.ss.usermodelApache POI
FontFormattingHigh level representation for Font Formatting component of Conditional Formatting settingsInterfaceorg.apache.poi.ss.usermodelApache POI
FontSchemeDefines the font scheme to which this font belongs.Classorg.apache.poi.ss.usermodelApache POI
FontUnderlinethe different types of possible underline formattingAuthor:Gisella BronzettiClassorg.apache.poi.ss.usermodelApache POI
FooterCommon definition of a HSSF or XSSF page footer.Interfaceorg.apache.poi.ss.usermodelApache POI
ForkedEvaluatorAn alternative workbook evaluator that saves memory in situations where a single workbook is concurrently and independently evaluated many times.Classorg.apache.poi.ss.formula.eval.forkedApache POI
FormulaEncapsulates an encoded formula token array.Classorg.apache.poi.ss.formulaApache POI
FormulaErrorEnumerates error values in SpreadsheetML formula calculations.Classorg.apache.poi.ss.usermodelApache POI
FormulaEvaluatorEvaluates formula cells.Interfaceorg.apache.poi.ss.usermodelApache POI
FormulaParseExceptionThis exception thrown when a supplied formula has incorrect syntax (or syntax currently not supported by POI).Classorg.apache.poi.ss.formulaApache POI
FormulaParserThis class parses a formula string into a List of tokens in RPN order.Classorg.apache.poi.ss.formulaApache POI
FormulaParsingWorkbookAbstracts a workbook for the purpose of formula parsing.Interfaceorg.apache.poi.ss.formulaApache POI
FormulaRendererCommon logic for rendering formulas.Classorg.apache.poi.ss.formulaApache POI
FormulaRenderingWorkbookAbstracts a workbook for the purpose of converting formula to text.Interfaceorg.apache.poi.ss.formulaApache POI
FormulaShifterClassorg.apache.poi.ss.formulaApache POI
FormulaTypeEnumeration of various formula types.Classorg.apache.poi.ss.formulaApache POI
FractionFormatFormat class that handles Excel style fractions, such as "# #/#" and "#/###" As of this writing, this is still not 100% accurate, but it does a reasonable jobClassorg.apache.poi.ss.usermodelApache POI
FreeRefFunctionFor most Excel functions, involving references ((cell, area), (2d, 3d)), the references are passed in as arguments, and the exact location remains fixed.Interfaceorg.apache.poi.ss.formula.functionsApache POI
FuncPtgClassorg.apache.poi.ss.formula.ptgApache POI
FunctionCommon interface for all implementations of Excel built-in functions.Interfaceorg.apache.poi.ss.formula.functionsApache POI
Function0ArgInterfaceorg.apache.poi.ss.formula.functionsApache POI
Function1ArgInterfaceorg.apache.poi.ss.formula.functionsApache POI
Function2ArgInterfaceorg.apache.poi.ss.formula.functionsApache POI
Function3ArgInterfaceorg.apache.poi.ss.formula.functionsApache POI
Function4ArgInterfaceorg.apache.poi.ss.formula.functionsApache POI
FunctionEvalClassorg.apache.poi.ss.formula.evalApache POI
FunctionMetadataHolds information about Excel built-in functions.Classorg.apache.poi.ss.formula.functionApache POI
FunctionMetadataRegistryAllows clients to get FunctionMetadata instances for any built-in function of Excel.Classorg.apache.poi.ss.formula.functionApache POI
FunctionNameEvalClassorg.apache.poi.ss.formula.evalApache POI
FuncVarPtgClassorg.apache.poi.ss.formula.ptgApache POI
GreaterEqualPtgPTG class to implement greater or equal toAuthor:fred at stsci dot eduClassorg.apache.poi.ss.formula.ptgApache POI
GreaterThanPtgGreater than operator PTG ">"Author:Cameron Riley (criley at ekmail.Classorg.apache.poi.ss.formula.ptgApache POI
HeaderCommon definition of a HSSF or XSSF page header.Interfaceorg.apache.poi.ss.usermodelApache POI
HeaderFooterInterfaceorg.apache.poi.ss.usermodelApache POI
Hex2Dec Syntax: HEX2DEC (number) Converts a hexadecimal number to decimal.Classorg.apache.poi.ss.formula.functionsApache POI
Hlookup HLOOKUP finds a column in a lookup table by the first row value and returns the value from another row.Classorg.apache.poi.ss.formula.functionsApache POI
HorizontalAlignmentenum HorizontalAlignmentThe enumeration value indicating horizontal alignment of a cell,Classorg.apache.poi.ss.usermodelApache POI
Hyperlink In Excel this function has special behaviour - it causes the displayed cell value to behave like a hyperlink in the GUI.Classorg.apache.poi.ss.formula.functionsApache POI
HyperlinkRepresents an Excel hyperlink.Interfaceorg.apache.poi.ss.usermodelApache POI
IconMultiStateFormattingHigh level representation for the Icon / Multi-State Formatting component of Conditional Formatting settingsInterfaceorg.apache.poi.ss.usermodelApache POI
IconMultiStateFormatting .IconSetGrey Up / Side / Down arrowsGrey Up / NE / SE / Down arrowsClassorg.apache.poi.ss.usermodel.IconMultiStateFormattingApache POI
IDStarAlgorithmInterface specifying how an algorithm to be used by DStarRunner should look like.Interfaceorg.apache.poi.ss.formula.functionsApache POI
IfFunc Note that Excel is a bit picky about the arguments to this function, when serialised into Ptgs in a HSSF file.Classorg.apache.poi.ss.formula.functionsApache POI
IgnoredErrorTypeenum IgnoredErrorTypeTypes of ignored workbook and worksheet error.Classorg.apache.poi.ss.usermodelApache POI
ImageUtilsClassorg.apache.poi.ss.utilApache POI
Imaginary Syntax: IMAGINARY (Inumber) Returns the imaginary coefficient of a complex number in x + yi or x + yj text format.Classorg.apache.poi.ss.formula.functionsApache POI
ImReal Syntax: ImReal (Inumber) Returns the real coefficient of a complex number in x + yi or x + yj text format.Classorg.apache.poi.ss.formula.functionsApache POI
Index INDEX ( reference, row_num[, column_num [, area_num]]) INDEX ( array, row_num[, column_num])Classorg.apache.poi.ss.formula.functionsApache POI
IndexedColorsA deprecated indexing scheme for colours that is still required for some records, and for backwards compatibility with OLE2 formats.Classorg.apache.poi.ss.usermodelApache POI
IndexedUDFFinderA UDFFinder that can retrieve functions both by name and by fake index.Classorg.apache.poi.ss.formula.udfApache POI
Indirect INDIRECT() returns the cell or area reference denoted by the text argument.Classorg.apache.poi.ss.formula.functionsApache POI
Intercept Calculates the INTERCEPT of the linear regression line that is used to predict y values from x values (http://introcs.Classorg.apache.poi.ss.formula.functionsApache POI
IntersectionEvalClassorg.apache.poi.ss.formula.evalApache POI
IntersectionPtgClassorg.apache.poi.ss.formula.ptgApache POI
IntPtgInteger (unsigned short integer) Stores an unsigned short value (java int) inAuthor:Andrew C.Classorg.apache.poi.ss.formula.ptgApache POI
IPMTClassorg.apache.poi.ss.formula.functionsApache POI
IrrCalculates the internal rate of return.Classorg.apache.poi.ss.formula.functionsApache POI
IStabilityClassifierUsed to help optimise cell evaluation result caching by allowing applications to specify which parts of a workbook are final.Interfaceorg.apache.poi.ss.formulaApache POI
LayoutModeSpecifies the possible ways to store a chart element's position.Classorg.apache.poi.ss.usermodel.chartsApache POI
LayoutTargetSpecifies whether to layout the plot area by its inside (not including axis and axis labels) or outside (including axis and axis labels).Classorg.apache.poi.ss.usermodel.chartsApache POI
LegendPositionEnumeration of all possible chart legend positions.Classorg.apache.poi.ss.usermodel.chartsApache POI
LessEqualPtgPtg class to implement less than or equalAuthor:fred at stsci dot eduClassorg.apache.poi.ss.formula.ptgApache POI
LessThanPtgLess than operator PTG "Author:Cameron Riley (criley at ekmail.Classorg.apache.poi.ss.formula.ptgApache POI
LinearRegressionFunctionBase class for linear regression functions.Classorg.apache.poi.ss.formula.functionsApache POI
LinearRegressionFunction .FUNCTIONClassorg.apache.poi.ss.formula.functions.LinearRegressionFunctionApache POI
LineChartDataInterfaceorg.apache.poi.ss.usermodel.chartsApache POI
LineChartSeriesRepresents a line chart series.Interfaceorg.apache.poi.ss.usermodel.chartsApache POI
LogicalFunction take a single expression argument, and return True or False.Classorg.apache.poi.ss.formula.functionsApache POI
Lookup LOOKUP finds an index row in a lookup table by the first column value and returns the value from another column.Classorg.apache.poi.ss.formula.functionsApache POI
ManualLayoutHigh level representation of chart element manual layout.Interfaceorg.apache.poi.ss.usermodel.chartsApache POI
ManuallyPositionableAbstraction of chart element that can be positioned with manualAuthor:Roman KashitsynInterfaceorg.apache.poi.ss.usermodel.chartsApache POI
Match MATCH(lookup_value, lookup_array, match_type) Returns a 1-based index specifying at what position in the lookup_array the specifiedClassorg.apache.poi.ss.formula.functionsApache POI
MemAreaPtgClassorg.apache.poi.ss.formula.ptgApache POI
MemErrPtgClassorg.apache.poi.ss.formula.ptgApache POI
MemFuncPtgClassorg.apache.poi.ss.formula.ptgApache POI
MinaMaxaClassorg.apache.poi.ss.formula.functionsApache POI
MirrCalculates Modified internal rate of return.Classorg.apache.poi.ss.formula.functionsApache POI
MissingArgEvalRepresents the (intermediate) evaluated result of a missing function argument.Classorg.apache.poi.ss.formula.evalApache POI
MissingArgPtgMissing Function Arguments Avik Sengupta Classorg.apache.poi.ss.formula.ptgApache POI
ModeClassorg.apache.poi.ss.formula.functionsApache POI
MultiOperandNumericFunctionThis is the super class for all excel function evaluator classes that take variable number of operands, andClassorg.apache.poi.ss.formula.functionsApache POI
MultiplyPtgClassorg.apache.poi.ss.formula.ptgApache POI
NaClassorg.apache.poi.ss.formula.functionsApache POI
NameRepresents a defined name for a range of cells.Interfaceorg.apache.poi.ss.usermodelApache POI
NameIdentifierClassorg.apache.poi.ss.formulaApache POI
NamePtgClassorg.apache.poi.ss.formula.ptgApache POI
NameXPtgA Name, be that a Named Range or a Function / User Defined Function, addressed in the HSSF External Sheet style.Classorg.apache.poi.ss.formula.ptgApache POI
NameXPxgA Name, be that a Named Range or a Function / User Defined Function, addressed in the HSSF External Sheet style.Classorg.apache.poi.ss.formula.ptgApache POI
NotEqualPtgPtg class to implement not equalAuthor:fred at stsci dot eduClassorg.apache.poi.ss.formula.ptgApache POI
NotImplementedExceptionAn exception thrown by implementors of FormulaEvaluator, when attempting to evaluate a formula which requires featuresClassorg.apache.poi.ss.formula.evalApache POI
NotImplementedFunctionThis is the default implementation of a Function class.Classorg.apache.poi.ss.formula.functionsApache POI
NotImplementedFunctionExceptionAn exception thrown by implementors of FormulaEvaluator when attempting to evaluate a formula which requires a function that POI Classorg.apache.poi.ss.formula.evalApache POI
NowClassorg.apache.poi.ss.formula.functionsApache POI
NpvCalculates the net present value of an investment by using a discount rate and a series of future payments (negative values) and income (positiveClassorg.apache.poi.ss.formula.functionsApache POI
NumberComparerExcel compares numbers using different rules to those of java, so Double.Classorg.apache.poi.ss.utilApache POI
NumberEvalClassorg.apache.poi.ss.formula.evalApache POI
NumberPtgNumber Stores a floating point value in a formula value stored in a 8 byte field using IEEE notationClassorg.apache.poi.ss.formula.ptgApache POI
NumberToTextConverterExcel converts numbers to text with different rules to those of java, so Double.Classorg.apache.poi.ss.utilApache POI
NumericFunctionClassorg.apache.poi.ss.formula.functionsApache POI
NumericFunction .OneArgClassorg.apache.poi.ss.formula.functions.NumericFunctionApache POI
NumericFunction .TwoArgClassorg.apache.poi.ss.formula.functions.NumericFunctionApache POI
NumericValueEvalInterfaceorg.apache.poi.ss.formula.evalApache POI
Oct2Dec Converts an octal number to decimal.Classorg.apache.poi.ss.formula.functionsApache POI
OddClassorg.apache.poi.ss.formula.functionsApache POI
Offset OFFSET returns an area reference that is a specified number of rows and columns from a reference cell or area.Classorg.apache.poi.ss.formula.functionsApache POI
OperandPtgClassorg.apache.poi.ss.formula.ptgApache POI
OperandResolverProvides functionality for evaluating arguments to functions and operators.Classorg.apache.poi.ss.formula.evalApache POI
OperationEvaluationContextContains all the contextual information required to evaluate an operation For POI internal use onlyClassorg.apache.poi.ss.formulaApache POI
OperationPtgClassorg.apache.poi.ss.formula.ptgApache POI
PageOrderSpecifies printed page order.Classorg.apache.poi.ss.usermodelApache POI
PaperSizeThe enumeration value indicating the possible paper size for a sheetAuthor:Daniele MontagniClassorg.apache.poi.ss.usermodelApache POI
ParenthesisPtgWhile formula tokens are stored in RPN order and thus do not need parenthesis for precedence reasons, Parenthesis tokens ARE written to ensure that userClassorg.apache.poi.ss.formula.ptgApache POI
PatternFormattingInterfaceorg.apache.poi.ss.usermodelApache POI
PercentEvalClassorg.apache.poi.ss.formula.evalApache POI
PercentPtgClassorg.apache.poi.ss.formula.ptgApache POI
PictureInterfaceorg.apache.poi.ss.usermodelApache POI
PictureDataInterfaceorg.apache.poi.ss.usermodelApache POI
PowerPtgClassorg.apache.poi.ss.formula.ptgApache POI
PPMTCompute the interest portion of a payment.Classorg.apache.poi.ss.formula.functionsApache POI
PrintCellCommentsenum PrintCellCommentsThese enumerations specify how cell comments shall be displayed for paper printing purposes.Classorg.apache.poi.ss.usermodelApache POI
PrintOrientationenum PrintOrientationThe enumeration value indicating the print orientation for a sheet.Classorg.apache.poi.ss.usermodelApache POI
PrintSetupInterfaceorg.apache.poi.ss.usermodelApache POI
PtgPtg represents a syntactic token in a formula.Classorg.apache.poi.ss.formula.ptgApache POI
PxgAn XSSF only special kind of Ptg, which stores the sheet / book reference in string form.Interfaceorg.apache.poi.ss.formula.ptgApache POI
Pxg3DAn XSSF only special kind of Ptg, which stores a range of sheet / book references in string form.Interfaceorg.apache.poi.ss.formula.ptgApache POI
Quotient Syntax: QUOTIENT(Numerator,Denominator) Numerator is the dividend.Classorg.apache.poi.ss.formula.functionsApache POI
RangeEvalClassorg.apache.poi.ss.formula.evalApache POI
RangePtgClassorg.apache.poi.ss.formula.ptgApache POI
RankReturns the rank of a number in a list of numbers.Classorg.apache.poi.ss.formula.functionsApache POI
RateClassorg.apache.poi.ss.formula.functionsApache POI
Ref3DPtgTitle: Reference 3D Ptg Description: Defined a cell in extern sheet.Classorg.apache.poi.ss.formula.ptgApache POI
Ref3DPxgTitle: XSSF 3D Reference Description: Defines a cell in an external or different sheet.Classorg.apache.poi.ss.formula.ptgApache POI
RefErrorPtgRefError - handles deleted cell referenceAuthor:Jason Height (jheight at chariot dot net dot au)Classorg.apache.poi.ss.formula.ptgApache POI
RefEvalRefEval is the super interface for Ref2D and Ref3DEval.Interfaceorg.apache.poi.ss.formula.evalApache POI
RefEvalBaseClassorg.apache.poi.ss.formula.evalApache POI
RefNPtgClassorg.apache.poi.ss.formula.ptgApache POI
RefPtgReferencePtg - handles references (such as A1, A2, IA4)Author:Andrew C.Classorg.apache.poi.ss.formula.ptgApache POI
RefPtgBaseReferencePtgBase - handles references (such as A1, A2, IA4)Author:Andrew C.Classorg.apache.poi.ss.formula.ptgApache POI
RegionRepresents a from/to row/col square.Classorg.apache.poi.ss.utilApache POI
RegionUtilVarious utility functions that make working with a region of cells easier.Classorg.apache.poi.ss.utilApache POI
RelationalOperationEvalBase class for all comparison operator evaluatorsAuthor:Amol S.Classorg.apache.poi.ss.formula.evalApache POI
ReplaceAn implementation of the Excel REPLACE() function: Replaces part of a text string based on the number of charactersClassorg.apache.poi.ss.formula.functionsApache POI
Rept Syntax: REPT (text,number_times ) Repeats text a given number of times.Classorg.apache.poi.ss.formula.functionsApache POI
RichTextStringRich text unicode string.Interfaceorg.apache.poi.ss.usermodelApache POI
Roman Syntax: WeekNum (Serial_num,Return_type) Returns a number that indicates where the week falls numerically within a year.Classorg.apache.poi.ss.formula.functionsApache POI
RowHigh level representation of a row of a spreadsheet.Interfaceorg.apache.poi.ss.usermodelApache POI
Row .MissingCellPolicyUsed to specify the different possible policies if for the case of null and blank cellsClassorg.apache.poi.ss.usermodel.RowApache POI
RowFuncClassorg.apache.poi.ss.formula.functionsApache POI
RowsClassorg.apache.poi.ss.formula.functionsApache POI
ScalarConstantPtgCommon superclass of all Ptgs that represent simple constant values.Classorg.apache.poi.ss.formula.ptgApache POI
ScatterChartDataInterfaceorg.apache.poi.ss.usermodel.chartsApache POI
ScatterChartSeriesRepresents scatter charts series.Interfaceorg.apache.poi.ss.usermodel.chartsApache POI
ShapeTypesClassorg.apache.poi.ss.usermodelApache POI
SharedFormulaClassorg.apache.poi.ss.formulaApache POI
SheetHigh level representation of a Excel worksheet.Interfaceorg.apache.poi.ss.usermodelApache POI
SheetBuilder from 2D array of Objects.Classorg.apache.poi.ss.utilApache POI
SheetConditionalFormattingInterfaceorg.apache.poi.ss.usermodelApache POI
SheetIdentifierClassorg.apache.poi.ss.formulaApache POI
SheetNameFormatterFormats sheet names for use in formula expressions.Classorg.apache.poi.ss.formulaApache POI
SheetRangeInterfaceorg.apache.poi.ss.formulaApache POI
SheetRangeIdentifierClassorg.apache.poi.ss.formulaApache POI
SheetReferencesHolds a collection of Sheet names and their associatedAuthor:Andrew C.Classorg.apache.poi.ss.utilApache POI
SheetUtilClassorg.apache.poi.ss.utilApache POI
SimpleFractionClassorg.apache.poi.ss.formatApache POI
Slope Calculates the SLOPE of the linear regression line that is used to predict y values from x values (http://introcs.Classorg.apache.poi.ss.formula.functionsApache POI
SpreadsheetVersionenum SpreadsheetVersionThis enum allows spreadsheets from multiple Excel versions to be handled by the common code.Classorg.apache.poi.ssApache POI
SSCellRangeClassorg.apache.poi.ss.utilApache POI
StringEvalClassorg.apache.poi.ss.formula.evalApache POI
StringPtgString Stores a String value in a formula value stored in the format char[]Classorg.apache.poi.ss.formula.ptgApache POI
StringValueEvalInterfaceorg.apache.poi.ss.formula.evalApache POI
SubstituteAn implementation of the SUBSTITUTE function: Substitutes text in a text string with new text, some number of times.Classorg.apache.poi.ss.formula.functionsApache POI
Subtotal SUBTOTAL ( functionCode, ref1, ref2 .Classorg.apache.poi.ss.formula.functionsApache POI
SubtractPtgClassorg.apache.poi.ss.formula.ptgApache POI
Sumif SUMIF ( range, criteria, sum_range ) rangeThe range over which criteria is applied.Classorg.apache.poi.ss.formula.functionsApache POI
Sumifs SUMIFS ( sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], .Classorg.apache.poi.ss.formula.functionsApache POI
Sumproduct SUMPRODUCT ( array1[, array2[, array3[, .Classorg.apache.poi.ss.formula.functionsApache POI
Sumx2my2 Calculates the sum of differences of squares in two arrays of the same size.Classorg.apache.poi.ss.formula.functionsApache POI
Sumx2py2 Calculates the sum of squares in two arrays of the same size.Classorg.apache.poi.ss.formula.functionsApache POI
Sumxmy2 Calculates the sum of squares of differences between two arrays of the same size.Classorg.apache.poi.ss.formula.functionsApache POI
T If the argument is a text or error value it is returned unmodified.Classorg.apache.poi.ss.formula.functionsApache POI
TblPtgThis ptg indicates a data table.Classorg.apache.poi.ss.formula.ptgApache POI
TextboxInterfaceorg.apache.poi.ss.usermodelApache POI
TextFunctionClassorg.apache.poi.ss.formula.functionsApache POI
ThreeDEvalOptional Extension to the likes of AreaEval and which allows for looking up 3D (sheet+row+column) evaluationsInterfaceorg.apache.poi.ss.formulaApache POI
TimeFuncClassorg.apache.poi.ss.formula.functionsApache POI
TitleTypeTitle types for charts.Classorg.apache.poi.ss.usermodel.chartsApache POI
TodayClassorg.apache.poi.ss.formula.functionsApache POI
TwoDEvalCommon interface of AreaEval and AreaEvalBase, for 2D (row+column) evaluationsInterfaceorg.apache.poi.ss.formulaApache POI
TwoOperandNumericOperationClassorg.apache.poi.ss.formula.evalApache POI
UDFFinderCommon interface for "Add-in" libraries and user defined function libraries.Interfaceorg.apache.poi.ss.formula.udfApache POI
UnaryMinusEvalClassorg.apache.poi.ss.formula.evalApache POI
UnaryMinusPtg does not have any effect on the operandAuthor:Avik SenguptaClassorg.apache.poi.ss.formula.ptgApache POI
UnaryPlusEvalClassorg.apache.poi.ss.formula.evalApache POI
UnaryPlusPtg does not have any effect on the operandAuthor:Avik SenguptaClassorg.apache.poi.ss.formula.ptgApache POI
UnionPtgClassorg.apache.poi.ss.formula.ptgApache POI
UnknownPtgClassorg.apache.poi.ss.formula.ptgApache POI
Value Syntax: VALUE(text) Converts the text argument to a number.Classorg.apache.poi.ss.formula.functionsApache POI
ValueAxisInterfaceorg.apache.poi.ss.usermodel.chartsApache POI
ValueOperatorPtgCommon superclass of all value operators.Classorg.apache.poi.ss.formula.ptgApache POI
VerticalAlignmentenum VerticalAlignmentThis enumeration value indicates the type of vertical alignment for a cell, i.Classorg.apache.poi.ss.usermodelApache POI
Vlookup VLOOKUP finds a row in a lookup table by the first column value and returns the value from another column.Classorg.apache.poi.ss.formula.functionsApache POI
WeekdayFuncClassorg.apache.poi.ss.formula.functionsApache POI
WeekNum Syntax: WeekNum (Serial_num,Return_type) Returns a number that indicates where the week falls numerically within a year.Classorg.apache.poi.ss.formula.functionsApache POI
WorkbookHigh level representation of a Excel workbook.Interfaceorg.apache.poi.ss.usermodelApache POI
WorkbookDependentFormulaShould be implemented by any Ptg subclass that needs a workbook to render its formula.Interfaceorg.apache.poi.ss.formulaApache POI
WorkbookEvaluatorEvaluates formula cells.Classorg.apache.poi.ss.formulaApache POI
WorkbookEvaluatorProviderProvides access to a WorkbookEvaluator, eg for use with CollaboratingWorkbooksEnvironmentInterfaceorg.apache.poi.ss.formulaApache POI
WorkbookFactoryFactory for creating the appropriate kind of Workbook (be it HSSFWorkbook or XSSFWorkbook),Classorg.apache.poi.ss.usermodelApache POI
WorkbookUtilClassorg.apache.poi.ss.utilApache POI
WorkdayCalculatorA calculator for workdays, considering dates as excel representations.Classorg.apache.poi.ss.formula.atpApache POI
XYNumericFunctionClassorg.apache.poi.ss.formula.functionsApache POI
XYNumericFunction .AccumulatorInterfaceorg.apache.poi.ss.formula.functions.XYNumericFunctionApache POI