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


In This Topic
    WorksheetRange Class
    In This Topic
    Represents a group of continuous Worksheets in a WorksheetCollection. 
    Object Model
    WorksheetRange ClassWorksheet ClassWorksheet ClassThemeColor Class
    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
    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

    WorksheetRange Members
    Xceed.Workbooks.NET Namespace

    Send Feedback