SpreadsheetGear The Performance Spreadsheet Component Company 
IRange Interface Methods
See Also 
SpreadsheetGear Namespace : IRange Interface


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

Public Methods

 NameDescription
 MethodActivate Sets the active cell of the worksheet associated with this IRange to the top-left cell of this IRange.  
 MethodAddComment Adds a single comment with the specified text to the single cell represented by this range.  
 MethodAutoFit Automatically sets the width of the specified columns or the height of the specified rows.  
 MethodClear Clears formulas, values and all formatting from the current IRange.  
 MethodClearComments Clears all comments associated with any cells in this range.  
 MethodClearContents Clears formulas and values from the current IRange.  
 MethodClearFormats Clears all formatting from the current IRange.  
 MethodCopyOverloaded.   
 MethodCopyDown Copies values, formulas and formats in the top row of the range to subsequent rows.  
 MethodCopyFromDataTable Copies the specified DataTable to this range.  
 MethodCopyRight Copies values, formulas and formats in the left column of the range to subsequent columns.  
 MethodDeleteOverloaded.   
 MethodGetAddress Returns a string representing the address of the range.  
 MethodGetArea Returns the zero based instance of IRange specified by index.  
 MethodGetCharacters Returns an instance of ICharacters which represents a range of characters belonging to a text cell.  
 MethodGetDataSet Returns a newly created data set from the cells referred to by this IRange.  
 MethodGetDataTable Returns a newly created data table from the cells referred to by this IRange.  
 MethodInsertOverloaded.   
 MethodMerge Merges the cells in the represented range into a single merged cell.  
 MethodOffset Returns a copy of the current IRange which is offset by the specified number of rows and columns.  
 MethodSelect Sets the current selection of the worksheet associated the this IRange to this cells in this IRange.  
 MethodUnMerge Converts merged cells in the represented range to normal cells.  
Top

See Also