Overview | Package | Class | Use | Tree | Deprecated | Index | Help
PREV NEXT | FRAMES NO FRAMES

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

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 Cell
`Cell` | `HSSFRow.createCell(int column)` Use this to create new cells within the row and return it.
`Cell` | `HSSFRow.createCell(int columnIndex, int type)` Use this to create new cells within the row and return it.
`Cell` | `HSSFRow.createCell(short columnIndex)` Deprecated. (Aug 2008) use `HSSFRow.createCell(int)`
`Cell` | `HSSFRow.createCell(short columnIndex, int type)` Deprecated. (Aug 2008) use `HSSFRow.createCell(int, int)`
`Cell` | `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.
`Cell` | `HSSFRow.getCell(int cellnum)` Get the hssfcell representing a given column (logical cell) 0-based.
`Cell` | `HSSFRow.getCell(int cellnum, Row.MissingCellPolicy policy)` Get the hssfcell representing a given column (logical cell) 0-based.
`Cell` | `HSSFRow.getCell(short cellnum)` Deprecated. (Aug 2008) use `HSSFRow.getCell(int)`

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

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`

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

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

Overview | Package | Class | Use | Tree | Deprecated | Index | Help
PREV NEXT | FRAMES NO FRAMES