Uses of Enum Class
org.apache.poi.ss.usermodel.CellType
Packages that use CellType
Package
Description
usermodel package maps HSSF low level strutures to familiar workbook/sheet model
This package contains classes that implement cell formatting
This package contains common internal POI code for manipulating formulas.
-
Uses of CellType in org.apache.poi.hssf.usermodel
Methods in org.apache.poi.hssf.usermodel that return CellTypeModifier and TypeMethodDescriptionHSSFCell.getCachedFormulaResultType()
Only valid for formula cellsHSSFCell.getCachedFormulaResultTypeEnum()
Deprecated.HSSFCell.getCellType()
get the cells type (numeric, formula or string)HSSFCell.getCellTypeEnum()
Deprecated.Methods in org.apache.poi.hssf.usermodel with parameters of type CellTypeModifier and TypeMethodDescriptionHSSFRow.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).Constructors in org.apache.poi.hssf.usermodel with parameters of type CellTypeModifierConstructorDescriptionprotected
HSSFCell
(HSSFWorkbook book, HSSFSheet sheet, int row, short col, CellType type) Creates new Cell - Should only be called by HSSFRow. -
Uses of CellType in org.apache.poi.ss.format
Methods in org.apache.poi.ss.format that return CellTypeModifier and TypeMethodDescriptionstatic CellType
CellFormat.ultimateType
(Cell cell) Returns the ultimate cell type, following the results of formulas.static CellType
CellFormat.ultimateTypeEnum
(Cell cell) Deprecated.useultimateType
instead -
Uses of CellType in org.apache.poi.ss.formula
Methods in org.apache.poi.ss.formula that return CellTypeModifier and TypeMethodDescriptionBaseFormulaEvaluator.evaluateFormulaCell
(Cell cell) If cell contains formula, it evaluates the formula, and saves the result of the formula.BaseFormulaEvaluator.evaluateFormulaCellEnum
(Cell cell) Deprecated.useevaluateFormulaCell(cell)
insteadEvaluationCell.getCachedFormulaResultType()
EvaluationCell.getCachedFormulaResultTypeEnum()
Deprecated.POI 3.15 beta 3.EvaluationCell.getCellType()
EvaluationCell.getCellTypeEnum()
Deprecated.POI 3.15 beta 3.Methods in org.apache.poi.ss.formula with parameters of type CellTypeModifier and TypeMethodDescriptionstatic boolean
Note that this assumes the cell cached value is up to date and in sync with data editsprotected void
BaseFormulaEvaluator.setCellType
(Cell cell, CellType cellType) Override if a different variation is needed, e.g. -
Uses of CellType in org.apache.poi.ss.usermodel
Methods in org.apache.poi.ss.usermodel that return CellTypeModifier and TypeMethodDescriptionFormulaEvaluator.evaluateFormulaCell
(Cell cell) If cell contains formula, it evaluates the formula, and saves the result of the formula.FormulaEvaluator.evaluateFormulaCellEnum
(Cell cell) Deprecated.useevaluateFormulaCell(cell)
static CellType
CellType.forInt
(int code) Deprecated.POI 3.15 beta 3.Cell.getCachedFormulaResultType()
Only valid for formula cells Will returnCellType
in a future version of POI.Deprecated.Cell.getCellType()
Return the cell type.CellValue.getCellType()
Return the cell type.Cell.getCellTypeEnum()
Deprecated.CellValue.getCellTypeEnum()
Deprecated.usegetCellType
insteadstatic CellType
Returns the enum constant of this class with the specified name.static CellType[]
CellType.values()
Returns an array containing the constants of this enum class, in the order they are declared.Methods in org.apache.poi.ss.usermodel with parameters of type CellTypeModifier and TypeMethodDescriptionRow.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). -
Uses of CellType in org.apache.poi.xssf.streaming
Methods in org.apache.poi.xssf.streaming that return CellTypeModifier and TypeMethodDescriptionSXSSFCell.getCachedFormulaResultType()
Only valid for formula cellsSXSSFCell.getCachedFormulaResultTypeEnum()
Deprecated.usegetCachedFormulaResultType
insteadSXSSFCell.getCellType()
Return the cell type.SXSSFCell.getCellTypeEnum()
Deprecated.usegetCellType
insteadMethods in org.apache.poi.xssf.streaming with parameters of type CellTypeModifier and TypeMethodDescriptionSXSSFRow.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)Constructors in org.apache.poi.xssf.streaming with parameters of type CellType -
Uses of CellType in org.apache.poi.xssf.usermodel
Methods in org.apache.poi.xssf.usermodel that return CellTypeModifier and TypeMethodDescriptionXSSFCell.getCachedFormulaResultType()
Only valid for formula cellsXSSFCell.getCachedFormulaResultTypeEnum()
Deprecated.usegetCachedFormulaResultType
instead Will be deleted when we make the CellType enum transition.XSSFCell.getCellType()
Return the cell type.XSSFCell.getCellTypeEnum()
Deprecated.usegetCellType
insteadMethods in org.apache.poi.xssf.usermodel with parameters of type CellTypeModifier and TypeMethodDescriptionXSSFRow.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) void
XSSFCell.setCellType
(CellType cellType) Set the cells type (numeric, formula or string)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.
getCachedFormulaResultType
Will be deleted when we make the CellType enum transition.