NativeExcel for .Net Developer's Reference

IRange Members

IRange overview

Public Instance Properties

Borders Returns an IBorders interface that represents the borders of the specified range.
Characters
Column Returns the number of the first column in the specified range
Columns Returns an IRangeColumns interface that represents the columns in the specified range.
ColumnWidth Gets or sets the width of columns in the specified range.
Comment Returns an IComment interface that represents the comment of the specified cell.
Count Returns the number of cells in the range.
DisplayValue Returns a formatted String representation of Value using NumberFormat
EntireColumn Returns an IRangeColumns interface that represents the entire column (or columns) that contains the specified range.
EntireRow Returns an IRangeRows interface that represents the entire row (or rows) that contains the specified range.
Font Returns an IFont interface that represents the font of the specified range
Formula Gets or sets the cell's formula.
FormulaHidden Gets or sets a value that indicates whether the formula in the range will be hidden when the worksheet is protected.
HasFormula Gets a value that indicates whether at least one cell in the range contains a formula.
Height Returns the height of the specified range.
HorizontalAlignment Gets or sets the horizontal alignment for the specified range.
Hyperlinks Returns an IHyperlinks interface that represents the collection of hyperlinks in the specified range.
IndentLevel Gets or sets the indent level for the cell or range.
Interior Returns an IInterior interface that represents the interior of the specified range.
ItemOverloaded. Returns an IRange interface that represents a range at an offset to the specified range.
Locked Gets or sets a value that indicates whether the cell is locked. If the cell is not locked it can be modified when the sheet is protected.
MergeArea Returns an IRange interface that represents the merged range containing the specified cell. If the specified cell isn't in a merged range, this property returns the specified cell.
MergeCells Gets or sets a value that indicates whether the specified range contains merged cells.
NumberFormat Gets or sets the format code for the specified range.
Orientation Gets or sets the text orientation for the specified range.
OutlineLevel Gets or sets the current outline level of the rows that contains the specified range.
ReadingOrder Gets or sets the reading order for the specified range.
Row Returns the number of the first row in the range.
RowHeight Gets or sets the height of rows in the specified range.
Rows Returns an IRangeRows interface that represents the rows in the specified range.
ShrinkToFit Determines if text automatically shrinks to fit in the available column width.
Value Gets or sets the value of the specified range.
VerticalAlignment Gets or sets the vertical alignment for the specified range.
Width Returns the width of the specified range.
WrapText Gets or sets a value that indicates whether the text are wrapped.

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