Edit

Share via

Excel.ArrayCellValue interface

  • Reference
Package:
excel

Represents a 2D array of cell values.

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. When accessed through a valuesAsJson property, this string value aligns with the en-US locale. When accessed through a valuesAsJsonLocal property, this string value aligns with the user's display locale.
elements

Represents the elements of the array. May not directly contain an ArrayCellValue.
referencedValues

Represents the cell values which are referenced within ArrayCellValue.elements.
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.error | "Error";

Property Value

error | "Error"

Remarks

[ API set: ExcelApi 1.16 ]

basicValue

Represents the value that would be returned by Range.values for a cell with this value. When accessed through a valuesAsJson property, this string value aligns with the en-US locale. When accessed through a valuesAsJsonLocal property, this string value aligns with the user's display locale.

basicValue?: "#VALUE!" | string;

Property Value

"#VALUE!" | string

Remarks

[ API set: ExcelApi 1.16 ]

elements

Represents the elements of the array. May not directly contain an ArrayCellValue.

elements: CellValue[][];

Property Value

Excel.CellValue[][]

Remarks

[ API set: ExcelApi 1.16 ]

referencedValues

Represents the cell values which are referenced within ArrayCellValue.elements.

referencedValues?: ReferencedValue[];

Property Value

Excel.ReferencedValue[]

Remarks

[ API set: ExcelApi 1.16 ]

type

Represents the type of this cell value.

type: CellValueType.array | ReferenceValueType.array | "Array";

Property Value

array | array | "Array"

Remarks

[ API set: ExcelApi 1.16 ]