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.voidHSSFCell.setCellType(CellType cellType) Set the cells type (numeric, formula or string).Constructors in org.apache.poi.hssf.usermodel with parameters of type CellTypeModifierConstructorDescriptionprotectedHSSFCell(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 CellTypeCellFormat.ultimateType(Cell cell) Returns the ultimate cell type, following the results of formulas.static CellTypeCellFormat.ultimateTypeEnum(Cell cell) Deprecated.useultimateTypeinstead -
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 booleanNote that this assumes the cell cached value is up to date and in sync with data editsprotected voidBaseFormulaEvaluator.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 CellTypeCellType.forInt(int code) Deprecated.POI 3.15 beta 3.Cell.getCachedFormulaResultType()Only valid for formula cells Will returnCellTypein a future version of POI.Deprecated.Cell.getCellType()Return the cell type.CellValue.getCellType()Return the cell type.Cell.getCellTypeEnum()Deprecated.CellValue.getCellTypeEnum()Deprecated.usegetCellTypeinsteadstatic CellTypeReturns 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.voidCell.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.usegetCachedFormulaResultTypeinsteadSXSSFCell.getCellType()Return the cell type.SXSSFCell.getCellTypeEnum()Deprecated.usegetCellTypeinsteadMethods 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.voidSXSSFCell.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.usegetCachedFormulaResultTypeinstead Will be deleted when we make the CellType enum transition.XSSFCell.getCellType()Return the cell type.XSSFCell.getCellTypeEnum()Deprecated.usegetCellTypeinsteadMethods 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 voidBaseXSSFFormulaEvaluator.setCellType(Cell cell, CellType cellType) voidXSSFCell.setCellType(CellType cellType) Set the cells type (numeric, formula or string)protected voidXSSFCell.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.
getCachedFormulaResultTypeWill be deleted when we make the CellType enum transition.