NativeExcel for .Net Developer's Reference

IRangeProperties

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

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.

See Also

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