Link Search Menu Expand Document

Range Properties

The Range type exposes the following members.

Properties
NameDescription
Public propertyAlignmentHorizontal
Sets a horizontal text alignment style of the cell.
Public propertyAlignmentVertical
Sets the vertical text alignment style of the cell.
Public propertyAreas
Gets an Areas collection that represents all the ranges in a multiple-area selection.
Public propertyBottomBorderColor
Sets the color of the bottom border.
Public propertyBottomBorderStyle
Sets the bottom border style.
Public propertyBottomRowIndex
Index of the bottom row of the range.
Public propertyCellFormat
Sets the cell format.
Public propertyColumn
Gets the zero based column number of the first column in the first area (Areas[0]) of the Range .
Public propertyColumns
Gets a Range object that represents the columns in the specified range.
Public propertyCode exampleCount
Gets the number of cells in the Range.
Public propertyDiagonalBorderColor
Sets the color of the diagonal border.
Public propertyDiagonalBorderStyle
Sets the diagonal border style.
Public propertyFillPattern
Sets the fill pattern.
Public propertyFillPatternBackColor
Sets the background color for a fill pattern.
Public propertyFillPatternForeColor
Sets the foreground color for a fill pattern.
Public propertyFont
Sets the font of the cell.
Public propertyFontColor
Sets the color of the font.
Public propertyFontColorIndex
Sets the index of the font color.
Public propertyFontEscapement
Sets the font escapement.
Public propertyFontUnderline
Sets the font underline style.
Public propertyFormula
Sets the formula for the range.
Public propertyHiddenFormula
Gets or sets a value indicating whether formula is hidden.
Public propertyIndent
Gets or sets the Indent value for the cell.
Public propertyInnerBorderColor
Sets the color of the inner border.
Public propertyInnerBorderStyle
Sets the inner border style.
Public propertyIsDiagonalDownLine
Sets a value indicating whether this instance is diagonal down line.
Public propertyIsDiagonalUpLine
Sets a value indicating whether this instance is diagonal up line.
Public propertyIsNotEmptyCells
Gets a bool value indicating that the range contains only empty cells or not
Public propertyLeftBorderColor
Sets the color of the left border.
Public propertyLeftBorderStyle
Sets the left border style.
Public propertyLeftColumnIndex
Index of the left column of the range.
Public propertyLocked
Sets a value indicating whether this IRange is locked.
Public propertyNumberFormatString
Sets the number format string.
Public propertyOuterBorderColor
Sets the color of the outer border.
Public propertyOuterBorderStyle
Sets the outer border style.
Public propertyRightBorderColor
Sets the color of the right border.
Public propertyRightBorderStyle
Sets the right border style.
Public propertyRightColumnIndex
Index of the right column of the range.
Public propertyRotation
Sets the text rotation angle for the cell.
Public propertyRow
Gets the zero based row number of the first row in the first area (Areas[0]) of the Range .
Public propertyRows
Gets a Range object that represents the rows in the specified range.
Public propertyShrinkToFit
Gets or sets a value indicating shrink content to fit into cell.
Public propertyTextDirection
Gets or sets the reading order.
Public propertyTopBorderColor
Sets the color of the top border.
Public propertyTopBorderStyle
Sets the top border style.
Public propertyTopRowIndex
Index of the top row of the range.
Public propertyValue
Sets the value of range.
Public propertyValueAsHTML
Sets the formatted text (Rich-Text) in HTML coded format
Public propertyValueDataTypeByNumberFormatString
Sets the type (ValueDataTypeByNumberFormatString) of the number format.
Public propertyWrap
Sets a value indicating a text is wrapped.
Top
See Also

Reference