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

Packages that use Cell

Package	Description
io.keikai.importer
io.keikai.range.impl.imexp	Keikai Spreadsheet Internal Range API Implementation classes.
org.zkoss.poi.hssf.usermodel	usermodel package maps HSSF low level strutures to familiar workbook/sheet model
org.zkoss.poi.ss.format	This package contains classes that implement cell formatting
org.zkoss.poi.ss.usermodel
org.zkoss.poi.ss.util
org.zkoss.poi.ss.util.cellwalk
org.zkoss.poi.xssf.streaming
org.zkoss.poi.xssf.usermodel

Uses of Cell in io.keikai.importer

Methods in io.keikai.importer with parameters of type Cell

Modifier and Type	Method and Description
protected Font	XlsxImporter.getPoiFontFromRichText(Workbook book, Cell cell, RichTextString rstr, int run)

Uses of Cell in io.keikai.range.impl.imexp

Methods in io.keikai.range.impl.imexp with parameters of type Cell

Modifier and Type	Method and Description
protected Font	AbstractExcelImporter.getPoiFontFromRichText(Workbook book, Cell cell, RichTextString rstr, int run)
protected SCell	AbstractExcelImporter.importCell(Cell poiCell, int row, SSheet sheet)
protected void	AbstractExcelImporter.importRichText(Cell poiCell, RichTextString poiRichTextString, SRichText richText)

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

Classes in org.zkoss.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.zkoss.poi.hssf.usermodel that return types with arguments of type Cell

Modifier and Type	Method and Description
Iterator<Cell>	HSSFRow.cellIterator()

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

Modifier and Type	Method and Description
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.zkoss.poi.ss.format

Methods in org.zkoss.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(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.zkoss.poi.ss.usermodel

Classes in org.zkoss.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.zkoss.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, 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.zkoss.poi.ss.usermodel that return types with arguments of type Cell

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

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

Modifier and Type	Method and Description
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.
String	DataFormatter.formatCellValue(Cell cell) Returns the formatted value of a cell as a String regardless of the cell type.
String	DataFormatter.formatCellValue(Cell cell, FormulaEvaluator evaluator) Returns the formatted value of a cell as a String regardless of the cell type.
String	DataFormatter.formatCellValue(Cell cell, int cellType)
Format	DataFormatter.getDefaultFormat(Cell cell) Returns a default format for a cell.
static Format	DataFormatter.getJavaFormat(Cell cell, Locale locale)
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.zkoss.poi.ss.util

Classes in org.zkoss.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.zkoss.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, List<B> flattenedList, Class<B> cellClass)

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

Modifier and Type	Method and Description
static 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 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.zkoss.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
static void	CellUtil.setAlignment(Cell cell, Workbook workbook, short align) Take a cell, and align it.
static void	CellUtil.setCellStyleProperty(Cell cell, Workbook workbook, String propertyName, 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.zkoss.poi.ss.util with parameters of type Cell

Constructor and Description
CellReference(Cell cell)

Uses of Cell in org.zkoss.poi.ss.util.cellwalk

Methods in org.zkoss.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.zkoss.poi.xssf.streaming

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

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

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

Modifier and Type	Method and Description
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.zkoss.poi.xssf.streaming that return types with arguments of type Cell

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

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

Modifier and Type	Method and Description
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.zkoss.poi.xssf.usermodel

Classes in org.zkoss.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.zkoss.poi.xssf.usermodel that return types with arguments of type Cell

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

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

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