SpreadsheetGear Namespace : ISheet Interface |
The following tables list the members exposed by ISheet.
Name | Description | |
---|---|---|
Index | Returns the zero based index of this sheet. | |
Name | Gets or sets the name of the sheet. | |
Tab | Returns a reference to the sheet tab of this sheet. | |
Type | Returns the SheetType of this sheet. | |
Visible | Gets or sets the property which indicates whether or not a worksheet is visible. | |
Workbook | Returns the workbook which contains the current sheet. | |
WorkbookSet | Returns the parent IWorkbookSet of this sheet. |
Name | Description | |
---|---|---|
CopyAfter | Creates a new sheet after the specified sheet and copies the contents of this sheet to the newly created sheet. | |
CopyBefore | Creates a new sheet before the specified sheet and copies the contents of this sheet to the newly created sheet. | |
Delete | Deletes this sheet. | |
EvaluateRange | Evaluates the specified formula and returns the resulting IRange. | |
EvaluateRanges | Evaluates the specified formula and returns the resulting array of ranges. | |
EvaluateValue | Evaluates the specified formula and returns the result as a System.Double, System.String, System.Boolean or ValueError. | |
EvaluateValues | Evaluates the specified formula and returns the result as an array of objects, where each object is a System.Double, System.String, System.Boolean or ValueError. | |
MoveAfter | Moves this sheet to come after the specified sheet. | |
MoveBefore | Moves this sheet to come before the specified sheet. | |
Select | Selects the sheet. |