workbookWorksheetProtectionOptions resource type

Namespace: microsoft.graph

Important

APIs under the /beta version in Microsoft Graph are subject to change. Use of these APIs in production applications is not supported. To determine whether an API is available in v1.0, use the Version selector.

Represents the options in sheet protection.

Properties

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

JSON representation

The following JSON representation shows the resource type.

{
  "allowAutoFilter": true,
  "allowDeleteColumns": true,
  "allowDeleteRows": true,
  "allowFormatCells": true,
  "allowFormatColumns": true,
  "allowFormatRows": true,
  "allowInsertColumns": true,
  "allowInsertHyperlinks": true,
  "allowInsertRows": true,
  "allowPivotTables": true,
  "allowSort": true
}