Name | Description | |
---|---|---|
CopyAfter | Creates a new sheet after the specified sheet and copies the contents of this sheet to the newly created sheet. (Inherited from SpreadsheetGear.ISheet) | |
CopyBefore | Creates a new sheet before the specified sheet and copies the contents of this sheet to the newly created sheet. (Inherited from SpreadsheetGear.ISheet) | |
Delete | Deletes this sheet. (Inherited from SpreadsheetGear.ISheet) | |
EvaluateRange | Evaluates the specified formula and returns the resulting IRange. (Inherited from SpreadsheetGear.ISheet) | |
EvaluateRanges | Evaluates the specified formula and returns the resulting array of ranges. (Inherited from SpreadsheetGear.ISheet) | |
EvaluateValue | Evaluates 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) | |
EvaluateValues | Evaluates 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) | |
MoveAfter | Moves this sheet to come after the specified sheet. (Inherited from SpreadsheetGear.ISheet) | |
MoveBefore | Moves this sheet to come before the specified sheet. (Inherited from SpreadsheetGear.ISheet) | |
Protect | Enables protection for this worksheet with the optional password, protect* and allow* options. | |
SaveAs | Saves this worksheet using the specified filename and FileFormat, and updates the FullName property. | |
SaveToMemory | Saves this worksheet to a newly created memory buffer in the specified FileFormat. | |
SaveToStream | Saves this worksheet to a stream in the specified FileFormat. | |
Select | Selects the sheet. (Inherited from SpreadsheetGear.ISheet) | |
Unprotect | Disables protection for the worksheet with the specified password. |