Package | Description |
---|---|
org.apache.poi.hssf.record |
Record package contains class representations for XLS binary strutures.
|
org.apache.poi.hssf.usermodel |
The usermodel package maps HSSF low level structures to familiar workbook/sheet model
|
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.usermodel | |
org.apache.poi.xssf.streaming | |
org.apache.poi.xssf.usermodel |
Modifier and Type | Method and Description |
---|---|
CellType |
OldFormulaRecord.getCachedResultTypeEnum()
Returns the type of the cached result
|
CellType |
FormulaRecord.getCachedResultTypeEnum()
Returns the type of the cached result
|
CellType |
FormulaSpecialCachedValue.getValueTypeEnum()
Returns the type of the cached value
|
Modifier and Type | Method and Description |
---|---|
CellType |
HSSFCell.getCachedFormulaResultType()
Only valid for formula cells
|
CellType |
HSSFCell.getCellType()
get the cells type (numeric, formula or string)
|
Modifier and Type | Method and Description |
---|---|
HSSFCell |
HSSFRow.createCell(int columnIndex,
CellType type)
Use this to create new cells within the row and return it.
|
protected void |
HSSFCell.setCellTypeImpl(CellType cellType) |
Constructor and Description |
---|
HSSFCell(HSSFWorkbook book,
HSSFSheet sheet,
int row,
short col,
CellType type)
Creates new Cell - Should only be called by HSSFRow.
|
Modifier and Type | Method and Description |
---|---|
static CellType |
CellFormat.ultimateType(Cell cell)
Returns the ultimate cell type, following the results of formulas.
|
Modifier and Type | Method and Description |
---|---|
CellType |
BaseFormulaEvaluator.evaluateFormulaCell(Cell cell)
If cell contains formula, it evaluates the formula,
and saves the result of the formula.
|
CellType |
EvaluationCell.getCachedFormulaResultType() |
CellType |
EvaluationCell.getCellType() |
Modifier and Type | Method and Description |
---|---|
static boolean |
DataValidationEvaluator.isType(Cell cell,
CellType type)
Note that this assumes the cell cached value is up to date and in sync with data edits
|
protected void |
BaseFormulaEvaluator.setCellType(Cell cell,
CellType cellType)
Override if a different variation is needed, e.g.
|
Modifier and Type | Method and Description |
---|---|
CellType |
FormulaEvaluator.evaluateFormulaCell(Cell cell)
If cell contains formula, it evaluates the formula,
and saves the result of the formula.
|
static CellType |
CellType.forInt(int code)
Deprecated.
POI 3.15 beta 3. Used to transition code from
int s to CellType s. |
CellType |
Cell.getCachedFormulaResultType()
Only valid for formula cells
|
CellType |
Cell.getCellType()
Return the cell type.
|
CellType |
CellValue.getCellType()
Return the cell type.
|
protected CellType |
CellBase.getValueType()
Get value type of this cell.
|
static CellType |
CellType.valueOf(java.lang.String name)
Returns the enum constant of this type with the specified name.
|
static CellType[] |
CellType.values()
Returns an array containing the constants of this enum type, in
the order they are declared.
|
Modifier and Type | Method and Description |
---|---|
Cell |
Row.createCell(int column,
CellType type)
Use this to create new cells within the row and return it.
|
void |
CellBase.setCellType(CellType cellType)
Set the cells type (blank, numeric, boolean, error or string).
|
void |
Cell.setCellType(CellType cellType)
Deprecated.
This method is deprecated and will be removed in POI 5.0.
Use explicit
Cell.setCellFormula(String) , setCellValue(...) or Cell.setBlank()
to get the desired result. |
protected abstract void |
CellBase.setCellTypeImpl(CellType cellType)
Implementation-specific logic
|
Modifier and Type | Method and Description |
---|---|
CellType |
SXSSFCell.getCachedFormulaResultType()
Only valid for formula cells
|
CellType |
SXSSFCell.getCellType()
Return the cell type.
|
Modifier and Type | Method and Description |
---|---|
SXSSFCell |
SXSSFRow.createCell(int column,
CellType type)
Use this to create new cells within the row and return it.
|
protected void |
SXSSFCell.setCellTypeImpl(CellType cellType) |
Constructor and Description |
---|
SXSSFCell(SXSSFRow row,
CellType cellType) |
Modifier and Type | Method and Description |
---|---|
CellType |
XSSFCell.getCachedFormulaResultType()
Only valid for formula cells
|
CellType |
XSSFCell.getCellType()
Return the cell type.
|
Modifier and Type | Method and Description |
---|---|
XSSFCell |
XSSFRow.createCell(int columnIndex,
CellType type)
Use this to create new cells within the row and return it.
|
protected void |
BaseXSSFFormulaEvaluator.setCellType(Cell cell,
CellType cellType) |
protected void |
XSSFCell.setCellType(CellType cellType,
BaseXSSFEvaluationWorkbook evalWb)
Needed by bug #62834, which points out getCellFormula() expects an evaluation context or creates a new one,
so if there is one in use, it needs to be carried on through.
|
protected void |
XSSFCell.setCellTypeImpl(CellType cellType) |
Copyright 2021 The Apache Software Foundation or its licensors, as applicable.