SpreadsheetGear 2012
IWorksheet Interface Methods

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

Public Methods
 NameDescription
 MethodCopyAfterCreates a new sheet after the specified sheet and copies the contents of this sheet to the newly created sheet. (Inherited from SpreadsheetGear.ISheet)
 MethodCopyBeforeCreates a new sheet before the specified sheet and copies the contents of this sheet to the newly created sheet. (Inherited from SpreadsheetGear.ISheet)
 MethodDeleteDeletes this sheet. (Inherited from SpreadsheetGear.ISheet)
 MethodEvaluateRangeEvaluates the specified formula and returns the resulting IRange. (Inherited from SpreadsheetGear.ISheet)
 MethodEvaluateRangesEvaluates the specified formula and returns the resulting array of ranges. (Inherited from SpreadsheetGear.ISheet)
 MethodEvaluateValueEvaluates the specified formula and returns the result as a System.Double, System.String, System.Boolean or ValueError. (Inherited from SpreadsheetGear.ISheet)
 MethodEvaluateValuesEvaluates 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. (Inherited from SpreadsheetGear.ISheet)
 MethodMoveAfterMoves this sheet to come after the specified sheet. (Inherited from SpreadsheetGear.ISheet)
 MethodMoveBeforeMoves this sheet to come before the specified sheet. (Inherited from SpreadsheetGear.ISheet)
 MethodProtectEnables protection for this worksheet with the specified password.  
 MethodSaveAsSaves this worksheet using the specified filename and FileFormat, and updates the FullName property.  
 MethodSaveToMemorySaves this worksheet to a newly created memory buffer in the specified FileFormat.  
 MethodSaveToStreamSaves this worksheet to a stream in the specified FileFormat.  
 MethodSelectSelects the sheet. (Inherited from SpreadsheetGear.ISheet)
 MethodUnprotectDisables protection for the worksheet with the specified password.  
Top
See Also

Reference

IWorksheet Interface
SpreadsheetGear Namespace

Send Feedback