Excel.Interfaces.SettingCollectionLoadOptions interface
Represents a collection of key-value pair setting objects that are part of the workbook. The scope is limited to per file and add-in (task-pane or content) combination.
Remarks
Properties
$all | Specifying |
key | For EACH ITEM in the collection: The key that represents the ID of the setting. |
value | For EACH ITEM in the collection: Represents the value stored for this setting. |
Property Details
$all
Specifying $all
for the LoadOptions loads all the scalar properties (e.g.: Range.address
) but not the navigational properties (e.g.: Range.format.fill.color
).
$all?: boolean;
Property Value
boolean
key
For EACH ITEM in the collection: The key that represents the ID of the setting.
key?: boolean;
Property Value
boolean
Remarks
value
For EACH ITEM in the collection: Represents the value stored for this setting.
value?: boolean;
Property Value
boolean
Remarks
Office Add-ins
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for