Xceed Workbooks for .NET v3.0 Documentation
Xceed.Workbooks.NET Assembly / Xceed.Workbooks.NET Namespace / ColumnCollection Class / Item Property / Item(String,String) Property
The address of the Column that starts the ColumnRange.
The address of the Column that ends the ColumnRange.
Example


In This Topic
    Item(String,String) Property
    In This Topic
    Gets a ColumnRange identified by two addresses.
    Syntax
    'Declaration
     
    
    Public Overloads ReadOnly Property Item( _
       ByVal startColumnId As String, _
       ByVal endColumnId As String _
    ) As ColumnRange
    'Usage
     
    
    Dim instance As ColumnCollection
    Dim startColumnId As String
    Dim endColumnId As String
    Dim value As ColumnRange
     
    value = instance.Item(startColumnId, endColumnId)

    Parameters

    startColumnId
    The address of the Column that starts the ColumnRange.
    endColumnId
    The address of the Column that ends the ColumnRange.
    Remarks
    The first Column is located at “A”. 
    Example
    // Gets a range from Column B to Column D.
    var columnRange = worksheet.Columns["B", "D"];
    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