SheetProtection

Overview

SheetProtection is a class in Aspose.Cells FOSS for Python.

Represents sheet protection settings.

This class declares 1 method for SheetProtection objects in Python programs. Available methods include: __init__. Public members are accessible to any Python application after installing the Aspose.Cells FOSS for Python package. Properties: algorithm_name, auto_filter, delete_columns, delete_rows, format_cells, format_columns, and 16 more.

Properties

NameTypeAccessDescription
sheet-Read/WriteWhether to protect sheet.
objects-Read/WriteWhether to protect objects.
scenarios-Read/WriteWhether to protect scenarios.
format_cells-Read/WriteWhether to allow formatting cells.
format_columns-Read/WriteWhether to allow formatting columns.
format_rows-Read/WriteWhether to allow formatting rows.
insert_columns-Read/WriteWhether to allow inserting columns.
insert_rows-Read/WriteWhether to allow inserting rows.
insert_hyperlinks-Read/WriteWhether to allow inserting hyperlinks.
delete_columns-Read/WriteWhether to allow deleting columns.
delete_rows-Read/WriteWhether to allow deleting rows.
select_locked_cells-Read/WriteWhether to allow selecting locked cells.
sort-Read/WriteWhether to allow sorting.
auto_filter-Read/WriteWhether to allow using autoFilter.
pivot_tables-Read/WriteWhether to allow using pivot tables.
select_unlocked_cells-Read/WriteWhether to allow selecting unlocked cells.
password-Read/WriteProtection password (hashed).
algorithm_name-Read/WriteHash algorithm name (for modern protection).
hash_value-Read/WritePassword hash (base64).
salt_value-Read/WriteSalt for hashing (base64).
spin_count-Read/WriteNumber of hash iterations.
is_protected-ReadReturns True if sheet protection is enabled.

Methods

SignatureDescription
__init__()Calls init on this SheetProtection instance.

See Also

 English