Worksheet
Overview
Worksheet is a class in Aspose.Cells FOSS for .NET.
Encapsulates a single worksheet and its supported v0.1 worksheet features. var workbook = new Workbook(); var sheet = workbook.Worksheets[0]; sheet.Name = “Data”; sheet.Cells[“A1”].PutValue(“North”); sheet.Cells[“B1”].PutValue(42); sheet.Zoom = 120; sheet.PageSetup.Orientation = PageOrientationType.Landscape;
This class provides 2 methods for working with Worksheet objects in .NET programs.
Available methods include: Protect, Unprotect.
All exported members are accessible to any .NET application after installing the Aspose.Cells FOSS for .NET package.
Properties: AutoFilter, Cells, Charts, Comments, ConditionalFormattings, Hyperlinks, and 14 more.
Description
Worksheet is a class in the Aspose.Cells FOSS library for .NET that exposes 2 methods and 20 properties for programmatic use.
The class also provides the Cells property (gets the cells), the Hyperlinks property (gets the hyperlinks), the Validations property (gets the validations).
Properties
| Name | Type | Access | Description |
|---|---|---|---|
Name | string | Read/Write | Gets or sets the name. |
VisibilityType | VisibilityType | Read/Write | Gets or sets the visibility type. |
TabColor | Color | Read/Write | Gets or sets the tab color. |
ShowGridlines | bool | Read/Write | Gets or sets the show gridlines. |
ShowRowColumnHeaders | bool | Read/Write | Gets or sets the show row column headers. |
ShowZeros | bool | Read/Write | Gets or sets the show zeros. |
RightToLeft | bool | Read/Write | Gets or sets the right to left. |
Zoom | int | Read/Write | Gets or sets the zoom. |
Cells | Cells | Read | Gets the cells. |
Hyperlinks | HyperlinkCollection | Read | Gets the hyperlinks. |
Validations | ValidationCollection | Read | Gets the validations. |
ConditionalFormattings | ConditionalFormattingCollection | Read | Gets the conditional formattings. |
PageSetup | PageSetup | Read | Gets the page setup. |
Protection | WorksheetProtection | Read | Gets the protection. |
AutoFilter | AutoFilter | Read | Gets the auto filter. |
ListObjects | ListObjectCollection | Read | Gets the list objects. |
Pictures | PictureCollection | Read | Gets the pictures. |
Shapes | ShapeCollection | Read | Gets the shapes. |
Charts | ChartCollection | Read | Gets the charts. |
Comments | CommentCollection | Read | Gets the comments. |
Methods
| Signature | Description |
|---|---|
Protect() | Marks the worksheet as protected using the current protection settings. |
Unprotect() | Clears worksheet protection and resets supported protection flags. |
