openpyxl.worksheet.protection module
- class openpyxl.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
Values must be of type <class ‘str’>
- autoFilter
Values must be of type <class ‘bool’>
- deleteColumns
Values must be of type <class ‘bool’>
- deleteRows
Values must be of type <class ‘bool’>
- enabled
Values must be of type <class ‘bool’>
- formatCells
Values must be of type <class ‘bool’>
- formatColumns
Values must be of type <class ‘bool’>
- formatRows
Values must be of type <class ‘bool’>
- hashValue
- insertColumns
Values must be of type <class ‘bool’>
- insertHyperlinks
Values must be of type <class ‘bool’>
- insertRows
Values must be of type <class ‘bool’>
- objects
Values must be of type <class ‘bool’>
- pivotTables
Values must be of type <class ‘bool’>
- saltValue
- scenarios
Values must be of type <class ‘bool’>
- selectLockedCells
Values must be of type <class ‘bool’>
- selectUnlockedCells
Values must be of type <class ‘bool’>
- sheet
Values must be of type <class ‘bool’>
- sort
Values must be of type <class ‘bool’>
- spinCount
Values must be of type <class ‘int’>
- tagname = 'sheetProtection'