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 ConstructorXLCellRange ConstructorOverloaded.   
    Top
    Public Properties
     NameDescription
    Public PropertyBookGets a reference to the parent C1XLBook object.  
    Public PropertyColumnCountGets the number of columns in the range.  
    Public PropertyColumnFromGets the index of the left column in the range.  
    Public PropertyColumnFromRefGets the reference type of the left column in the range.  
    Public PropertyColumnToGets or sets the index of the last column in the range.  
    Public PropertyColumnToRefGets the reference type of the right column in the range.  
    Public PropertyIsEmptyDetermines whether the range is empty.  
    Public PropertyRangeTypeGets or sets a type (default, indirect or offset) for this cell range.  
    Public PropertyRowCountGets the number of rows in the range.  
    Public PropertyRowFromGets the index of the top row in the range.  
    Public PropertyRowFromRefGets the reference type of the top row in the range.  
    Public PropertyRowToGets or sets the index of the last row in the range.  
    Public PropertyRowToRefGets the reference type of the bottom row in the range.  
    Public PropertySheetCountGets the number of sheets in the range.  
    Public PropertySheetFromGets the index of the first sheet in the range.  
    Public PropertySheetsGets an array of XLSheet objects.  
    Public PropertySheetToGets or sets the index of the last sheet in the range.  
    Public PropertyStyleGets or sets the XLStyle object associated with this range of cells.  
    Public PropertyValueGets or sets the complex value associated with this range of cells.  
    Top
    Public Methods
     NameDescription
    Public MethodCloneCreates a copy of this cell range.  
    Public MethodContainsOverloaded. Determines whether the range contains a specific cell.  
    Public MethodIntersectsDetermines whether the range intersects another range.  
    Public Methodstatic (Shared in Visual Basic)ToA1Gets string with row and column reference in A1 mode.  
    Public Methodstatic (Shared in Visual Basic)ToR1C1Gets string with row and column reference in R1C1 mode.  
    Public MethodToStringReturns a reference string that represents the range.  
    Top
    See Also

    Reference

    XLCellRange Class
    C1.Excel Namespace