Excel.Interfaces.NamedItemArrayValuesLoadOptions interface
Represents an object containing values and types of a named item.
Remarks
Properties
$all | Specifying |
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
$all
Specifying $all
for the load options loads all the scalar properties (such as Range.address
) but not the navigational properties (such as Range.format.fill.color
).
$all?: boolean;
Property Value
boolean
types
Represents the types for each item in the named item array
types?: boolean;
Property Value
boolean
Remarks
values
Represents the values of each item in the named item array.
values?: boolean;
Property Value
boolean
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?: boolean;
Property Value
boolean
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?: boolean;
Property Value
boolean
Remarks
Office Add-ins