Documents for Excel, Java Edition Documentation
com.grapecity.documents.excel Package / 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
     MethodActivates a single cell, which must be inside the current selection.  
     MethodAdds comments to the current range.  
     MethodOverloaded. Filters a list using the AutoFilter.  
     MethodChanges the width of the columns in the range or the height of the rows in the range to achieve the best fit.  
     Method  
     MethodClears formulas, values, and all formatting from the current range.  
     MethodClears the comments from the current range  
     MethodClears formulas and values from the current range.  
     MethodClears all formatting from the current range.  
     MethodClears all hyperLinks from the current range.  
     MethodClears the outline for the specified range.  
     MethodOverloaded. Copies the range to the specified range.  
     MethodCuts the range to the specified range.  
     MethodOverloaded. Deletes a cell or a range of cells from the worksheet and shifts other cells to replace deleted cells.  
     MethodOverloaded. Finds specific information in a range.  
     MethodOverloaded. Returns a new instance of IRange which is offset from this range.  
     MethodGets the property which controls indentation of text when horizontal or vertical alignment is set to distributed.  
     MethodReturns an instance of IAreas which represents an array of ranges where each range returned by areas represents one cell or range.  
     MethodGets the binding path of the current cell or column. If range is normal range, returns the binding path of the top-left cell of range. If range is EntireColumn, returns the binding path of the left column binding path of range. If range is EntireRow, returns null.  
     MethodReturns an instance of IBorders which represents the cell borders of the cell or range represented by this IRange.  
     MethodReturns the IRange object that represents the cells in the specified range.  
     Method  
     MethodReturns the zero based column number of the last column of the first range.  
     MethodReturns the column count of the first range.  
     MethodReturns the IRange object that represents the columns in the specified range.  
     MethodGets the width of the individual columns represented in this range in characters.  
     MethodGets the width of the individual columns represented in this range in pixels.  
     MethodReturns an instance of IComment which may be used to get and set Comment properties of the cells.  
     MethodReturns the number of objects in the collection.  
     MethodGets whether the specified cell is part of an array, returns an IRange object that represents the entire array.  
     Method  
     MethodGets a DisplayFormat object that represents the display settings for the specified range.  
     MethodReturns a new instance of IRange which represents the same range of cells, but expanded to include all rows.  
     MethodReturns an IRange representing the area of the current range which is iteratively grown as needed until it includes no partial merged cells.  
     MethodReturns a new instance of IRange which represents the same range of cells, but expanded to include all columns.  
     MethodReturns an instance of IFont which may be used to get and set font properties of the cells represented by this IRange.  
     MethodReturns a FormatConditions collection that represents all the conditional formats for the specified range.  
     MethodGets the formula of the cells represented by this range.  
     MethodGets the array formula of a range.  
     MethodGets the array formula of a range using ReferenceStyle.R1C1.  
     MethodGets or Sets whether the formula will be hidden when the worksheet is protected  
     MethodGets the value or formula of the cells represented by this range using ReferenceStyle.R1C1.  
     MethodDetermines if the specified cell is part of an array formula.  
     MethodReturns true if the cell or range contains any formulas; otherwise, false is returned.  
     MethodReturns true if any of the cells represented by this range have data validation associated with them.  
     MethodGets the height, in points, of the range.  
     MethodGets the height, in pixels, of the range.  
     MethodGets the property which specifies whether rows or columns should be hidden.  
     MethodGets the HorizontalAlignment of a cell or range.  
     MethodReturns an instance of IValidation which may be used to get and set HyperLinks properties.  
     MethodGets the indent level of the specified cell(s).  
     MethodReturns the IInterior which represents the interior (background) color and pattern of the specified cell(s).  
     MethodReturns the zero based column number of the first column of this IRange.  
     MethodReturns the zero based row number of the last row of the first range.  
     MethodGets the property which specifies whether cells should be locked.  
     MethodReturns an IRange representing the merged range containing the specified cell. If the specified cell isn't in a merged range, this property returns the specified cell.  
     MethodGets the property which specifies whether cells are merged.  
     MethodGets the number format of the cells in the range.  
     MethodGets the text orientation of a cell or range, which may be from -90 to 90 degrees.  
     MethodGets the current outline level of the specified row or column.  
     Method  
     MethodGets or Sets the reading order for the specified object.  
     Method  
     MethodReturns the zero based row number of the first row.  
     MethodReturns the row count of the first range.  
     MethodGets the height of the individual rows represented by this range in points.  
     MethodGets the height of the individual rows represented by this range in pixels.  
     MethodReturns the IRange object that represents the rows in the specified range.  
     MethodGets whether to show the detail (True if the outline is expanded for the specified range, so that the detail of the column or row is visible). The specified range must be a single summary column or row in an outline. The following statements are true: 1.The range must be in a single summary row or column. 2.This property returns False if any of the children of the row or column are hidden. 3.Setting this property to True is equivalent to unhiding all the children of the summary row or column. 4.Setting this property to False is equivalent to hiding all the children of the summary row or column.  
     MethodGets the property which specifies whether cells will be drawn in a smaller font if needed to display the contents of the cell.  
     MethodReturns an instance of ISparklineGroups which may be used to get and set SparklineGroups properties of the cells  
     MethodGets the named style IStyle associated with the cells represented by this IRange.  
     MethodDetermines if the range is an outlining summary row or column.  
     MethodGets the tag value of the specified range in the sheet.  
     MethodGets the value of the cell represented by this IRange as a formatted string.  
     MethodDetermines if the row height of the IRange object equals the standard height of the sheet.  
     MethodDetermines if the column width of the IRange object equals the standard width of the sheet.  
     MethodReturns an instance of IValidation which may be used to get and set validation properties of the cells represented by this IRange.  
     MethodReturns true if the validation options of all cells represented by this IRange are the same; otherwise, false is returned.  
     MethodGets the value of the specified range as a string, double, boolean, java.util.Date, Object[][] or null;  
     MethodGets the VerticalAlignment of a cell or range.  
     MethodGets the width, in points, of the range.  
     MethodGets the width, in pixels, of the range.  
     MethodReturns the parent IWorksheet of this range.  
     MethodGet the flag which indicates whether word wrap is enabled in a cell.  
     MethodIncrements the OutlineLevel of the specified rows or columns.  
     MethodOverloaded. Inserts a cell or a range of cells into the worksheet and shifts other cells away to make space.  
     Method  
     MethodOverloaded. Merges the cells in the represented range into a single merged cell.  
     MethodRemoves subtotals from a list.  
     MethodOverloaded. Search in formulas and replace. Using this method doesn't change either the selection or the active cell.  
     MethodSelects the object.  
     MethodSets the property which controls indentation of text when horizontal or vertical alignment is set to distributed.  
     MethodSets the binding path of the current cell or column. If range is normal range, sets the binding path of the top-left cell of range. If range is EntireColumn, sets the binding path of the left column binding path of range. If range is EntireRow, do nothing.  
     Method  
     MethodSets the width of the individual columns represented in this range in characters.  
     MethodSets the width of the individual columns represented in this range in pixels.  
     MethodSets the formula of the cells represented by this range.  
     MethodSets the array formula of a range.  
     MethodSets the array formula of a range using ReferenceStyle.R1C1.  
     MethodSets whether the formula will be hidden when the worksheet is protected  
     MethodSets the value or formula of the cells represented by this range using ReferenceStyle.R1C1.  
     MethodSets the property which specifies whether rows or columns should be hidden.  
     MethodSets the HorizontalAlignment of a cell or range.  
     MethodSets the indent level of the specified cell(s).  
     MethodSets the property which specifies whether cells should be locked.  
     MethodSets the property which specifies whether cells are merged.  
     MethodSets the number format of the cells in the range.  
     MethodSets the text orientation of a cell or range, which may be from -90 to 90 degrees.  
     MethodSets the current outline level of the specified row or column.  
     MethodSets the reading order for the specified object.  
     MethodSets the height of the individual rows represented by this range in points.  
     MethodSets the height of the individual rows represented by this range in pixels.  
     MethodSets whether to show the detail (True if the outline is expanded for the specified range, so that the detail of the column or row is visible). The specified range must be a single summary column or row in an outline. The following statements are true: 1.The range must be in a single summary row or column. 2.This property returns False if any of the children of the row or column are hidden. 3.Setting this property to True is equivalent to unhiding all the children of the summary row or column. 4.Setting this property to False is equivalent to hiding all the children of the summary row or column.  
     MethodSets the property which specifies whether cells will be drawn in a smaller font if needed to display the contents of the cell.  
     MethodSets the named style IStyle associated with the cells represented by this IRange.  
     MethodSets the tag value of the specified range in the sheet.  
     MethodDetermines if the row height of the IRange object equals the standard height of the sheet.  
     MethodDetermines if the column width of the IRange object equals the standard width of the sheet.  
     MethodSets the value of the specified cell as a string, double, int, boolean, java.util.Date, java.util.Calendar, Object[][] or null.  
     MethodSets the VerticalAlignment of a cell or range.  
     MethodSets the flag which indicates whether word wrap is enabled in a cell.  
     MethodOverloaded. Sorts the cells represented by this range according to the specified options.  
     MethodOverloaded. Creates subtotals for the range.  
     MethodOverloaded. Saves the range to the specified image file.  
     MethodDecrements the OutlineLevel of the specified rows or columns.  
     MethodConverts merged cells in the represented range to normal cells.  
    Top
    See Also