xlsx.ProtectInfo | /mod.ts | flat@0.0.15

interface xlsx.ProtectInfo

import { type xlsx } from "https://deno.land/x/flat@0.0.15/mod.ts";
const { ProtectInfo } = xlsx;

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