ComponentOne Excel for .NET
C1.Excel Assembly / C1.Excel Namespace / XLCellRange Class
Properties Methods

In This Topic
    XLCellRange Class Members
    In This Topic

    The following tables list the members exposed by XLCellRange.

    Public Constructors
     NameDescription
    Public ConstructorOverloaded.   
    Top
    Public Properties
     NameDescription
    Public PropertyGets a reference to the parent C1XLBook object.  
    Public PropertyGets the number of columns in the range.  
    Public PropertyGets the index of the left column in the range.  
    Public PropertyGets the reference type of the left column in the range.  
    Public PropertyGets or sets the index of the last column in the range.  
    Public PropertyGets the reference type of the right column in the range.  
    Public PropertyDetermines whether the range is empty.  
    Public PropertyGets or sets a type (default, indirect or offset) for this cell range.  
    Public PropertyGets the number of rows in the range.  
    Public PropertyGets the index of the top row in the range.  
    Public PropertyGets the reference type of the top row in the range.  
    Public PropertyGets or sets the index of the last row in the range.  
    Public PropertyGets the reference type of the bottom row in the range.  
    Public PropertyGets the number of sheets in the range.  
    Public PropertyGets the index of the first sheet in the range.  
    Public PropertyGets an array of XLSheet objects.  
    Public PropertyGets or sets the index of the last sheet in the range.  
    Public PropertyGets or sets the XLStyle object associated with this range of cells.  
    Public PropertyGets or sets the complex value associated with this range of cells.  
    Top
    Public Methods
     NameDescription
    Public MethodCreates a copy of this cell range.  
    Public MethodOverloaded. Determines whether the range contains a specific cell.  
    Public MethodDetermines whether the range intersects another range.  
    Public Methodstatic (Shared in Visual Basic)Gets string with row and column reference in A1 mode.  
    Public Methodstatic (Shared in Visual Basic)Gets string with row and column reference in R1C1 mode.  
    Public MethodReturns a reference string that represents the range.  
    Top
    See Also