The XLCellRange type exposes the following members.

Constructors

  Name Description
Public method XLCellRange()()()()
Creates an instance of an XLCellRange object containing an empty range.
Public method XLCellRange(C1XLBook, String)
Creates an instance of an XLCellRange object containing a specified range.
Public method XLCellRange(XLSheet, String)
Creates an instance of an XLCellRange object containing a specified range.
Public method XLCellRange(Int32, Int32, Int32, Int32)
Creates an instance of an XLCellRange object containing a specified range.
Public method XLCellRange(XLSheet, Int32, Int32, XLReferenceType, XLReferenceType)
Creates an instance of an XLCellRange object containing a specified range.
Public method XLCellRange(XLSheet, Int32, Int32, Int32, Int32)
Creates an instance of an XLCellRange object containing a specified range.
Public method XLCellRange(XLSheet, Int32, Int32, Int32, Int32, XLReferenceType, XLReferenceType, XLReferenceType, XLReferenceType)
Creates an instance of an XLCellRange object containing a specified range.
Public method XLCellRange(Int32, Int32, Int32, Int32, Int32, Int32, XLReferenceType, XLReferenceType, XLReferenceType, XLReferenceType)
Creates an instance of an XLCellRange object containing a specified range.

Methods

  Name Description
Public method Clone
Creates a copy of this cell range.
Public method Contains(XLCellRange)
Determines whether the range contains a specific range.
Public method Contains(XLSheet, Int32, Int32)
Determines whether the range contains a specific cell.
Public method Equals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
Public method GetHashCode
Serves as a hash function for a particular type.
(Inherited from Object.)
Public method GetType
Gets the Type of the current instance.
(Inherited from Object.)
Public method Intersects
Determines whether the range intersects another range.
Public method ToString
Returns a reference string that represents the range.
(Overrides Object..::..ToString()()()().)

Properties

  Name Description
Public property Book
Gets a reference to the parent C1XLBook object.
Public property ColumnCount
Gets the number of columns in the range.
Public property ColumnFrom
Gets the index of the left column in the range.
Public property ColumnFromRef
Gets the reference type of the left column in the range.
Public property ColumnTo
Gets or sets the index of the last column in the range.
Public property ColumnToRef
Gets the reference type of the right column in the range.
Public property IsEmpty
Determines whether the range is empty.
Public property RangeType
Gets or sets a type (default, indirect or offset) for this cell range.
Public property RowCount
Gets the number of rows in the range.
Public property RowFrom
Gets the index of the top row in the range.
Public property RowFromRef
Gets the reference type of the top row in the range.
Public property RowTo
Gets or sets the index of the last row in the range.
Public property RowToRef
Gets the reference type of the bottom row in the range.
Public property SheetCount
Gets the number of sheets in the range.
Public property SheetFrom
Gets the index of the first sheet in the range.
Public property Sheets
Gets an array of XLSheet objects.
Public property SheetTo
Gets or sets the index of the last sheet in the range.
Public property Style
Gets or sets the XLStyle object associated with this range of cells.
Public property Value
Gets or sets the complex value associated with this range of cells.

See Also