Edit

Share via

Excel.ReferenceCellValue interface

  • Reference
Package:
excel

Represents a reference into referencedValues. One scenario for using this reference is to avoid duplicating cell value objects (such as an EntityCellValue). Define a cell value object once in referencedValues, and then refer to that cell value from many places by using a ReferenceCellValue where the duplicated value would have appeared.

Remarks

[ API set: ExcelApi 1.16 ]

Properties

basicType

Represents the value that would be returned by Range.valueTypes for a cell with this value.
basicValue

Represents the value that would be returned by Range.values for a cell with this value.
reference

Represents the index into the referencedValues properties of cell values such as EntityCellValue and ArrayCellValue.
type

Represents the type of this cell value.

Property Details

basicType

Represents the value that would be returned by Range.valueTypes for a cell with this value.

basicType?: RangeValueType | "Boolean" | "Double" | "Error" | "Empty" | "String";

Property Value

Excel.RangeValueType | "Boolean" | "Double" | "Error" | "Empty" | "String"

Remarks

[ API set: ExcelApi 1.16 ]

basicValue

Represents the value that would be returned by Range.values for a cell with this value.

basicValue?: boolean | number | string;

Property Value

boolean | number | string

Remarks

[ API set: ExcelApi 1.16 ]

reference

Represents the index into the referencedValues properties of cell values such as EntityCellValue and ArrayCellValue.

reference: number;

Property Value

number

Remarks

[ API set: ExcelApi 1.16 ]

type

Represents the type of this cell value.

type: CellValueType.reference | "Reference";

Property Value

reference | "Reference"

Remarks

[ API set: ExcelApi 1.16 ]