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


In This Topic
    ColumnRange Class
    In This Topic
    Defines a ColumnRange, which is a range of consecutives Columns.
    Object Model
    ColumnRange ClassColumn ClassStyle ClassColumn ClassColumn ClassStyle Class
    Syntax
    'Declaration
 

    Public Class ColumnRange 
   Inherits Xceed.Workbooks.NET.LinearRange(Of Column)
   Implements Xceed.Workbooks.NET.IRangeBase(Of Column) 
    'Usage
 

    Dim instance As ColumnRange
    public class ColumnRange : Xceed.Workbooks.NET.LinearRange<Column>, Xceed.Workbooks.NET.IRangeBase<Column>
    Remarks
    This class derives from LinearRange.
    Example
    using( var workbook = Workbook.Create( "ColumnRange.xlsx" ) ) 
  { 
    // Gets the first Worksheet; a Workbook always contains at least 1 Worksheet. 
    var worksheet = workbook.Worksheets[ 0 ]; 

    // Gets the Columns B, C and D. 
    var columnRange = worksheet.Columns[ "B", "D" ]; 

    // Sets the columnRange's Background color to yellow. 
    columnRange.Style.Fill.BackgroundColor = Color.Yellow; 
 
    // Saves Workbook to disk; 
    workbook.Save(); 
  }
    Inheritance Hierarchy

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

    Public Properties
     NameDescription
    Public PropertyCountGets the number of columns in the ColumnRange. (Inherited from Xceed.Workbooks.NET.LinearRange<Column>)
    Public PropertyElementsGets the items in the range. (Inherited from Xceed.Workbooks.NET.StyledRange<T>)
    Public PropertyEndingElementGets or sets the last item in the range. (Inherited from Xceed.Workbooks.NET.StyledRange<T>)
    Public PropertyIsHiddenGets or sets if the Rows in the RowRange or the Columns in the ColumnRange are hidden are not.   (Inherited from Xceed.Workbooks.NET.LinearRange<Column>)
    Public PropertyStartingElementGets or sets the first item in the range. (Inherited from Xceed.Workbooks.NET.StyledRange<T>)
    Public PropertyStyleGets the Style used by the Worksheet element. (Inherited from Xceed.Workbooks.NET.StyledWorksheetElement)
    Public PropertyWidthGets or sets the Width of all Columns in the range.  
    Top
    Public Methods
     NameDescription
    Public MethodAutoFitOverridden. Adjusts the Columns’ Width based on the Cell with the widest content in the ColumnRange.  
    Public MethodClearRemoves specific elements from the LinearRange. (Inherited from Xceed.Workbooks.NET.LinearRange<Column>)
    Public MethodEquals (Inherited from Xceed.Workbooks.NET.LinearRange<Column>)
    Public MethodGetHashCode (Inherited from Xceed.Workbooks.NET.LinearRange<Column>)
    Public MethodReplaceContentSearches into the content of the LinearRange and replaces all occurences of a specific value with a new value. (Inherited from Xceed.Workbooks.NET.LinearRange<Column>)
    Public MethodReplaceContents<TSearch,TNew>Searches into the content of the LinearRange and replaces all instances of the searchValues with their corresponding newValues. (Inherited from Xceed.Workbooks.NET.LinearRange<Column>)
    Public MethodToString (Inherited from Xceed.Workbooks.NET.LinearRange<Column>)
    Top
    Protected Methods
     NameDescription
    Protected Internal MethodCompareWorksheetElement (Inherited from Xceed.Workbooks.NET.LinearRange<Column>)
    Protected Internal MethodGetElements (Inherited from Xceed.Workbooks.NET.LinearRange<Column>)
    Protected Internal MethodGetNewStyle (Inherited from Xceed.Workbooks.NET.StyledWorksheetElement)
    Protected Internal MethodGetWorksheetElementOverloaded. Overridden.   
    Protected Internal MethodIsBoundElement (Inherited from Xceed.Workbooks.NET.StyledRange<T>)
    Protected Internal MethodIsElementInRange (Inherited from Xceed.Workbooks.NET.LinearRange<Column>)
    Protected Internal MethodIsEndingBoundElement (Inherited from Xceed.Workbooks.NET.LinearRange<Column>)
    Protected Internal MethodIsStartingBoundElement (Inherited from Xceed.Workbooks.NET.LinearRange<Column>)
    Protected Internal MethodReadStyle (Inherited from Xceed.Workbooks.NET.StyledWorksheetElement)
    Protected Internal MethodReset (Inherited from Xceed.Workbooks.NET.StyledWorksheetElement)
    Protected Internal MethodSetElements (Inherited from Xceed.Workbooks.NET.LinearRange<Column>)
    Protected Internal MethodUpdateChildrenBorderStylePropertyOverridden.   
    Protected Internal MethodUpdateChildrenStyleProperty (Inherited from Xceed.Workbooks.NET.LinearRange<Column>)
    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

    ColumnRange Members
    Xceed.Workbooks.NET Namespace

    Send Feedback