SpreadsheetGear 2023
IWorksheet Interface Methods

SpreadsheetGear Namespace : IWorksheet Interface

For a list of all members of this type, see IWorksheet members.

Public Methods
 NameDescription
 MethodCreates a new sheet after the specified sheet and copies the contents of this sheet to the newly created sheet. (Inherited from SpreadsheetGear.ISheet)
 MethodCreates a new sheet before the specified sheet and copies the contents of this sheet to the newly created sheet. (Inherited from SpreadsheetGear.ISheet)
 MethodDeletes this sheet. (Inherited from SpreadsheetGear.ISheet)
 MethodEvaluates the specified formula and returns the resulting IRange. (Inherited from SpreadsheetGear.ISheet)
 MethodEvaluates the specified formula and returns the resulting array of ranges. (Inherited from SpreadsheetGear.ISheet)
 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. (Inherited from SpreadsheetGear.ISheet)
 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. (Inherited from SpreadsheetGear.ISheet)
 MethodMoves this sheet to come after the specified sheet. (Inherited from SpreadsheetGear.ISheet)
 MethodMoves this sheet to come before the specified sheet. (Inherited from SpreadsheetGear.ISheet)
 MethodEnables protection for this worksheet with the optional password, protect* and allow* options.  
 MethodSaves this worksheet using the specified filename and FileFormat, and updates the FullName property.  
 MethodSaves this worksheet to a newly created memory buffer in the specified FileFormat.  
 MethodSaves this worksheet to a stream in the specified FileFormat.  
 MethodSelects the sheet. (Inherited from SpreadsheetGear.ISheet)
 MethodDisables protection for the worksheet with the specified password.  
Top
See Also

Reference

IWorksheet Interface
SpreadsheetGear Namespace