Package org.apache.poi.ss.usermodel

Class CellValue

java.lang.Object

org.apache.poi.ss.usermodel.CellValue

public final class CellValue
extends java.lang.Object

Mimics the 'data view' of a cell. This allows formula evaluator to return a CellValue instead of precasting the value to String or Number or boolean type.

Field Summary

Fields

Modifier and Type	Field	Description
static CellValue	FALSE
static CellValue	TRUE

Constructor Summary

Constructors

Constructor	Description
CellValue(double numberValue)
CellValue(java.lang.String stringValue)

Method Summary

Modifier and Type	Method	Description
java.lang.String	formatAsString()
boolean	getBooleanValue()
CellType	getCellType()	Return the cell type.
CellType	getCellTypeEnum()	Deprecated. use getCellType instead
static CellValue	getError(int errorCode)
byte	getErrorValue()
double	getNumberValue()
java.lang.String	getStringValue()
java.lang.String	toString()
static CellValue	valueOf(boolean booleanValue)

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

TRUE

public static final CellValue TRUE

FALSE

public static final CellValue FALSE

Constructor Detail

CellValue

public CellValue(double numberValue)

CellValue

public CellValue(java.lang.String stringValue)

Method Detail

valueOf

public static CellValue valueOf(boolean booleanValue)

getError

public static CellValue getError(int errorCode)

getBooleanValue

public boolean getBooleanValue()

Returns:

Returns the booleanValue.

getNumberValue

public double getNumberValue()

Returns:

Returns the numberValue.

getStringValue

public java.lang.String getStringValue()

Returns:

Returns the stringValue.

getCellTypeEnum

@Deprecated
@Removal(version="4.2")
public CellType getCellTypeEnum()

Deprecated.

use getCellType instead

Return the cell type.

Returns:

the cell type

Since:

POI 3.15

getCellType

public CellType getCellType()

Return the cell type.

Returns:

the cell type

getErrorValue

public byte getErrorValue()

Returns:

Returns the errorValue.

toString

public java.lang.String toString()

Overrides:

toString in class java.lang.Object

formatAsString

public java.lang.String formatAsString()