SpreadsheetGear The Performance Spreadsheet Component Company 
ISheet Interface Members
See Also  Properties  Methods 
SpreadsheetGear Namespace : ISheet Interface


The following tables list the members exposed by ISheet.

Public Properties

 NameDescription
 PropertyIndex Returns the zero based index of this sheet.  
 PropertyName Gets or sets the name of the sheet.  
 PropertyTab Returns a reference to the sheet tab of this sheet.  
 PropertyType Returns the SheetType of this sheet.  
 PropertyVisible Gets or sets the property which indicates whether or not a worksheet is visible.  
 PropertyWorkbook Returns the workbook which contains the current sheet.  
 PropertyWorkbookSet Returns the parent IWorkbookSet of this sheet.  
Top

Public Methods

 NameDescription
 MethodCopyAfter Creates a new sheet after the specified sheet and copies the contents of this sheet to the newly created sheet.  
 MethodCopyBefore Creates a new sheet before the specified sheet and copies the contents of this sheet to the newly created sheet.  
 MethodDelete Deletes this sheet.  
 MethodEvaluateRange Evaluates the specified formula and returns the resulting IRange.  
 MethodEvaluateRanges Evaluates the specified formula and returns the resulting array of ranges.  
 MethodEvaluateValue Evaluates the specified formula and returns the result as a System.Double, System.String, System.Boolean or ValueError.  
 MethodEvaluateValues 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.  
 MethodMoveAfter Moves this sheet to come after the specified sheet.  
 MethodMoveBefore Moves this sheet to come before the specified sheet.  
 MethodSelect Selects the sheet.  
Top

See Also