ProtectInfo | /types/index.d.ts | sheetjs@v0.18.3

interface ProtectInfo

import { type ProtectInfo } from "https://deno.land/x/sheetjs@v0.18.3/types/index.d.ts";

Write sheet protection properties.

Properties

optional

password: string

The password for formats that support password-protected sheets (XLSX/XLSB/XLS). The writer uses the XOR obfuscation method.

optional

selectLockedCells: boolean

Select locked cells

optional

selectUnlockedCells: boolean

Select unlocked cells

optional

formatCells: boolean

Format cells

optional

formatColumns: boolean

Format columns

optional

formatRows: boolean

Format rows

optional

insertColumns: boolean

Insert columns

optional

insertRows: boolean

Insert rows

optional

insertHyperlinks: boolean

Insert hyperlinks

optional

deleteColumns: boolean

Delete columns

optional

deleteRows: boolean

Delete rows

optional

sort: boolean

Sort

optional

autoFilter: boolean

Filter

optional

pivotTables: boolean

Use PivotTable reports

optional

objects: boolean

Edit objects

optional

scenarios: boolean

Edit scenarios