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]