fastpyxl.worksheet.protection module

class fastpyxl.worksheet.protection.SheetProtection(sheet=False, objects=False, scenarios=False, formatCells=True, formatRows=True, formatColumns=True, insertColumns=True, insertRows=True, insertHyperlinks=True, deleteColumns=True, deleteRows=True, selectLockedCells=False, selectUnlockedCells=False, sort=True, autoFilter=True, pivotTables=True, password=None, algorithmName=None, saltValue=None, spinCount=None, hashValue=None)[source]

Bases: Serialisable, _Protected

Information about protection of various aspects of a sheet. True values mean that protection for the object or action is active This is the default when protection is active, ie. users cannot do something

algorithmName: str | None
autoFilter: bool
deleteColumns: bool
deleteRows: bool
disable()[source]
enable()[source]
property enabled
formatCells: bool
formatColumns: bool
formatRows: bool
hashValue: str | None
insertColumns: bool
insertRows: bool
objects: bool
pivotTables: bool
saltValue: str | None
scenarios: bool
selectLockedCells: bool
selectUnlockedCells: bool
set_password(value='', already_hashed=False)[source]

Set a password on this sheet.

sheet: bool
sort: bool
spinCount: int | None
tagname = 'sheetProtection'