The following tables list the members exposed by IWorksheet.
Public Properties
| Name | Description |
![Property](template/packages/core-dotnet/images/Property.png) | AutoFilter | Returns an instance of IAutoFilter which represents the autofilter options associated with this worksheet, or null if this worksheet is not in autofilter mode. |
![Property](template/packages/core-dotnet/images/Property.png) | AutoFilterMode | Gets or sets the property which specifies whether this worksheet is in autofilter mode. |
![Property](template/packages/core-dotnet/images/Property.png) | Cells | Returns an instance of IRange which provides access to cell values, formulas, formatting and other cell properties and methods. |
![Property](template/packages/core-dotnet/images/Property.png) | Comments | Returns the collection of cell comments associated with this worksheet. |
![Property](template/packages/core-dotnet/images/Property.png) | DisplayAutomaticPageBreaks | Gets or sets the property which specifies whether automatic page breaks should be displayed. |
![Property](template/packages/core-dotnet/images/Property.png) | EnableSelection | Gets or sets what can be selected on the worksheet when it is protected. |
![Property](template/packages/core-dotnet/images/Property.png) | Factory | Returns the IFactory which created this object or its parent. (Inherited from SpreadsheetGear.IFactoryChild) |
![Property](template/packages/core-dotnet/images/Property.png) | HPageBreaks | Returns a reference to the horizontal (row) page break collection for the worksheet. |
![Property](template/packages/core-dotnet/images/Property.png) | Hyperlinks | Returns a reference to the hyperlink collection for the worksheet. |
![Property](template/packages/core-dotnet/images/Property.png) | Index | Returns the zero based index of this sheet. (Inherited from SpreadsheetGear.ISheet) |
![Property](template/packages/core-dotnet/images/Property.png) | IsDisposed | Returns true if this sheet has been disposed. (Inherited from SpreadsheetGear.ISheet) |
![Property](template/packages/core-dotnet/images/Property.png) | Name | Gets or sets the name of the sheet. (Inherited from SpreadsheetGear.ISheet) |
![Property](template/packages/core-dotnet/images/Property.png) | Names | Returns the collection of worksheet specific defined names associated with this worksheet. |
![Property](template/packages/core-dotnet/images/Property.png) | Outline | Returns an instance of IOutline which provides access to outline options. |
![Property](template/packages/core-dotnet/images/Property.png) | PageSetup | Returns an instance of IPageSetup which provides access to page setup options. |
![Property](template/packages/core-dotnet/images/Property.png) | ProtectContents | Gets or sets the property which specifies whether the contents of a worksheet are protected. |
![Property](template/packages/core-dotnet/images/Property.png) | ProtectDrawingObjects | Gets or sets the property which specifies whether the droawing objects on a worksheet are protected. |
![Property](template/packages/core-dotnet/images/Property.png) | Protection | Gets the fine-grained protection attributes for a worksheet. |
![Property](template/packages/core-dotnet/images/Property.png) | ProtectionMode | Gets or sets the value which specifies whether API access is allowed while the worksheet is protected. |
![Property](template/packages/core-dotnet/images/Property.png) | ProtectScenarios | Gets or sets the property which specifies whether worksheet scenarios are protected. |
![Property](template/packages/core-dotnet/images/Property.png) | Range | Returns an instance of IRange which provides access to cell values, formulas, formatting and other cell properties and methods. |
![Property](template/packages/core-dotnet/images/Property.png) | Shapes | Returns the collection of shapes associated with this worksheet. |
![Property](template/packages/core-dotnet/images/Property.png) | StandardWidth | Gets or sets the default column width for this worksheet in units equal to the width of a character in the default font. |
![Property](template/packages/core-dotnet/images/Property.png) | Tab | Returns a reference to the sheet tab of this sheet. (Inherited from SpreadsheetGear.ISheet) |
![Property](template/packages/core-dotnet/images/Property.png) | TransitionExpEval | Gets or sets the property which specifies whether or not a worksheet should use transitional formula evaluation. |
![Property](template/packages/core-dotnet/images/Property.png) | TransitionFormEntry | Gets or sets the property which specifies whether or not a worksheet should use transitional formula entry. |
![Property](template/packages/core-dotnet/images/Property.png) | Type | Returns the SheetType of this sheet. (Inherited from SpreadsheetGear.ISheet) |
![Property](template/packages/core-dotnet/images/Property.png) | UsedRange | Returns an IRange representing the portion of the worksheet which is in use. |
![Property](template/packages/core-dotnet/images/Property.png) | Visible | Gets or sets the property which indicates whether or not a worksheet is visible. (Inherited from SpreadsheetGear.ISheet) |
![Property](template/packages/core-dotnet/images/Property.png) | VPageBreaks | Returns a reference to the vertical (column) page break collection for the worksheet. |
![Property](template/packages/core-dotnet/images/Property.png) | WindowInfo | Returns an instance of IWorksheetWindowInfo which represents worksheet specific window options for the currently active view. |
![Property](template/packages/core-dotnet/images/Property.png) | WindowInfos | Returns a reference to the IWorksheetWindowInfo collection for the worksheet. |
![Property](template/packages/core-dotnet/images/Property.png) | Workbook | Returns the workbook which contains the current sheet. (Inherited from SpreadsheetGear.ISheet) |
![Property](template/packages/core-dotnet/images/Property.png) | WorkbookSet | Returns the parent IWorkbookSet of this sheet. (Inherited from SpreadsheetGear.ISheet) |
Top
Public Methods
| Name | Description |
![Method](template/packages/core-dotnet/images/Method.png) | CopyAfter | Creates a new sheet after the specified sheet and copies the contents of this sheet to the newly created sheet. (Inherited from SpreadsheetGear.ISheet) |
![Method](template/packages/core-dotnet/images/Method.png) | CopyBefore | Creates a new sheet before the specified sheet and copies the contents of this sheet to the newly created sheet. (Inherited from SpreadsheetGear.ISheet) |
![Method](template/packages/core-dotnet/images/Method.png) | Delete | Deletes this sheet. (Inherited from SpreadsheetGear.ISheet) |
![Method](template/packages/core-dotnet/images/Method.png) | EvaluateRange | Evaluates the specified formula and returns the resulting IRange. (Inherited from SpreadsheetGear.ISheet) |
![Method](template/packages/core-dotnet/images/Method.png) | EvaluateRanges | Evaluates the specified formula and returns the resulting array of ranges. (Inherited from SpreadsheetGear.ISheet) |
![Method](template/packages/core-dotnet/images/Method.png) | EvaluateValue | Evaluates the specified formula and returns the result as a System.Double, System.String, System.Boolean, ValueError or null if the formula is invalid or the formula evaluates to a reference to an empty cell. (Inherited from SpreadsheetGear.ISheet) |
![Method](template/packages/core-dotnet/images/Method.png) | EvaluateValues | Evaluates the specified comma separated list of expressions and returns the result(s) as an array of objects, where each object is a System.Double, System.String, System.Boolean or ValueError. null is returned if any of the expressions is invalid or if any of the expressions evaluates to a reference to an empty cell. (Inherited from SpreadsheetGear.ISheet) |
![Method](template/packages/core-dotnet/images/Method.png) | MoveAfter | Moves this sheet to come after the specified sheet. (Inherited from SpreadsheetGear.ISheet) |
![Method](template/packages/core-dotnet/images/Method.png) | MoveBefore | Moves this sheet to come before the specified sheet. (Inherited from SpreadsheetGear.ISheet) |
![Method](template/packages/core-dotnet/images/Method.png) | Protect | Enables protection for this worksheet with the optional password, protect* and allow* options. |
![Method](template/packages/core-dotnet/images/Method.png) | SaveAs | Saves this worksheet using the specified filename and FileFormat, and updates the FullName property. |
![Method](template/packages/core-dotnet/images/Method.png) | SaveToMemory | Saves this worksheet to a newly created memory buffer in the specified FileFormat. |
![Method](template/packages/core-dotnet/images/Method.png) | SaveToStream | Saves this worksheet to a stream in the specified FileFormat. |
![Method](template/packages/core-dotnet/images/Method.png) | Select | Selects the sheet. (Inherited from SpreadsheetGear.ISheet) |
![Method](template/packages/core-dotnet/images/Method.png) | Unprotect | Disables protection for the worksheet with the specified password. |
Top
See Also