WorksheetProtectionOptions Object (JavaScript API for Excel)

Represents the options in sheet protection.

Properties

Property Type Description Req. Set
allowAutoFilter bool Represents the worksheet protection option of allowing using auto filter feature. 1.2
allowDeleteColumns bool Represents the worksheet protection option of allowing deleting columns. 1.2
allowDeleteRows bool Represents the worksheet protection option of allowing deleting rows. 1.2
allowFormatCells bool Represents the worksheet protection option of allowing formatting cells. 1.2
allowFormatColumns bool Represents the worksheet protection option of allowing formatting columns. 1.2
allowFormatRows bool Represents the worksheet protection option of allowing formatting rows. 1.2
allowInsertColumns bool Represents the worksheet protection option of allowing inserting columns. 1.2
allowInsertHyperlinks bool Represents the worksheet protection option of allowing inserting hyperlinks. 1.2
allowInsertRows bool Represents the worksheet protection option of allowing inserting rows. 1.2
allowPivotTables bool Represents the worksheet protection option of allowing using PivotTable feature. 1.2
allowSort bool Represents the worksheet protection option of allowing using sort feature. 1.2

See property access examples.

Relationships

None

Methods

None

ion Req. Set load(param: object) void Fills the proxy object created in JavaScript layer with property and object values specified in the parameter. 1.1

Method Details

load(param: object)

Fills the proxy object created in JavaScript layer with property and object values specified in the parameter.

Syntax

object.load(param);

Parameters

Parameter Type Description  
param object Optional. Accepts parameter and relationship names as delimited string or an array. Or, provide loadOption object.  

Returns

void