| Name | Description | |
|---|---|---|
 | 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. |
| AutoFilterMode | Gets or sets the property which specifies whether this worksheet is in autofilter mode. |
| Cells | Returns an instance of IRange which provides access to cell values, formulas, formatting and other cell properties and methods. |
| DisplayAutomaticPageBreaks | Gets or sets the property which specifies whether automatic page breaks should be displayed. |
| HPageBreaks | Returns a reference to the horizontal (row) page break collection for the worksheet. |
| Hyperlinks | Returns a reference to the hyperlink collection for the worksheet. |
| Index | Returns the zero based index of this sheet. (Inherited from SpreadsheetGear.ISheet) |
| IsDisposed | Returns true if this sheet has been disposed. (Inherited from SpreadsheetGear.ISheet) |
| Name | Gets or sets the name of the sheet. (Inherited from SpreadsheetGear.ISheet) |
| Names | Returns the collection of worksheet specific defined names associated with this worksheet. |
| Outline | Returns an instance of IOutline which provides access to outline options. |
| PageSetup | Returns an instance of IPageSetup which provides access to page setup options. |
| ProtectContents | Gets or sets the property which specifies whether the contents of a worksheet are protected. |
| Range | Returns an instance of IRange which provides access to cell values, formulas, formatting and other cell properties and methods. |
| Shapes | Returns the collection of shapes associated with this worksheet. |
| StandardWidth | Gets or sets the default column width for this worksheet in units equal to the width of a character in the default font. |
| Tab | Returns a reference to the sheet tab of this sheet. (Inherited from SpreadsheetGear.ISheet) |
| TransitionExpEval | Gets or sets the property which specifies whether or not a worksheet should use transitional formula evaluation. |
| TransitionFormEntry | Gets or sets the property which specifies whether or not a worksheet should use transitional formula entry. |
| Type | Returns the SheetType of this sheet. (Inherited from SpreadsheetGear.ISheet) |
| UsedRange | Returns an IRange representing the portion of the worksheet which is in use. |
| Visible | Gets or sets the property which indicates whether or not a worksheet is visible. (Inherited from SpreadsheetGear.ISheet) |
| VPageBreaks | Returns a reference to the vertical (column) page break collection for the worksheet. |
| WindowInfo | Returns an instance of IWorksheetWindowInfo which represents worksheet specific window options for the currently active view. |
| WindowInfos | Returns a reference to the IWorksheetWindowInfo collection for the worksheet. |
| Workbook | Returns the workbook which contains the current sheet. (Inherited from SpreadsheetGear.ISheet) |
| WorkbookSet | Returns the parent IWorkbookSet of this sheet. (Inherited from SpreadsheetGear.ISheet) |
The following tables list the members exposed by IWorksheet.
Public Properties
Public Methods
| Name | Description | |
|---|---|---|
 | 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) |
| 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) |
| Delete | Deletes this sheet. (Inherited from SpreadsheetGear.ISheet) |
| EvaluateRange | Evaluates the specified formula and returns the resulting IRange. (Inherited from SpreadsheetGear.ISheet) |
| EvaluateRanges | Evaluates the specified formula and returns the resulting array of ranges. (Inherited from SpreadsheetGear.ISheet) |
| 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) |
| 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) |
| MoveAfter | Moves this sheet to come after the specified sheet. (Inherited from SpreadsheetGear.ISheet) |
| MoveBefore | Moves this sheet to come before the specified sheet. (Inherited from SpreadsheetGear.ISheet) |
| Protect | Enables protection for this worksheet with the specified password. |
| SaveAs | Saves this worksheet using the specified filename and FileFormat, and updates the FullName property. |
| SaveToMemory | Saves this worksheet to a newly created memory buffer in the specified FileFormat. |
| SaveToStream | Saves this worksheet to a stream in the specified FileFormat. |
| Select | Selects the sheet. (Inherited from SpreadsheetGear.ISheet) |
| Unprotect | Disables protection for the worksheet with the specified password. |
See Also