CellValue

CellValue class

Represents the cell value and corresponding type.

class CellValue;

Constructors

Constructor	Description
constructor()	Default Constructor.

Properties

Property	Type	Description
type	CellValueType	Gets/sets the type of cell value.
value	Object	Gets/sets the cell value.

Methods

Method	Description
getType()	@deprecated. Please use the ’type’ property instead. Gets/sets the type of cell value.
setType(CellValueType)	@deprecated. Please use the ’type’ property instead. Gets/sets the type of cell value.
getValue()	@deprecated. Please use the ‘value’ property instead. Gets/sets the cell value.
setValue(Object)	@deprecated. Please use the ‘value’ property instead. Gets/sets the cell value.
isNull()	Checks whether the implementation object is null.

constructor()

Default Constructor.

constructor();

type

Gets/sets the type of cell value.

type : CellValueType;

value

Gets/sets the cell value.

value : Object;

Remarks

The value must be of the correct type of object corresponding to the Type: Type Value CellValueType.IsNull null, any other object will be ignored CellValueType.IsNumeric double CellValueType.IsDateTime DateTime CellValueType.IsString string CellValueType.IsBool bool CellValueType.IsError error string such as “#VALUE!”, “#NAME?”, … </list

getType()

@deprecated. Please use the ’type’ property instead. Gets/sets the type of cell value.

getType() : CellValueType;

Returns

CellValueType

setType(CellValueType)

@deprecated. Please use the ’type’ property instead. Gets/sets the type of cell value.

setType(value: CellValueType) : void;

Parameters:

Parameter	Type	Description
value	CellValueType	The value to set.

getValue()

@deprecated. Please use the ‘value’ property instead. Gets/sets the cell value.

getValue() : Object;

Remarks

The value must be of the correct type of object corresponding to the Type: Type Value CellValueType.IsNull null, any other object will be ignored CellValueType.IsNumeric double CellValueType.IsDateTime DateTime CellValueType.IsString string CellValueType.IsBool bool CellValueType.IsError error string such as “#VALUE!”, “#NAME?”, … </list

setValue(Object)

@deprecated. Please use the ‘value’ property instead. Gets/sets the cell value.

setValue(value: Object) : void;

Parameters:

Parameter	Type	Description
value	Object	The value to set.

Remarks

The value must be of the correct type of object corresponding to the Type: Type Value CellValueType.IsNull null, any other object will be ignored CellValueType.IsNumeric double CellValueType.IsDateTime DateTime CellValueType.IsString string CellValueType.IsBool bool CellValueType.IsError error string such as “#VALUE!”, “#NAME?”, … </list

isNull()

Checks whether the implementation object is null.

isNull() : boolean;