SheetProtection

Overview

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

Represents sheet protection settings.

This class provides 1 method for working with SheetProtection objects in Python programs. Available methods include: __init__. All 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__()

See Also