NativeExcel for .Net Developer's Reference

IRangeMethods

The methods of the IRange interface are listed below. For a complete list of IRange interface members, see the IRange Members topic.

Public Instance Methods

AddCommentOverloaded. Adds a comment to the cell and returns IComment interface.
AddressOverloaded. Returns the range reference.
Autofit Changes the width of the columns in the range to achieve the best fit.
Clear Clears the cells in the specified range.
ClearComments Clears all cell comments from the specified range.
ClearContents Clears the data from the range but leaves the formatting.
ClearOutline Clears the outline for rows and columns in the specified range.
CopyOverloaded. Copies a cell or a range of cells to the specified range.
DeleteOverloaded. Deletes a cell or a range of cells from the worksheet.
GetDataTable Returns a newly created data table from the specified range.
GetEnumerator Returns an System.Collections.IEnumerator implemented object that contains all cells within the range.
Group Increases the outline level of rows in the specifed range.
InsertOverloaded. Inserts a cell or a range of cells into the worksheet and shifts other cells away to make space.
isIntersect Tests whether the range is intersected with specified range.
MergeOverloaded. Creates a merged cell from the specified range.
MoveOverloaded. Moves a cell or a range of cells to the specified range.
SaveAsOverloaded. Saves range content in a file or a Stream.
Select Selects the cells in the specified range.
SetDataTable Copies the specified DataTable into this range.
Ungroup Decreases the outline level of rows in the specifed range.
UnMerge Separates a merged area into individual cells.

See Also

IRange Interface | NativeExcel Namespace | Range Property | Cells Property | How to reference Cells and Ranges