| 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 |
| 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
ints to CellTypes. |
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(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 |
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. |
void |
CellBase.setCellType(CellType cellType)
Set the cells type (blank, numeric, boolean, error or string).
|
protected abstract void |
CellBase.setCellTypeImpl(CellType cellType)
Implementation-specific logic
|