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

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

Copyright 2010 The Apache Software Foundation or its licensors, as applicable.