Skip to main content
Module

x/flat/src/xlsx-types.ts>ProtectInfo

A collection of postprocessing utilities for flat
Go to Latest
interface ProtectInfo
import { type ProtectInfo } from "https://deno.land/x/flat@0.0.11/src/xlsx-types.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
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