Excel.Interfaces.WorksheetProtectionData interface
An interface describing the data returned by calling worksheetProtection.toJSON()
.
Properties
allow |
Specifies the |
can |
Specifies if protection can be paused for this worksheet. |
is |
Specifies if the sheet is password protected. |
is |
Specifies if worksheet protection is paused. |
options | Specifies the protection options for the worksheet. |
protected | Specifies if the worksheet is protected. |
saved |
Specifies the protection options saved in the worksheet. This will return the same |
Property Details
allowEditRanges
Specifies the AllowEditRangeCollection
object found in this worksheet. This is a collection of AllowEditRange
objects, which work with worksheet protection properties. When worksheet protection is enabled, an AllowEditRange
object can be used to allow editing of a specific range, while maintaining protection on the rest of the worksheet.
allowEditRanges?: Excel.Interfaces.AllowEditRangeData[];
Property Value
Remarks
canPauseProtection
Specifies if protection can be paused for this worksheet.
canPauseProtection?: boolean;
Property Value
boolean
Remarks
isPasswordProtected
Specifies if the sheet is password protected.
isPasswordProtected?: boolean;
Property Value
boolean
Remarks
isPaused
Specifies if worksheet protection is paused.
isPaused?: boolean;
Property Value
boolean
Remarks
options
Specifies the protection options for the worksheet.
options?: Excel.WorksheetProtectionOptions;
Property Value
Remarks
protected
Specifies if the worksheet is protected.
protected?: boolean;
Property Value
boolean
Remarks
savedOptions
Specifies the protection options saved in the worksheet. This will return the same WorksheetProtectionOptions
object regardless of the worksheet protection state.
savedOptions?: Excel.WorksheetProtectionOptions;
Property Value
Remarks
Office Add-ins