Edit

Share via

Excel.WorksheetProtectionOptions interface

  • Reference
Package:
excel

Represents the options in sheet protection.

Remarks

[ API set: ExcelApi 1.2 ]

Properties

allowAutoFilter

Represents the worksheet protection option allowing use of the AutoFilter feature.
allowDeleteColumns

Represents the worksheet protection option allowing deleting of columns.
allowDeleteRows

Represents the worksheet protection option allowing deleting of rows.
allowFormatCells

Represents the worksheet protection option allowing formatting of cells.
allowFormatColumns

Represents the worksheet protection option allowing formatting of columns.
allowFormatRows

Represents the worksheet protection option allowing formatting of rows.
allowInsertColumns

Represents the worksheet protection option allowing inserting of columns.
allowInsertHyperlinks

Represents the worksheet protection option allowing inserting of hyperlinks.
allowInsertRows

Represents the worksheet protection option allowing inserting of rows.
allowPivotTables

Represents the worksheet protection option allowing use of the PivotTable feature.
allowSort

Represents the worksheet protection option allowing use of the sort feature.

Property Details

allowAutoFilter

Represents the worksheet protection option allowing use of the AutoFilter feature.

allowAutoFilter?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.2 ]

allowDeleteColumns

Represents the worksheet protection option allowing deleting of columns.

allowDeleteColumns?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.2 ]

allowDeleteRows

Represents the worksheet protection option allowing deleting of rows.

allowDeleteRows?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.2 ]

allowFormatCells

Represents the worksheet protection option allowing formatting of cells.

allowFormatCells?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.2 ]

allowFormatColumns

Represents the worksheet protection option allowing formatting of columns.

allowFormatColumns?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.2 ]

allowFormatRows

Represents the worksheet protection option allowing formatting of rows.

allowFormatRows?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.2 ]

allowInsertColumns

Represents the worksheet protection option allowing inserting of columns.

allowInsertColumns?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.2 ]

Represents the worksheet protection option allowing inserting of hyperlinks.

allowInsertHyperlinks?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.2 ]

allowInsertRows

Represents the worksheet protection option allowing inserting of rows.

allowInsertRows?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.2 ]

allowPivotTables

Represents the worksheet protection option allowing use of the PivotTable feature.

allowPivotTables?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.2 ]

allowSort

Represents the worksheet protection option allowing use of the sort feature.

allowSort?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.2 ]