Document Solutions for Excel, .NET Edition | Document Solutions
GrapeCity.Documents.Excel Namespace / IRange Interface

In This Topic
    IRange Interface Methods
    In This Topic

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

    Public Methods
     NameDescription
     Method Activates a single cell, which must be inside the current selection.  
     Method Adds comments to the current IRange.  
     Method Adds a threaded comment to the current IRange.  
     Method Filters a list using the AutoFilter.  
     MethodOverloaded.  Changes the width of the columns in the range or the height of the rows in the range to achieve the best fit.  
     Method Calculates formulas of the range as needed.  
     MethodReturns a ITextRun object that represents a range of characters within the cell text, this method can only be called when the value of cell is a string, or else System.InvalidOperationException is thrown.  
     Method Clears formulas, values, and all formatting from the current IRange.  
     Method Clears the comments from the current IRange  
     Method Clears the threaded comment from the current IRange  
     Method Clears formulas and values from the current IRange.  
     Method Clears all formatting from the current IRange.  
     Method Clears all hyperLinks from the current IRange.  
     Method Clears the outline for the specified range.  
     MethodOverloaded.  Copies the range to the specified range.  
     Method Cuts the range to the specified range.  
     MethodDeletes a cell or a range of cells from the worksheet and shifts other cells to replace deleted cells. Specifies which way to shift the cells.  
     Method Designates all the formulas of the range to be recalculated when the next calculation occurs.  
     Method Finds specific information in a range.  
     Method Generates the range data from the JSON string.  
     Method Generate the corresponding function "GETPIVOTDATA" for the cells in the pivot table.  
     MethodReturns a System.String value that represents the range reference. If all parameters are omitted, the return value is equal to the Address property.  
     MethodOverloaded.  Gets the dependent ranges of the left top cell of the range.  
     MethodOverloaded.  Gets the precedent ranges of the left top cell of the range.  
     MethodGets an IRange representing the used range in the current range.  
     Method Increments the OutlineLevel of the specified rows or columns.  
     MethodInserts a cell or a range of cells into the worksheet and shifts other cells away to make space. Specifies which way to shift the cells.  
     MethodOverloaded. Returns an IRange object that represents the intersection of two ranges.

    If range2 is from a different worksheet, an exception is thrown.  
     Method Merges the cells in the represented range into a single merged cell.  
     Method Returns an IRange object that represents the offset of this range.  
     Method Removes subtotals from a list.  
     Method Search in formulas and replace. Using this method doesn't change either the selection or the active cell.  
     Method Selects the object.  
     MethodOverloaded.  Sorts the cells represented by this range according to the specified options.  
     MethodGets a IRange object that represents all the cells that match the specified type and value.  
     Method Creates subtotals for the range.  
     MethodOverloaded.  Saves the range to the specified image file.  
     Method Generates a JSON string from the range.  
     Method Decrements the OutlineLevel of the specified rows or columns.  
     MethodOverloaded. Returns an IRange object that represents the union of two ranges.

    If range2 is from a different worksheet, an exception is thrown.  
     Method Converts merged cells in the represented range to normal cells.  
    Top
    See Also