Uses of Interface
org.apache.poi.ss.usermodel.Cell
Packages that use Cell
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 Cell in org.apache.poi.hssf.usermodel
Classes in org.apache.poi.hssf.usermodel that implement CellModifier and TypeClassDescriptionclass
High level representation of a cell in a row of a spreadsheet.Methods in org.apache.poi.hssf.usermodel that return types with arguments of type CellModifier and TypeMethodDescriptionHSSFRow.cellIterator()
HSSFRow.iterator()
Alias forHSSFRow.cellIterator()
to allow foreach loopsMethods in org.apache.poi.hssf.usermodel with parameters of type CellModifier and TypeMethodDescriptionprotected void
HSSFRangeCopier.adjustCellReferencesInsideFormula
(Cell cell, Sheet destSheet, int deltaX, int deltaY) protected CellValue
HSSFFormulaEvaluator.evaluateFormulaCellValue
(Cell cell) Returns a CellValue wrapper around the supplied ValueEval instance.HSSFFormulaEvaluator.evaluateInCell
(Cell cell) void
HSSFFormulaEvaluator.notifyDeleteCell
(Cell cell) void
HSSFFormulaEvaluator.notifySetFormula
(Cell cell) Should be called to tell the cell value cache that the specified (value or formula) cell has changed.void
HSSFFormulaEvaluator.notifyUpdateCell
(Cell cell) HSSFSheet.removeArrayFormula
(Cell cell) void
HSSFRow.removeCell
(Cell cell) remove the HSSFCell from this row. -
Uses of Cell in org.apache.poi.ss.format
Methods in org.apache.poi.ss.format with parameters of type CellModifier and TypeMethodDescriptionFetches the appropriate value from the cell, and uses the result, setting the text and color of a label before returning the result.Fetches the appropriate value from the cell, and returns the result of applying it to the appropriate format.static CellType
CellFormat.ultimateType
(Cell cell) Returns the ultimate cell type, following the results of formulas.static CellType
CellFormat.ultimateTypeEnum
(Cell cell) Deprecated. -
Uses of Cell in org.apache.poi.ss.formula
Methods in org.apache.poi.ss.formula that return CellModifier and TypeMethodDescriptionBaseFormulaEvaluator.evaluateInCell
(Cell cell) If cell contains formula, it evaluates the formula, and puts the formula result back into the cell, in place of the old formula.Methods in org.apache.poi.ss.formula that return types with arguments of type CellModifier and TypeMethodDescriptionConditionalFormattingEvaluator.getMatchingCells
(EvaluationConditionalFormatRule rule) Retrieve all cells where the given formatting rule evaluates to true.ConditionalFormattingEvaluator.getMatchingCells
(Sheet sheet, int conditionalFormattingIndex, int ruleIndex) Conditional formatting rules can apply only to cells in the sheet to which they are attached.Methods in org.apache.poi.ss.formula with parameters of type CellModifier and TypeMethodDescriptionIf cell contains a formula, the formula is evaluated and returned, else the CellValue simply copies the appropriate cell value from the cell and also its cell type.BaseFormulaEvaluator.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)
insteadprotected abstract CellValue
BaseFormulaEvaluator.evaluateFormulaCellValue
(Cell cell) BaseFormulaEvaluator.evaluateInCell
(Cell cell) If cell contains formula, it evaluates the formula, and puts the formula result back into the cell, in place of the old formula.ConditionalFormattingEvaluator.getConditionalFormattingForCell
(Cell cell) This checks all applicableConditionalFormattingRule
s for the cell's sheet, in defined "priority" order, returning the matches if any.static CellReference
static boolean
Note that this assumes the cell cached value is up to date and in sync with data editsstatic boolean
DataValidationEvaluator.ValidationEnum.isValid
(Cell cell, DataValidationEvaluator.DataValidationContext context) Validates against the type defined in context, as an index of the enum values array.protected boolean
DataValidationEvaluator.ValidationEnum.isValidNumericCell
(Cell cell, DataValidationEvaluator.DataValidationContext context) Uses the cell value, which may be the cached formula result value.boolean
DataValidationEvaluator.ValidationEnum.isValidValue
(Cell cell, DataValidationEvaluator.DataValidationContext context) protected void
BaseFormulaEvaluator.setCellType
(Cell cell, CellType cellType) Override if a different variation is needed, e.g.protected void
BaseFormulaEvaluator.setCellType
(Cell cell, CellValue cv) set the cell typeprotected void
BaseFormulaEvaluator.setCellValue
(Cell cell, CellValue cv) -
Uses of Cell in org.apache.poi.ss.usermodel
Classes in org.apache.poi.ss.usermodel with type parameters of type CellMethods in org.apache.poi.ss.usermodel that return CellModifier and TypeMethodDescriptionRow.createCell
(int column) Use this to create new cells within the row and return it.Row.createCell
(int column, CellType type) Use this to create new cells within the row and return it.FormulaEvaluator.evaluateInCell
(Cell cell) If cell contains formula, it evaluates the formula, and puts the formula result back into the cell, in place of the old formula.Row.getCell
(int cellnum) Get the cell representing a given column (logical cell) 0-based.Row.getCell
(int cellnum, Row.MissingCellPolicy policy) Returns the cell at the given (0 based) index, with the specifiedRow.MissingCellPolicy
C[][]
CellRange.getCells()
C[]
CellRange.getFlattenedCells()
Methods in org.apache.poi.ss.usermodel that return types with arguments of type CellModifier and TypeMethodDescriptionRow.cellIterator()
Sheet.removeArrayFormula
(Cell cell) Remove a Array Formula from this sheet.Sheet.setArrayFormula
(String formula, CellRangeAddress range) Sets array formula to specified region for result.Methods in org.apache.poi.ss.usermodel with parameters of type CellModifier and TypeMethodDescriptionprotected abstract void
RangeCopier.adjustCellReferencesInsideFormula
(Cell cell, Sheet destSheet, int deltaX, int deltaY) A range is returned only for the part of the table matching this enum instance and containing the given cell.static void
default boolean
checks if the given cell is part of the table.DataFormatter.createFormat
(Cell cell) Create and return a Format based on the format string from a cell's style.If cell contains a formula, the formula is evaluated and returned, else the CellValue simply copies the appropriate cell value from the cell and also its cell type.FormulaEvaluator.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)
FormulaEvaluator.evaluateInCell
(Cell cell) If cell contains formula, it evaluates the formula, and puts the formula result back into the cell, in place of the old formula.DataFormatter.formatCellValue
(Cell cell) Returns the formatted value of a cell as a String regardless of the cell type.DataFormatter.formatCellValue
(Cell cell, FormulaEvaluator evaluator) Returns the formatted value of a cell as a String regardless of the cell type.DataFormatter.formatCellValue
(Cell cell, FormulaEvaluator evaluator, ConditionalFormattingEvaluator cfEvaluator) Returns the formatted value of a cell as a String regardless of the cell type.static ExcelNumberFormat
ExcelNumberFormat.from
(Cell cell, ConditionalFormattingEvaluator cfEvaluator) DataFormatter.getDefaultFormat
(Cell cell) Returns a default format for a cell.final CellRangeAddressBase
static boolean
DateUtil.isCellDateFormatted
(Cell cell) Check if a cell contains a date Since dates are stored internally in Excel as double values we infer it is a date if it is formatted as such.static boolean
DateUtil.isCellDateFormatted
(Cell cell, ConditionalFormattingEvaluator cfEvaluator) Check if a cell contains a date Since dates are stored internally in Excel as double values we infer it is a date if it is formatted as such.static boolean
DateUtil.isCellInternalDateFormatted
(Cell cell) Check if a cell contains a date, checking only for internal excel date formats.void
FormulaEvaluator.notifyDeleteCell
(Cell cell) Should be called to tell the cell value cache that the specified cell has just become a formula cell, or the formula text has changedvoid
FormulaEvaluator.notifySetFormula
(Cell cell) Should be called to tell the cell value cache that the specified (value or formula) cell has changed.void
FormulaEvaluator.notifyUpdateCell
(Cell cell) Should be called to tell the cell value cache that the specified (value or formula) cell has changed.Sheet.removeArrayFormula
(Cell cell) Remove a Array Formula from this sheet.void
Row.removeCell
(Cell cell) Remove the Cell from this row. -
Uses of Cell in org.apache.poi.ss.util
Classes in org.apache.poi.ss.util with type parameters of type CellModifier and TypeClassDescriptionfinal class
SSCellRange<K extends Cell>
For POI internal use onlyMethods in org.apache.poi.ss.util with type parameters of type CellModifier and TypeMethodDescriptionstatic <B extends Cell>
SSCellRange<B>SSCellRange.create
(int firstRow, int firstColumn, int height, int width, List<B> flattenedList, Class<B> cellClass) Methods in org.apache.poi.ss.util that return CellModifier and TypeMethodDescriptionstatic Cell
CellUtil.createCell
(Row row, int column, String value) Create a cell, and give it a value.static Cell
CellUtil.createCell
(Row row, int column, String value, CellStyle style) Creates a cell, gives it a value, and applies a style if providedstatic Cell
Get a specific cell from a row.static Cell
Return the cell, without taking account of merged regions.K[][]
SSCellRange.getCells()
static Cell
SheetUtil.getCellWithMerges
(Sheet sheet, int rowIx, int colIx) Return the cell, taking account of merged regions.K[]
SSCellRange.getFlattenedCells()
static Cell
CellUtil.translateUnicodeValues
(Cell cell) Looks for text in the cell that should be unicode, like α and provides the unicode version of it.Methods in org.apache.poi.ss.util with parameters of type CellModifier and TypeMethodDescriptionstatic double
SheetUtil.getCellWidth
(Cell cell, int defaultCharWidth, DataFormatter formatter, boolean useMergedCells) Compute width of a single cellboolean
Determines if the givenCell
lies within the bounds of this range.static void
CellUtil.setAlignment
(Cell cell, HorizontalAlignment align) Take a cell, and align it.static void
CellUtil.setCellStyleProperties
(Cell cell, Map<String, Object> properties) This method attempts to find an existing CellStyle that matches thecell
's current style plus styles properties inproperties
.static void
CellUtil.setCellStyleProperty
(Cell cell, String propertyName, Object propertyValue) This method attempts to find an existing CellStyle that matches thecell
's current style plus a single style propertypropertyName
with valuepropertyValue
.static void
Take a cell, and apply a font to itstatic void
CellUtil.setVerticalAlignment
(Cell cell, VerticalAlignment align) Take a cell, and vertically align it.static Cell
CellUtil.translateUnicodeValues
(Cell cell) Looks for text in the cell that should be unicode, like α and provides the unicode version of it.Constructors in org.apache.poi.ss.util with parameters of type CellModifierConstructorDescriptionCellAddress
(Cell cell) Create a new CellAddress object.CellReference
(Cell cell) -
Uses of Cell in org.apache.poi.ss.util.cellwalk
Methods in org.apache.poi.ss.util.cellwalk with parameters of type Cell -
Uses of Cell in org.apache.poi.xssf.streaming
Classes in org.apache.poi.xssf.streaming that implement CellModifier and TypeClassDescriptionclass
Streaming version of XSSFCell implementing the "BigGridDemo" strategy.Methods in org.apache.poi.xssf.streaming that return CellModifier and TypeMethodDescriptionSXSSFRow.CellIterator.next()
SXSSFRow.FilledCellIterator.next()
Methods in org.apache.poi.xssf.streaming that return types with arguments of type CellModifier and TypeMethodDescriptionSXSSFRow.allCellsIterator()
SXSSFRow.cellIterator()
SXSSFRow.iterator()
SXSSFSheet.removeArrayFormula
(Cell cell) Remove a Array Formula from this sheet.SXSSFSheet.setArrayFormula
(String formula, CellRangeAddress range) Sets array formula to specified region for result.Methods in org.apache.poi.xssf.streaming with parameters of type CellModifier and TypeMethodDescriptionSXSSFFormulaEvaluator.evaluateInCell
(Cell cell) void
SXSSFFormulaEvaluator.notifyDeleteCell
(Cell cell) void
SXSSFFormulaEvaluator.notifySetFormula
(Cell cell) void
SXSSFFormulaEvaluator.notifyUpdateCell
(Cell cell) SXSSFSheet.removeArrayFormula
(Cell cell) Remove a Array Formula from this sheet.void
SXSSFRow.removeCell
(Cell cell) Remove the Cell from this row.protected EvaluationCell
SXSSFFormulaEvaluator.toEvaluationCell
(Cell cell) Turns a SXSSFCell into a SXSSFEvaluationCellvoid
-
Uses of Cell in org.apache.poi.xssf.usermodel
Classes in org.apache.poi.xssf.usermodel that implement CellModifier and TypeClassDescriptionfinal class
High level representation of a cell in a row of a spreadsheet.Methods in org.apache.poi.xssf.usermodel that return types with arguments of type CellModifier and TypeMethodDescriptionXSSFRow.cellIterator()
Cell iterator over the physically defined cells:XSSFRow.iterator()
Alias forXSSFRow.cellIterator()
to allow foreach loops:Methods in org.apache.poi.xssf.usermodel with parameters of type CellModifier and TypeMethodDescriptionprotected void
XSSFRangeCopier.adjustCellReferencesInsideFormula
(Cell cell, Sheet destSheet, int deltaX, int deltaY) void
XSSFCell.copyCellFrom
(Cell srcCell, CellCopyPolicy policy) Copy cell value, formula and style, from srcCell per cell copy policy If srcCell is null, clears the cell value and cell style per cell copy policy This does not shift references in formulas.protected CellValue
BaseXSSFFormulaEvaluator.evaluateFormulaCellValue
(Cell cell) Returns a CellValue wrapper around the supplied ValueEval instance.XSSFFormulaEvaluator.evaluateInCell
(Cell cell) void
XSSFFormulaEvaluator.notifyDeleteCell
(Cell cell) void
XSSFFormulaEvaluator.notifySetFormula
(Cell cell) void
XSSFFormulaEvaluator.notifyUpdateCell
(Cell cell) XSSFSheet.removeArrayFormula
(Cell cell) void
XSSFRow.removeCell
(Cell cell) Remove the Cell from this row.protected void
BaseXSSFFormulaEvaluator.setCellType
(Cell cell, CellType cellType) protected abstract EvaluationCell
BaseXSSFFormulaEvaluator.toEvaluationCell
(Cell cell) Turns a XSSFCell / SXSSFCell into a XSSFEvaluationCellprotected EvaluationCell
XSSFFormulaEvaluator.toEvaluationCell
(Cell cell) Turns a XSSFCell into a XSSFEvaluationCell
ultimateType
instead