SheetProtection

Source code

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,
  ...
)

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

Value

An openpyxl Python object.

Examples

library("xlcharts")

SheetProtection()