Excel.Interfaces.NamedItemArrayValuesData interface

An interface describing the data returned by calling namedItemArrayValues.toJSON().

Properties

types

Represents the types for each item in the named item array

values

Represents the values of each item in the named item array.

valuesAsJson

A JSON representation of the values in this named item array. Unlike NamedItemArrayValues.values, NamedItemArrayValues.valuesAsJson supports all data types which can be in a cell. Examples include formatted number values and web images, in addition to the standard boolean, number, and string values. Data returned from this API always aligns with the en-US locale. To retrieve data in the user's display locale, use NamedItemArrayValues.valuesAsJsonLocal.

valuesAsJsonLocal

A JSON representation of the values in this named item array. Unlike NamedItemArrayValues.values, NamedItemArrayValues.valuesAsJsonLocal supports all data types which can be in a cell. Examples include formatted number values and web images, in addition to the standard boolean, number, and string values. Data returned from this API always aligns with the user's display locale. To retrieve data independent of locale, use NamedItemArrayValues.valuesAsJson.

Property Details

types

Represents the types for each item in the named item array

types?: Excel.RangeValueType[][];

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

values

Represents the values of each item in the named item array.

values?: any[][];

Property Value

any[][]

Remarks

[ API set: ExcelApi 1.7 ]

valuesAsJson

A JSON representation of the values in this named item array. Unlike NamedItemArrayValues.values, NamedItemArrayValues.valuesAsJson supports all data types which can be in a cell. Examples include formatted number values and web images, in addition to the standard boolean, number, and string values. Data returned from this API always aligns with the en-US locale. To retrieve data in the user's display locale, use NamedItemArrayValues.valuesAsJsonLocal.

valuesAsJson?: CellValue[][];

Property Value

Remarks

[ API set: ExcelApi 1.16 ]

valuesAsJsonLocal

A JSON representation of the values in this named item array. Unlike NamedItemArrayValues.values, NamedItemArrayValues.valuesAsJsonLocal supports all data types which can be in a cell. Examples include formatted number values and web images, in addition to the standard boolean, number, and string values. Data returned from this API always aligns with the user's display locale. To retrieve data independent of locale, use NamedItemArrayValues.valuesAsJson.

valuesAsJsonLocal?: CellValue[][];

Property Value

Remarks

[ API set: ExcelApi 1.16 ]