Uses of Interface
org.apache.poi.ss.usermodel.Cell

Packages that use Cell

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.ss.util
org.apache.poi.ss.util.cellwalk
org.apache.poi.xssf.streaming
org.apache.poi.xssf.usermodel

Uses of Cell in org.apache.poi.hssf.usermodel

Classes in org.apache.poi.hssf.usermodel that implement Cell

Modifier and Type	Class and Description
class	HSSFCell 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 Cell

Modifier and Type	Method and Description
java.util.Iterator<Cell>	HSSFRow.cellIterator()
java.util.Iterator<Cell>	HSSFRow.iterator() Alias for HSSFRow.cellIterator() to allow foreach loops

Methods in org.apache.poi.hssf.usermodel with parameters of type Cell

Modifier and Type	Method and Description
protected 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.
HSSFCell	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)
CellRange<HSSFCell>	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 Cell

Modifier and Type	Method and Description
CellFormatResult	CellFormat.apply(Cell c) Fetches the appropriate value from the cell, and returns the result of applying it to the appropriate format.
CellFormatResult	CellFormat.apply(javax.swing.JLabel label, Cell c) Fetches the appropriate value from the cell, and uses the result, setting the text and color of a label before returning the result.
static CellType	CellFormat.ultimateType(Cell cell) Returns the ultimate cell type, following the results of formulas.
static CellType	CellFormat.ultimateTypeEnum(Cell cell) Deprecated. use ultimateType instead

Uses of Cell in org.apache.poi.ss.formula

Methods in org.apache.poi.ss.formula that return Cell

Modifier and Type	Method and Description
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.

Methods in org.apache.poi.ss.formula that return types with arguments of type Cell

Modifier and Type	Method and Description
java.util.List<Cell>	ConditionalFormattingEvaluator.getMatchingCells(EvaluationConditionalFormatRule rule) Retrieve all cells where the given formatting rule evaluates to true.
java.util.List<Cell>	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 Cell

Modifier and Type	Method and Description
CellValue	BaseFormulaEvaluator.evaluate(Cell cell) 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.
CellType	BaseFormulaEvaluator.evaluateFormulaCell(Cell cell) If cell contains formula, it evaluates the formula, and saves the result of the formula.
CellType	BaseFormulaEvaluator.evaluateFormulaCellEnum(Cell cell) Deprecated. use evaluateFormulaCell(cell) instead
protected abstract CellValue	BaseFormulaEvaluator.evaluateFormulaCellValue(Cell 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.
java.util.List<EvaluationConditionalFormatRule>	ConditionalFormattingEvaluator.getConditionalFormattingForCell(Cell cell) This checks all applicable ConditionalFormattingRules for the cell's sheet, in defined "priority" order, returning the matches if any.
static CellReference	ConditionalFormattingEvaluator.getRef(Cell cell)
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
static 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 type
protected 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 Cell

Modifier and Type	Interface and Description
interface	CellRange<C extends Cell> Represents a rectangular region of a Sheet

Methods in org.apache.poi.ss.usermodel that return Cell

Modifier and Type	Method and Description
Cell	Row.createCell(int column) Use this to create new cells within the row and return it.
Cell	Row.createCell(int column, CellType type) Use this to create new cells within the row and return it.
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.
Cell	Row.getCell(int cellnum) Get the cell representing a given column (logical cell) 0-based.
Cell	Row.getCell(int cellnum, Row.MissingCellPolicy policy) Returns the cell at the given (0 based) index, with the specified Row.MissingCellPolicy
C[][]	CellRange.getCells()
C[]	CellRange.getFlattenedCells()

Methods in org.apache.poi.ss.usermodel that return types with arguments of type Cell

Modifier and Type	Method and Description
java.util.Iterator<Cell>	Row.cellIterator()
CellRange<? extends Cell>	Sheet.removeArrayFormula(Cell cell) Remove a Array Formula from this sheet.
CellRange<? extends Cell>	Sheet.setArrayFormula(java.lang.String formula, CellRangeAddress range) Sets array formula to specified region for result.

Methods in org.apache.poi.ss.usermodel with parameters of type Cell

Modifier and Type	Method and Description
protected abstract void	RangeCopier.adjustCellReferencesInsideFormula(Cell cell, Sheet destSheet, int deltaX, int deltaY)
CellRangeAddressBase	TableStyleType.appliesTo(Table table, Cell cell) A range is returned only for the part of the table matching this enum instance and containing the given cell.
static void	RangeCopier.cloneCellContent(Cell srcCell, Cell destCell, java.util.Map<java.lang.Integer,CellStyle> styleMap)
default boolean	Table.contains(Cell cell) checks if the given cell is part of the table.
java.text.Format	DataFormatter.createFormat(Cell cell) Create and return a Format based on the format string from a cell's style.
CellValue	FormulaEvaluator.evaluate(Cell cell) 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.
CellType	FormulaEvaluator.evaluateFormulaCell(Cell cell) If cell contains formula, it evaluates the formula, and saves the result of the formula.
CellType	FormulaEvaluator.evaluateFormulaCellEnum(Cell cell) Deprecated. use evaluateFormulaCell(cell)
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.
java.lang.String	DataFormatter.formatCellValue(Cell cell) Returns the formatted value of a cell as a String regardless of the cell type.
java.lang.String	DataFormatter.formatCellValue(Cell cell, FormulaEvaluator evaluator) Returns the formatted value of a cell as a String regardless of the cell type.
java.lang.String	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)
java.text.Format	DataFormatter.getDefaultFormat(Cell cell) Returns a default format for a cell.
CellRangeAddressBase	TableStyleType.getRange(Table table, Cell cell) Calls TableStyleType.getRange(Table, CellReference).
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 changed
void	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.
CellRange<? extends Cell>	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 Cell

Modifier and Type	Class and Description
class	SSCellRange<K extends Cell> For POI internal use only

Methods in org.apache.poi.ss.util with type parameters of type Cell

Modifier and Type	Method and Description
static <B extends Cell> SSCellRange<B>	SSCellRange.create(int firstRow, int firstColumn, int height, int width, java.util.List<B> flattenedList, java.lang.Class<B> cellClass)

Methods in org.apache.poi.ss.util that return Cell

Modifier and Type	Method and Description
static Cell	CellUtil.createCell(Row row, int column, java.lang.String value) Create a cell, and give it a value.
static Cell	CellUtil.createCell(Row row, int column, java.lang.String value, CellStyle style) Creates a cell, gives it a value, and applies a style if provided
static Cell	CellUtil.getCell(Row row, int columnIndex) Get a specific cell from a row.
static Cell	SheetUtil.getCell(Sheet sheet, int rowIx, int colIx) 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 Cell

Modifier and Type	Method and Description
static double	SheetUtil.getCellWidth(Cell cell, int defaultCharWidth, DataFormatter formatter, boolean useMergedCells) Compute width of a single cell
boolean	CellRangeAddressBase.isInRange(Cell cell) Determines if the given Cell 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, java.util.Map<java.lang.String,java.lang.Object> properties) This method attempts to find an existing CellStyle that matches the cell's current style plus styles properties in properties.
static void	CellUtil.setCellStyleProperty(Cell cell, java.lang.String propertyName, java.lang.Object propertyValue) This method attempts to find an existing CellStyle that matches the cell's current style plus a single style property propertyName with value propertyValue.
static void	CellUtil.setFont(Cell cell, Font font) Take a cell, and apply a font to it
static 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 Cell

Constructor and Description
CellAddress(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

Modifier and Type	Method and Description
void	CellHandler.onCell(Cell cell, CellWalkContext ctx)

Uses of Cell in org.apache.poi.xssf.streaming

Classes in org.apache.poi.xssf.streaming that implement Cell

Modifier and Type	Class and Description
class	SXSSFCell Streaming version of XSSFCell implementing the "BigGridDemo" strategy.

Methods in org.apache.poi.xssf.streaming that return Cell

Modifier and Type	Method and Description
Cell	SXSSFRow.FilledCellIterator.next()
Cell	SXSSFRow.CellIterator.next()

Methods in org.apache.poi.xssf.streaming that return types with arguments of type Cell

Modifier and Type	Method and Description
java.util.Iterator<Cell>	SXSSFRow.allCellsIterator()
java.util.Iterator<Cell>	SXSSFRow.cellIterator()
java.util.Iterator<Cell>	SXSSFRow.iterator()
CellRange<? extends Cell>	SXSSFSheet.removeArrayFormula(Cell cell) Remove a Array Formula from this sheet.
CellRange<? extends Cell>	SXSSFSheet.setArrayFormula(java.lang.String formula, CellRangeAddress range) Sets array formula to specified region for result.

Methods in org.apache.poi.xssf.streaming with parameters of type Cell

Modifier and Type	Method and Description
SXSSFCell	SXSSFFormulaEvaluator.evaluateInCell(Cell cell)
void	SXSSFFormulaEvaluator.notifyDeleteCell(Cell cell)
void	SXSSFFormulaEvaluator.notifySetFormula(Cell cell)
void	SXSSFFormulaEvaluator.notifyUpdateCell(Cell cell)
CellRange<? extends 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 SXSSFEvaluationCell
void	SheetDataWriter.writeCell(int columnIndex, Cell cell)

Uses of Cell in org.apache.poi.xssf.usermodel

Classes in org.apache.poi.xssf.usermodel that implement Cell

Modifier and Type	Class and Description
class	XSSFCell 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 Cell

Modifier and Type	Method and Description
java.util.Iterator<Cell>	XSSFRow.cellIterator() Cell iterator over the physically defined cells:
java.util.Iterator<Cell>	XSSFRow.iterator() Alias for XSSFRow.cellIterator() to allow foreach loops:

Methods in org.apache.poi.xssf.usermodel with parameters of type Cell

Modifier and Type	Method and Description
protected 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.
XSSFCell	XSSFFormulaEvaluator.evaluateInCell(Cell cell)
void	XSSFFormulaEvaluator.notifyDeleteCell(Cell cell)
void	XSSFFormulaEvaluator.notifySetFormula(Cell cell)
void	XSSFFormulaEvaluator.notifyUpdateCell(Cell cell)
CellRange<XSSFCell>	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 XSSFEvaluationCell
protected EvaluationCell	XSSFFormulaEvaluator.toEvaluationCell(Cell cell) Turns a XSSFCell into a XSSFEvaluationCell