WorksheetProtectionModel

Overview

WorksheetProtectionModel is a class in Aspose.Cells FOSS for Java.

Represents the protection model for a worksheet in an Excel file.

This class provides 44 methods for working with WorksheetProtectionModel objects in Java programs. Available methods include: clear, getAlgorithmName, getAutoFilter, getDeleteColumns, getDeleteRows, getFormatCells, getFormatColumns, getFormatRows, getHashValue, getInsertColumns, getInsertHyperlinks, getInsertRows, and 32 additional methods. All exported members are accessible to any Java application after installing the Aspose.Cells FOSS for Java package. Properties: algorithmName, autoFilter, deleteColumns, deleteRows, formatCells, formatColumns, and 15 more.

Description

WorksheetProtectionModel is a class in the Aspose.Cells FOSS library for Java that exposes 44 methods and 21 properties for programmatic use.

Core capabilities include: boolean; boolean; boolean. These operations enable developers to integrate worksheetprotectionmodel functionality directly into Java applications.

The class also provides the isProtected property (returns the protected), the objects property (returns the objects), the scenarios property (returns the scenarios).

Properties

Name	Type	Access	Description
`isProtected`	`boolean`	Read	Returns the protected.
`objects`	`boolean`	Read	Returns the objects.
`scenarios`	`boolean`	Read	Returns the scenarios.
`formatCells`	`boolean`	Read	Returns the format cells.
`formatColumns`	`boolean`	Read	Returns the format columns.
`formatRows`	`boolean`	Read	Returns the format rows.
`insertColumns`	`boolean`	Read	Returns the insert columns.
`insertRows`	`boolean`	Read	Returns the insert rows.
`insertHyperlinks`	`boolean`	Read	Returns the insert hyperlinks.
`deleteColumns`	`boolean`	Read	Returns the delete columns.
`deleteRows`	`boolean`	Read	Returns the delete rows.
`selectLockedCells`	`boolean`	Read	Returns the select locked cells.
`sort`	`boolean`	Read	Returns the sort.
`autoFilter`	`boolean`	Read	Returns the auto filter.
`pivotTables`	`boolean`	Read	Returns the pivot tables.
`selectUnlockedCells`	`boolean`	Read	Returns the select unlocked cells.
`passwordHash`	`String`	Read	Returns the password hash.
`algorithmName`	`String`	Read	Returns the algorithm name.
`hashValue`	`String`	Read	Returns the hash value.
`saltValue`	`String`	Read	Returns the salt value.
`spinCount`	`String`	Read	Returns the spin count.

Methods

Signature	Description
`getIsProtected()` → `boolean`	Returns the protected.
`setIsProtected(isProtected: boolean)`	Sets the protected.
`getObjects()` → `boolean`	Returns the objects.
`setObjects(objects: boolean)`	Sets the objects.
`getScenarios()` → `boolean`	Returns the scenarios.
`setScenarios(scenarios: boolean)`	Sets the scenarios.
`getFormatCells()` → `boolean`	Returns the format cells.
`setFormatCells(formatCells: boolean)`	Sets the format cells.
`getFormatColumns()` → `boolean`	Returns the format columns.
`setFormatColumns(formatColumns: boolean)`	Sets the format columns.
`getFormatRows()` → `boolean`	Returns the format rows.
`setFormatRows(formatRows: boolean)`	Sets the format rows.
`getInsertColumns()` → `boolean`	Returns the insert columns.
`setInsertColumns(insertColumns: boolean)`	Sets the insert columns.
`getInsertRows()` → `boolean`	Returns the insert rows.
`setInsertRows(insertRows: boolean)`	Sets the insert rows.
`getInsertHyperlinks()` → `boolean`	Returns the insert hyperlinks.
`setInsertHyperlinks(insertHyperlinks: boolean)`	Sets the insert hyperlinks.
`getDeleteColumns()` → `boolean`	Returns the delete columns.
`setDeleteColumns(deleteColumns: boolean)`	Sets the delete columns.
`getDeleteRows()` → `boolean`	Returns the delete rows.
`setDeleteRows(deleteRows: boolean)`	Sets the delete rows.
`getSelectLockedCells()` → `boolean`	Returns the select locked cells.
`setSelectLockedCells(selectLockedCells: boolean)`	Sets the select locked cells.
`getSort()` → `boolean`	Returns the sort.
`setSort(sort: boolean)`	Sets the sort.
`getAutoFilter()` → `boolean`	Returns the auto filter.
`setAutoFilter(autoFilter: boolean)`	Sets the auto filter.
`getPivotTables()` → `boolean`	Returns the pivot tables.
`setPivotTables(pivotTables: boolean)`	Sets the pivot tables.
`getSelectUnlockedCells()` → `boolean`	Returns the select unlocked cells.
`setSelectUnlockedCells(selectUnlockedCells: boolean)`	Sets the select unlocked cells.
`getPasswordHash()` → `String`	Returns the password hash.
`setPasswordHash(passwordHash: String)`	Sets the password hash.
`getAlgorithmName()` → `String`	Returns the algorithm name.
`setAlgorithmName(algorithmName: String)`	Sets the algorithm name.
`getHashValue()` → `String`	Returns the hash value.
`setHashValue(hashValue: String)`	Sets the hash value.
`getSaltValue()` → `String`	Returns the salt value.
`setSaltValue(saltValue: String)`	Sets the salt value.
`getSpinCount()` → `String`	Returns the spin count.
`setSpinCount(spinCount: String)`	Sets the spin count.
`clear()`	Clears all protection settings to their default values.
`hasStoredState()` → `boolean`	Determines whether any protection state has been stored.

WorksheetProtectionModel

Overview

Description

Properties

Methods

See Also