{/* Do not edit this file. It is automatically generated by API Documenter. */}


## SheetProtectProperties

Specifies the properties to be allowed when applying Excel sheet protection.

**Signature:**

```typescript
export interface SheetProtectProperties
```

## Remarks

Enter "0" if allowed. Enter "1" if not allowed.

If the property is not specified, it is set to the Excel default value.

The lock/hide format properties of a cell are [DataColumn.cellProps](/refs/Interface/DataColumn#cellprotectprops){/* */} or [ColumnStyleObject.cellProtectProps](/refs/Interface/ColumnStyleObject#cellprotectprops){/* */ } is used.

## Example


```js
gridView.exportGrid({
     type: "excel",
     target: "local",
     sheetProtect: true;
     protectProperties: {
         selectLockedCells: "0",
         selectUnlockedCells: "0"
     },
     protectPassword: "12345678";
})
```

## Properties

| Property | Type | Description |
| --- | --- | --- |
| [autoFilter](/refs/Interface/SheetProtectProperties#autofilter) | string | Use AutoFilter |
| [deleteColumns](/refs/Interface/SheetProtectProperties#deletecolumns) | string | Delete Column |
| [deleteRows](/refs/Interface/SheetProtectProperties#deleterows) | string | Delete row |
| [formatCells](/refs/Interface/SheetProtectProperties#formatcells) | string | Cell Format |
| [formatColumns](/refs/Interface/SheetProtectProperties#formatcolumns) | string | Column Format |
| [formatRows](/refs/Interface/SheetProtectProperties#formatrows) | string | Row Format |
| [insertColumns](/refs/Interface/SheetProtectProperties#insertcolumns) | string | Insert Column |
| [insertHyperlinks](/refs/Interface/SheetProtectProperties#inserthyperlinks) | string | Insert hyperlink |
| [insertRows](/refs/Interface/SheetProtectProperties#insertrows) | string | Insert row |
| [objects](/refs/Interface/SheetProtectProperties#objects) | string | Edit Object |
| [pivotTables](/refs/Interface/SheetProtectProperties#pivottables) | string | Using PivotTable Reports |
| [scenarios](/refs/Interface/SheetProtectProperties#scenarios) | string | Edit scenario |
| [selectLockedCells](/refs/Interface/SheetProtectProperties#selectlockedcells) | string | Select locked cells |
| [selectUnlockedCells](/refs/Interface/SheetProtectProperties#selectunlockedcells) | string | Select unlocked cells |
| [sort](/refs/Interface/SheetProtectProperties#sort) | string | sort |

## Properties Desc

### autoFilter

Use automatic filters

`Type` - string

<hr/>

### deleteColumns

Delete column

`Type` - string

<hr/>

### deleteRows

Delete row

`Type` - string

<hr/>

### formatCells

cell format

`Type` - string

<hr/>

### formatColumns

column format

`Type` - string

<hr/>

### formatRows

Row Format

`Type` - string

<hr/>

### insertColumns

Insert column

`Type` - string

<hr/>

### insertHyperlinks

Insert hyperlink

`Type` - string

<hr/>

### insertRows

Insert row

`Type` - string

<hr/>

### objects

Edit object

`Type` - string

<hr/>

### pivotTables

Use PivotTable reports

`Type` - string

<hr/>

### scenarios

Edit scenario

`Type` - string

<hr/>

### selectLockedCells

Select locked cells

`Type` - string

<hr/>

### selectUnlockedCells

Select unlocked cells

`Type` - string

<hr/>

### sort

Sort

`Type` - string

<hr/>