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. |
values |
A JSON representation of the values in this named item array. Unlike |
values |
A JSON representation of the values in this named item array. Unlike |
Property Details
types
Represents the types for each item in the named item array
types?: Excel.RangeValueType[][];
Property Value
Remarks
values
Represents the values of each item in the named item array.
values?: any[][];
Property Value
any[][]
Remarks
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
Excel.CellValue[][]
Remarks
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
Excel.CellValue[][]
Remarks
Office Add-ins