Package | Description |
---|---|
org.apache.poi.hssf.usermodel |
usermodel package maps HSSF low level strutures to familiar workbook/sheet model
|
org.apache.poi.ss | |
org.apache.poi.ss.formula |
This package contains common internal POI code for manipulating formulas.
|
org.apache.poi.ss.util | |
org.apache.poi.xssf.usermodel |
Modifier and Type | Method | Description |
---|---|---|
SpreadsheetVersion |
HSSFEvaluationWorkbook.getSpreadsheetVersion() |
Modifier and Type | Method | Description |
---|---|---|
static SpreadsheetVersion |
SpreadsheetVersion.valueOf(java.lang.String name) |
Returns the enum constant of this type with the specified name.
|
static SpreadsheetVersion[] |
SpreadsheetVersion.values() |
Returns an array containing the constants of this enum type, in
the order they are declared.
|
Modifier and Type | Method | Description |
---|---|---|
SpreadsheetVersion |
FormulaParsingWorkbook.getSpreadsheetVersion() |
Returns an enum holding spreadhseet properties specific to an Excel version (
max column and row numbers, max arguments to a function, etc.)
|
Constructor | Description |
---|---|
SharedFormula(SpreadsheetVersion ssVersion) |
Modifier and Type | Method | Description |
---|---|---|
static boolean |
CellReference.cellReferenceIsWithinRange(java.lang.String colStr,
java.lang.String rowStr,
SpreadsheetVersion ssVersion) |
Used to decide whether a name of the form "[A-Z]*[0-9]*" that appears in a formula can be
interpreted as a cell reference.
|
static CellReference.NameType |
CellReference.classifyCellReference(java.lang.String str,
SpreadsheetVersion ssVersion) |
Classifies an identifier as either a simple (2D) cell reference or a named range name
|
static boolean |
CellReference.isColumnWithnRange(java.lang.String colStr,
SpreadsheetVersion ssVersion) |
|
static boolean |
CellReference.isRowWithnRange(java.lang.String rowStr,
SpreadsheetVersion ssVersion) |
|
void |
CellRangeAddressBase.validate(SpreadsheetVersion ssVersion) |
Validate the range limits against the supplied version of Excel
|
Modifier and Type | Method | Description |
---|---|---|
SpreadsheetVersion |
XSSFEvaluationWorkbook.getSpreadsheetVersion() |
Copyright 2018 The Apache Software Foundation or its licensors, as applicable.