Java org.apache.poi.ss.usermodel Cell fields, constructors, methods, implement or subclass

Introduction

In this page you can find the methods, fields and constructors for org.apache.poi.ss.usermodel Cell.

The text is from its open source code.

Subclass

org.apache.poi.ss.usermodel.Cell has subclasses.
Click this link to see all its subclasses.

Implementation

org.apache.poi.ss.usermodel.Cell has the following implementations.
Click this link to see all its implementation.

Method

CellAddress	getAddress() Gets the address of this cell
boolean	getBooleanCellValue() Get the value of the cell as a boolean.
CellType	getCachedFormulaResultType() Only valid for formula cells Will return CellType in a future version of POI.
CellType	getCachedFormulaResultTypeEnum() Only valid for formula cells
Comment	getCellComment() Returns comment associated with this cell
String	getCellFormula() Return a formula for the cell, for example, `SUM(C4:E4)`
CellStyle	getCellStyle() Return the cell's style.
CellType	getCellType() Return the cell type.
CellType	getCellTypeEnum() Return the cell type.
int	getColumnIndex() Returns column index of this cell
Date	getDateCellValue() Get the value of the cell as a date.
byte	getErrorCellValue() Get the value of the cell as an error code.
Hyperlink	getHyperlink()
double	getNumericCellValue() Get the value of the cell as a number.
RichTextString	getRichStringCellValue() Get the value of the cell as a XSSFRichTextString For numeric cells we throw an exception.
Row	getRow() Returns the Row this cell belongs to
int	getRowIndex() Returns row index of a row in the sheet that contains this cell
Sheet	getSheet() Returns the sheet this cell belongs to
String	getStringCellValue() Get the value of the cell as a string For numeric cells we throw an exception.
boolean	isPartOfArrayFormulaGroup()
void	removeCellComment() Removes the comment for this cell, if there is one.
void	setAsActiveCell() Sets this cell as the active cell for the worksheet
void	setCellComment(Comment comment) Assign a comment to this cell
void	setCellErrorValue(byte value) Set a error value for the cell
void	setCellFormula(String formula) Sets formula for this cell.
void	setCellStyle(CellStyle style) Set the style for the cell.
void	setCellType(CellType cellType) Set the cells type (blank, numeric, boolean, error or string).
void	setCellValue(double value) Set a numeric value for the cell.
void	setCellValue(Date value) Converts the supplied date to its equivalent Excel numeric value and sets that into the cell. Note - There is actually no 'DATE' cell type in Excel.
void	setCellValue(LocalDateTime value) Converts the supplied date to its equivalent Excel numeric value and sets that into the cell. Note - There is actually no 'DATE' cell type in Excel.
void	setCellValue(LocalDate value) Converts the supplied date to its equivalent Excel numeric value and sets that into the cell. Note - There is actually no 'DATE' cell type in Excel.
void	setCellValue(Calendar value) Set a date value for the cell.
void	setCellValue(RichTextString value) Set a rich string value for the cell.
void	setCellValue(String value) Set a string value for the cell.
void	setCellValue(boolean value) Set a boolean value for the cell
void	setHyperlink(Hyperlink link) Assign a hyperlink to this cell