SheetProtection: SheetProtection

Description

Information about protection of various aspects of a sheet. TRUE values

https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.protection.html

Usage

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 = NULL,
  algorithmName = NULL,
  saltValue = NULL,
  spinCount = NULL,
  hashValue = NULL,
  ...
)

Value

An openpyxl Python object.

Arguments

sheet: sheet
objects: objects
scenarios: scenarios
formatCells: formatCells
formatRows: formatRows
formatColumns: formatColumns
insertColumns: insertColumns
insertRows: insertRows
insertHyperlinks: insertHyperlinks
deleteColumns: deleteColumns
deleteRows: deleteRows
selectLockedCells: selectLockedCells
selectUnlockedCells: selectUnlockedCells
sort: sort
autoFilter: autoFilter
pivotTables: pivotTables
password: password
algorithmName: algorithmName
saltValue: saltValue
spinCount: spinCount
hashValue: hashValue
...: Additional arguments, i.e. kwargs.

Details

mean that protection for the object or action is active This is the **default** when protection is active, ie. users cannot do something

Examples

Run this code

if (FALSE) {
SheetProtection()
}

Run the code above in your browser using DataLab