---
url: /typescript-api/interfaces/JsSheetProtectionConfig.md
---
[@sheetkit/node](../globals.md) / JsSheetProtectionConfig

# Interface: JsSheetProtectionConfig

Defined in: [packages/sheetkit/binding.d.ts:1096](https://github.com/Nebu1eto/sheetkit/blob/aedd8c0c4ec37185210740b875ec6bb714d323d4/packages/sheetkit/binding.d.ts#L1096)

Configuration for sheet protection.

## Properties

### autoFilter?

> `optional` **autoFilter?**: `boolean`

Defined in: [packages/sheetkit/binding.d.ts:1122](https://github.com/Nebu1eto/sheetkit/blob/aedd8c0c4ec37185210740b875ec6bb714d323d4/packages/sheetkit/binding.d.ts#L1122)

Allow using auto-filter.

***

### deleteColumns?

> `optional` **deleteColumns?**: `boolean`

Defined in: [packages/sheetkit/binding.d.ts:1116](https://github.com/Nebu1eto/sheetkit/blob/aedd8c0c4ec37185210740b875ec6bb714d323d4/packages/sheetkit/binding.d.ts#L1116)

Allow deleting columns.

***

### deleteRows?

> `optional` **deleteRows?**: `boolean`

Defined in: [packages/sheetkit/binding.d.ts:1118](https://github.com/Nebu1eto/sheetkit/blob/aedd8c0c4ec37185210740b875ec6bb714d323d4/packages/sheetkit/binding.d.ts#L1118)

Allow deleting rows.

***

### formatCells?

> `optional` **formatCells?**: `boolean`

Defined in: [packages/sheetkit/binding.d.ts:1104](https://github.com/Nebu1eto/sheetkit/blob/aedd8c0c4ec37185210740b875ec6bb714d323d4/packages/sheetkit/binding.d.ts#L1104)

Allow formatting cells.

***

### formatColumns?

> `optional` **formatColumns?**: `boolean`

Defined in: [packages/sheetkit/binding.d.ts:1106](https://github.com/Nebu1eto/sheetkit/blob/aedd8c0c4ec37185210740b875ec6bb714d323d4/packages/sheetkit/binding.d.ts#L1106)

Allow formatting columns.

***

### formatRows?

> `optional` **formatRows?**: `boolean`

Defined in: [packages/sheetkit/binding.d.ts:1108](https://github.com/Nebu1eto/sheetkit/blob/aedd8c0c4ec37185210740b875ec6bb714d323d4/packages/sheetkit/binding.d.ts#L1108)

Allow formatting rows.

***

### insertColumns?

> `optional` **insertColumns?**: `boolean`

Defined in: [packages/sheetkit/binding.d.ts:1110](https://github.com/Nebu1eto/sheetkit/blob/aedd8c0c4ec37185210740b875ec6bb714d323d4/packages/sheetkit/binding.d.ts#L1110)

Allow inserting columns.

***

### insertHyperlinks?

> `optional` **insertHyperlinks?**: `boolean`

Defined in: [packages/sheetkit/binding.d.ts:1114](https://github.com/Nebu1eto/sheetkit/blob/aedd8c0c4ec37185210740b875ec6bb714d323d4/packages/sheetkit/binding.d.ts#L1114)

Allow inserting hyperlinks.

***

### insertRows?

> `optional` **insertRows?**: `boolean`

Defined in: [packages/sheetkit/binding.d.ts:1112](https://github.com/Nebu1eto/sheetkit/blob/aedd8c0c4ec37185210740b875ec6bb714d323d4/packages/sheetkit/binding.d.ts#L1112)

Allow inserting rows.

***

### password?

> `optional` **password?**: `string`

Defined in: [packages/sheetkit/binding.d.ts:1098](https://github.com/Nebu1eto/sheetkit/blob/aedd8c0c4ec37185210740b875ec6bb714d323d4/packages/sheetkit/binding.d.ts#L1098)

Optional password (hashed with legacy Excel algorithm).

***

### pivotTables?

> `optional` **pivotTables?**: `boolean`

Defined in: [packages/sheetkit/binding.d.ts:1124](https://github.com/Nebu1eto/sheetkit/blob/aedd8c0c4ec37185210740b875ec6bb714d323d4/packages/sheetkit/binding.d.ts#L1124)

Allow using pivot tables.

***

### selectLockedCells?

> `optional` **selectLockedCells?**: `boolean`

Defined in: [packages/sheetkit/binding.d.ts:1100](https://github.com/Nebu1eto/sheetkit/blob/aedd8c0c4ec37185210740b875ec6bb714d323d4/packages/sheetkit/binding.d.ts#L1100)

Allow selecting locked cells.

***

### selectUnlockedCells?

> `optional` **selectUnlockedCells?**: `boolean`

Defined in: [packages/sheetkit/binding.d.ts:1102](https://github.com/Nebu1eto/sheetkit/blob/aedd8c0c4ec37185210740b875ec6bb714d323d4/packages/sheetkit/binding.d.ts#L1102)

Allow selecting unlocked cells.

***

### sort?

> `optional` **sort?**: `boolean`

Defined in: [packages/sheetkit/binding.d.ts:1120](https://github.com/Nebu1eto/sheetkit/blob/aedd8c0c4ec37185210740b875ec6bb714d323d4/packages/sheetkit/binding.d.ts#L1120)

Allow sorting.
