Xceed Logo
Shop
Xceed Workbooks for .NET v3.0 Documentation
Xceed.Workbooks.NET Assembly / Xceed.Workbooks.NET Namespace / CellRange Class
Example


In This Topic
    CellRange Class
    In This Topic

    Represents a rectangular range of Cells. The top-left and bottom-right Cells delimit the range.

    Object Model
    CellRange ClassDataValidation ClassCell ClassStyle ClassWorksheet ClassCell ClassCell ClassStyle Class
    Syntax
    'Declaration
 

    Public Class CellRange 
   Inherits Xceed.Workbooks.NET.StyledRange(Of Cell)
   Implements Xceed.Workbooks.NET.IRangeBase(Of Cell) 
    'Usage
 

    Dim instance As CellRange
    public class CellRange : Xceed.Workbooks.NET.StyledRange<Cell>, Xceed.Workbooks.NET.IRangeBase<Cell>
    Remarks
    This class derives from StyledRange.
    Example
    using( var doc = Workbook.Load( "test.xlsx") )
  {
    var worksheet = doc.Worksheets[ 0 ];        
    var firstTableCellRange = worksheet.Tables[ 0 ].CellRange;

    var cellRangeStartCell = firstTableCellRange.StartingElement;
    var cellRangeEndCell = firstTableCellRange.EndingElement;
  }
    Inheritance Hierarchy

    System.Object
       Xceed.Workbooks.NET.WorkbookElement
          Xceed.Workbooks.NET.WorksheetElement
             Xceed.Workbooks.NET.StyledWorksheetElement
                Xceed.Workbooks.NET.StyledRange<T>
                   Xceed.Workbooks.NET.CellRange

    Public Properties
     NameDescription
    Public PropertyCountOverridden. Gets the number of Cells within the CellRange.  
    Public PropertyDataValidationGets or sets the CellRange's DataValidation.  
    Public PropertyElementsGets the items in the range. (Inherited from Xceed.Workbooks.NET.StyledRange<Cell>)
    Public PropertyEndingElementGets or sets the last item in the range. (Inherited from Xceed.Workbooks.NET.StyledRange<Cell>)
    Public PropertyStartingElementGets or sets the first item in the range. (Inherited from Xceed.Workbooks.NET.StyledRange<Cell>)
    Public PropertyStyleGets the Style used by the Worksheet element. (Inherited from Xceed.Workbooks.NET.StyledWorksheetElement)
    Top
    Public Methods
     NameDescription
    Public MethodAddConditionalFormattingAdds ConditionalFormatting to the CellRange.  
    Public MethodClearOverridden. Clears specific elements in the CellRange.  
    Public MethodClearConditionalFormattingsRemoves all ConditionalFormattings from the CellRange.  
    Public MethodCopyAndPasteToOverloaded. Copies a CellRange & pastes it to another location.  
    Public MethodCutAndPasteToOverloaded. Cuts a CellRange & pastes it to another location.   
    Public MethodEquals  
    Public MethodGetConditionalFormattingsGets the CellRange's ConditionalFormattings.  
    Public MethodGetHashCode  
    Public MethodGetValidationResultsGets a list of Cells that have failed the DataValidation process.  
    Public MethodGetWorksheetReturns the Worksheet associated with the CellRange.  
    Public MethodMergeCellsAdds the CellRange in the MergedCellCollection.  
    Public MethodRemoveConditionalFormatting  
    Public MethodReplaceContentOverridden. Searches into the content of the CellRange and replaces all occurences of a specific value with a new value.  
    Public MethodReplaceContents<TSearch,TNew>Overridden. Searches into the content of the CellRange and replaces all instances of the SearchValues with their corresponding NewValues.  
    Public MethodToStringReturns the addresses of the StartingElement and EndingElement in the following format: ( "SE : EE " ).  
    Public MethodUnmergeCellsRemoves all the element in the CellRange from the MergedCellCollection.  
    Top
    Protected Methods
     NameDescription
    Protected Internal MethodGetElementsOverridden.   
    Protected Internal MethodGetNewStyle (Inherited from Xceed.Workbooks.NET.StyledWorksheetElement)
    Protected Internal MethodGetWorksheetElementOverridden.   
    Protected Internal MethodIsBoundElement (Inherited from Xceed.Workbooks.NET.StyledRange<Cell>)
    Protected Internal MethodIsElementInRangeOverridden.   
    Protected Internal MethodIsEndingBoundElementOverridden.   
    Protected Internal MethodIsStartingBoundElementOverridden.   
    Protected MethodOnPropertyChanged  
    Protected Internal MethodReadStyle (Inherited from Xceed.Workbooks.NET.StyledWorksheetElement)
    Protected Internal MethodReset (Inherited from Xceed.Workbooks.NET.StyledWorksheetElement)
    Protected Internal MethodSetElementsOverridden.   
    Protected Internal MethodUpdateChildrenStylePropertyOverridden.   
    Protected Internal MethodUpdateStyleBorders (Inherited from Xceed.Workbooks.NET.StyledWorksheetElement)
    Protected Internal MethodWriteStyle (Inherited from Xceed.Workbooks.NET.StyledWorksheetElement)
    Top
    Supported Frameworks

    .NET: net5.0, net5.0-windows, net6.0, net6.0-macos, net6.0-windows, net7.0, net7.0-macos, net7.0-windows, net8.0, net8.0-browser, net8.0-macos, net8.0-windows, net9.0, net9.0-browser, net9.0-macos, net9.0-windows, net10.0, net10.0-browser, net10.0-macos, net10.0-windows.

    .NET Framework: net40, net403, net45, net451, net452, net46, net461, net462, net463, net47, net471, net472, net48, net481.

    See Also

    Reference

    CellRange Members
    Xceed.Workbooks.NET Namespace

    Send Feedback