Java org.apache.poi.xssf.usermodel XSSFCell fields, constructors, methods, implement or subclass

Example usage for Java org.apache.poi.xssf.usermodel XSSFCell fields, constructors, methods, implement or subclass

Introduction

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

The text is from its open source code.

Method

booleangetBooleanCellValue()
Get the value of the cell as a boolean.
CellTypegetCachedFormulaResultType()
Only valid for formula cells
XSSFCommentgetCellComment()
Returns cell comment associated with this cell
StringgetCellFormula()
Return a formula for the cell, for example, SUM(C4:E4)
XSSFCellStylegetCellStyle()
Return the cell's style.
CellTypegetCellType()
Return the cell type.
CellTypegetCellTypeEnum()
intgetColumnIndex()
Returns column index of this cell
CTCellgetCTCell()
Returns the xml bean containing information about the cell's location (reference), value, data type, formatting, and formula
DategetDateCellValue()
Get the value of the cell as a date.
StringgetErrorCellString()
Returns the error message, such as #VALUE!
bytegetErrorCellValue()
Get the value of the cell as an error code.
XSSFHyperlinkgetHyperlink()
Returns hyperlink associated with this cell
doublegetNumericCellValue()
Get the value of the cell as a number.
StringgetRawValue()
Returns the raw, underlying ooxml value for the cell

If the cell contains a string, then this value is an index into the shared string table, pointing to the actual string value.

StringgetReference()
Returns an A1 style reference to the location of this cell
XSSFRichTextStringgetRichStringCellValue()
Get the value of the cell as a XSSFRichTextString

For numeric cells we throw an exception.

intgetRowIndex()
Returns row index of a row in the sheet that contains this cell
XSSFSheetgetSheet()
Returns the sheet this cell belongs to
StringgetStringCellValue()
Get the value of the cell as a string

For numeric cells we throw an exception.

voidremoveCellComment()
Removes the comment for this cell, if there is one.
voidsetCellComment(Comment comment)
Assign a comment to this cell.
voidsetCellErrorValue(byte errorCode)
Set a error value for the cell
voidsetCellErrorValue(FormulaError error)
Set a error value for the cell
voidsetCellFormula(String formula)
voidsetCellStyle(CellStyle style)

Set the style for the cell.

voidsetCellType(CellType cellType)
voidsetCellValue(boolean value)
Set a boolean value for the cell
voidsetHyperlink(Hyperlink hyperlink)
Assign a hyperlink to this cell.
StringtoString()
Returns a string representation of the cell

Formula cells return the formula string, rather than the formula result.