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.

TRUE

public static final CellValue TRUE

FALSE

public static final CellValue FALSE

CellValue

public CellValue(double numberValue)

CellValue

public CellValue(java.lang.String stringValue)

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

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

Return the cell type.

Returns:

the cell type

Since:

POI 3.15 Will be renamed to getCellTypeEnum() when we make the CellType enum transition in POI 4.0. See bug 59791.

getCellType

@Deprecated
public int getCellType()

Deprecated. POI 3.15. Use getCellTypeEnum() instead.

Return the cell type. Will return CellType in version 4.0 of POI. For forwards compatibility, do not hard-code cell type literals in your code.

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()