R: SheetProtection

SheetProtection {xlcharts}

R Documentation

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

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

## Not run: 
SheetProtection()

## End(Not run)

[Package xlcharts version 0.0.2 Index]