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

Packages that use Cell

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.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

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

java.util.Iterator<Cell>

HSSFRow.cellIterator()

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

CellValue	HSSFFormulaEvaluator.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.
int	HSSFFormulaEvaluator.evaluateFormulaCell(Cell cell) If cell contains formula, it evaluates the formula, and saves the result of the formula.
HSSFCell	HSSFFormulaEvaluator.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.
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

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 int	CellFormat.ultimateType(Cell cell) Returns the ultimate cell type, following the results of formulas.

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

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

interface

CellRange<C extends Cell> Represents a rectangular region of a Sheet

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

Cell	Row.createCell(int column) Use this to create new cells within the row and return it.
Cell	Row.createCell(int column, int 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

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

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.
int	FormulaEvaluator.evaluateFormulaCell(Cell cell) If cell contains formula, it evaluates the formula, and saves the result of the formula.
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.text.Format	DataFormatter.getDefaultFormat(Cell cell) Returns a default format for a cell.
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.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

class

SSCellRange<K extends Cell> For POI internal use only

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

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

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.
K[][]	SSCellRange.getCells()
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

static double	SheetUtil.getCellWidth(Cell cell, int defaultCharWidth, DataFormatter formatter, boolean useMergedCells) Compute width of a single cell
static void	CellUtil.setAlignment(Cell cell, Workbook workbook, short align) Take a cell, and align it.
static void	CellUtil.setCellStyleProperty(Cell cell, Workbook workbook, java.lang.String propertyName, java.lang.Object propertyValue) This method attempt to find an already existing CellStyle that matches what you want the style to be.
static void	CellUtil.setFont(Cell cell, Workbook workbook, Font font) Take a cell, and apply a font to 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

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

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

class

SXSSFCell Streaming version of XSSFRow implementing the "BigGridDemo" strategy.

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

Cell	SXSSFRow.createCell(int column) Use this to create new cells within the row and return it.
Cell	SXSSFRow.createCell(int column, int type) Use this to create new cells within the row and return it.
Cell	SXSSFRow.getCell(int cellnum) Get the cell representing a given column (logical cell) 0-based.
Cell	SXSSFRow.getCell(int cellnum, Row.MissingCellPolicy policy) Returns the cell at the given (0 based) index, with the specified Row.MissingCellPolicy
Cell	SXSSFRow.FilledCellIterator.next()
Cell	SXSSFRow.CellIterator.next()

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

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

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.
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

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

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

CellValue	XSSFFormulaEvaluator.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.
int	XSSFFormulaEvaluator.evaluateFormulaCell(Cell cell) If cell contains formula, it evaluates the formula, and saves the result of the formula.
XSSFCell	XSSFFormulaEvaluator.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.
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.