Excel.Interfaces.WorksheetCustomPropertyCollectionLoadOptions interface

Contains the collection of worksheet-level custom property.

Remarks

[ API set: ExcelApi 1.12 ]

Properties

$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).

key

For EACH ITEM in the collection: Gets the key of the custom property. Custom property keys are case-insensitive. The key is limited to 255 characters (larger values will cause an InvalidArgument error to be thrown.)

value

For EACH ITEM in the collection: Gets or sets the value of the custom property.

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

key

For EACH ITEM in the collection: Gets the key of the custom property. Custom property keys are case-insensitive. The key is limited to 255 characters (larger values will cause an InvalidArgument error to be thrown.)

key?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.12 ]

value

For EACH ITEM in the collection: Gets or sets the value of the custom property.

value?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.12 ]