Package | Description |
---|---|
org.apache.poi.hssf.usermodel |
usermodel package maps HSSF low level strutures 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 |
HSSFCell.getCachedFormulaResultTypeEnum()
Only valid for formula cells
|
CellType |
HSSFCell.getCellTypeEnum()
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.
|
void |
HSSFCell.setCellType(CellType cellType)
Set the cells type (numeric, formula or string).
|
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.ultimateTypeEnum(Cell cell)
Deprecated.
POI 3.15 beta 3
Will be deleted when we make the CellType enum transition. See bug 59791.
|
Modifier and Type | Method and Description |
---|---|
CellType |
BaseFormulaEvaluator.evaluateFormulaCellEnum(Cell cell)
If cell contains formula, it evaluates the formula,
and saves the result of the formula.
|
CellType |
EvaluationCell.getCachedFormulaResultTypeEnum()
Deprecated.
POI 3.15 beta 3.
Will be deleted when we make the CellType enum transition. See bug 59791.
|
CellType |
EvaluationCell.getCellTypeEnum()
Deprecated.
POI 3.15 beta 3.
Will be deleted when we make the CellType enum transition. See bug 59791.
|
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
|
Modifier and Type | Method and Description |
---|---|
CellType |
FormulaEvaluator.evaluateFormulaCellEnum(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.getCachedFormulaResultTypeEnum()
Only valid for formula cells
|
CellType |
CellValue.getCellTypeEnum()
Return the cell type.
|
CellType |
Cell.getCellTypeEnum()
Return the cell type.
|
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 |
Cell.setCellType(CellType cellType)
Set the cells type (numeric, formula or string).
|
Modifier and Type | Method and Description |
---|---|
CellType |
SXSSFCell.getCachedFormulaResultTypeEnum()
Only valid for formula cells
|
CellType |
SXSSFCell.getCellTypeEnum()
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.
|
void |
SXSSFCell.setCellType(CellType cellType)
Set the cells type (numeric, formula or string)
|
Constructor and Description |
---|
SXSSFCell(SXSSFRow row,
CellType cellType) |
Modifier and Type | Method and Description |
---|---|
CellType |
XSSFCell.getCachedFormulaResultTypeEnum()
Only valid for formula cells
|
CellType |
XSSFCell.getCellTypeEnum()
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.
|
void |
XSSFCell.setCellType(CellType cellType)
Set the cells type (numeric, formula or string)
|
Copyright 2018 The Apache Software Foundation or its licensors, as applicable.