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;