Xceed Logo
Shop
Xceed Workbooks for .NET v3.0 Documentation
Xceed.Workbooks.NET Assembly / Xceed.Workbooks.NET Namespace / WorksheetRange Class
Members


In This Topic
    WorksheetRange Class
    In This Topic
    Represents a group of continuous Worksheets in a WorksheetCollection. 
    Syntax
    'Declaration
 

    Public Class WorksheetRange 
   Inherits Xceed.Workbooks.NET.RangeBase(Of Worksheet)
   Implements Xceed.Workbooks.NET.IRangeBase(Of Worksheet) 
    'Usage
 

    Dim instance As WorksheetRange
    public class WorksheetRange : Xceed.Workbooks.NET.RangeBase<Worksheet>, Xceed.Workbooks.NET.IRangeBase<Worksheet>
    Remarks
    This class derives from RangeBase.
    Inheritance Hierarchy

    System.Object
       Xceed.Workbooks.NET.RangeBase<T>
          Xceed.Workbooks.NET.WorksheetRange

    Public Properties
     NameDescription
    Public PropertyCountOverridden. Gets the number of Worksheets in the WorksheetRange.  
    Public PropertyElementsGets the items in the range. (Inherited from Xceed.Workbooks.NET.RangeBase<Worksheet>)
    Public PropertyEndingElementGets or sets the last item in the range. (Inherited from Xceed.Workbooks.NET.RangeBase<Worksheet>)
    Public PropertyStartingElementGets or sets the first item in the range. (Inherited from Xceed.Workbooks.NET.RangeBase<Worksheet>)
    Public PropertyTabColorGets or sets the TabColor of all the Worksheets in the WorksheetRange.  
    Public PropertyTabThemeColorGets or sets the TabThemeColor of all the Worksheets in the WorksheetRange.  
    Public PropertyVisibilityGets or sets the Visibility of all the Worksheets in the WorksheetRange.  
    Top
    Public Methods
     NameDescription
    Public MethodCalculateFormulasTriggers CalculateFormulas for all of the Worksheets in the WorksheetRange.  
    Public MethodClearOverridden. Clears specific elements in the WorksheetRange.  
    Public MethodReplaceContentOverridden. Searches into the content of the range and replaces all occurences of a specific value with a new value.  
    Public MethodReplaceContents<TSearch,TNew>Overridden. Searches into the content of the WorksheetRange and replaces all instances of the SearchValues with their corresponding NewValues.  
    Public MethodToString  
    Top
    Protected Methods
     NameDescription
    Protected Internal MethodGetElementsOverridden.   
    Protected Internal MethodSetElementsOverridden.   
    Top
    Requirements

    Target Platforms: Windows 11, Windows 10, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

    See Also

    Reference

    WorksheetRange Members
    Xceed.Workbooks.NET Namespace

    Send Feedback