| SpreadsheetGear Namespace : ISheet Interface |
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. |
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. |
ISheet Interface | SpreadsheetGear Namespace
See our live Excel Reporting, Excel Charting, Excel to DataGrid and Excel Calculation Samples.
Copyright © 2003-2007 SpreadsheetGear LLC. All Rights Reserved.
SpreadsheetGear and Spreadsheet Gear are trademarks of SpreadsheetGear LLC.