SpreadsheetGear 2023
ISheet Interface Members
Properties  Methods 

SpreadsheetGear Namespace : ISheet Interface

The following tables list the members exposed by ISheet.

Public Properties
 NameDescription
 PropertyReturns the IFactory which created this object or its parent. (Inherited from SpreadsheetGear.IFactoryChild)
 PropertyReturns the zero based index of this sheet.  
 PropertyReturns true if this sheet has been disposed.  
 PropertyGets or sets the name of the sheet.  
 PropertyReturns a reference to the sheet tab of this sheet.  
 PropertyReturns the SheetType of this sheet.  
 PropertyGets or sets the property which indicates whether or not a worksheet is visible.  
 PropertyReturns the workbook which contains the current sheet.  
 PropertyReturns the parent IWorkbookSet of this sheet.  
Top
Public Methods
 NameDescription
 MethodCreates a new sheet after the specified sheet and copies the contents of this sheet to the newly created sheet.  
 MethodCreates a new sheet before the specified sheet and copies the contents of this sheet to the newly created sheet.  
 MethodDeletes this sheet.  
 MethodEvaluates the specified formula and returns the resulting IRange.  
 MethodEvaluates the specified formula and returns the resulting array of ranges.  
 MethodEvaluates 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.  
 MethodEvaluates 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.  
 MethodMoves this sheet to come after the specified sheet.  
 MethodMoves this sheet to come before the specified sheet.  
 MethodSelects the sheet.  
Top
See Also

Reference

ISheet Interface
SpreadsheetGear Namespace