Worksheet
Overview
Worksheet is a class in Aspose.Cells for NET.
Worksheet.Protect enables worksheet protection, preventing edits to locked cells.
Properties
| Name | Type | Access | Description |
|---|---|---|---|
Name | string | Read/Write | Gets or sets the worksheet’s display name |
VisibilityType | VisibilityType | Read/Write | Gets or sets whether the sheet is visible, hidden, or very hidden |
TabColor | Color | Read/Write | Gets or sets the color of the worksheet tab |
ShowGridlines | bool | Read/Write | Gets or sets whether gridlines are displayed on the sheet |
ShowRowColumnHeaders | bool | Read/Write | Gets or sets visibility of row and column headers |
ShowZeros | bool | Read/Write | Gets or sets whether zero values are shown in cells |
RightToLeft | bool | Read/Write | Gets or sets right‑to‑left display orientation for the sheet |
Zoom | int | Read/Write | Gets or sets the zoom level percentage for the sheet view |
Cells | Cells | Read | Provides access to the collection of cells in the worksheet |
Hyperlinks | HyperlinkCollection | Read | Provides the collection of hyperlinks defined on the sheet |
Validations | ValidationCollection | Read | Provides the collection of data validations defined on the worksheet |
ConditionalFormattings | ConditionalFormattingCollection | Read | Provides the collection of conditional formatting rules |
PageSetup | PageSetup | Read | Provides page layout and printing settings for the sheet |
Protection | WorksheetProtection | Read | Provides the worksheet’s protection configuration object |
AutoFilter | AutoFilter | Read | Provides the auto‑filter functionality applied to the sheet |
Methods
| Signature | Description |
|---|---|
Protect() | Enables worksheet protection, preventing edits to locked cells |
Unprotect() | Disables worksheet protection, allowing edits |