Xceed Workbooks for .NET v3.0 Documentation
Xceed.Workbooks.NET Assembly / Xceed.Workbooks.NET Namespace / CategoryData Class / FromCells Method / FromCells(Worksheet,String,String) Method

The Worksheet containing the range of Cell addresses.

Note that this Worksheet must exist.

The address of the first Cell in the CellRange.

This must be a valid Cell address.

The address of the last Cell in the CellRange.

This must be a valied Cell address.

Example


In This Topic
    FromCells(Worksheet,String,String) Method
    In This Topic
    Creates a CategoryData from a range identified by the Adresses of various Cells.
    Syntax
    'Declaration
     
    
    Public Overloads Shared Function FromCells( _
       ByVal worksheet As Worksheet, _
       ByVal startCellAddress As String, _
       ByVal endCellAddress As String _
    ) As CategoryData
    'Usage
     
    
    Dim worksheet As Worksheet
    Dim startCellAddress As String
    Dim endCellAddress As String
    Dim value As CategoryData
     
    value = CategoryData.FromCells(worksheet, startCellAddress, endCellAddress)

    Parameters

    worksheet

    The Worksheet containing the range of Cell addresses.

    Note that this Worksheet must exist.

    startCellAddress

    The address of the first Cell in the CellRange.

    This must be a valid Cell address.

    endCellAddress

    The address of the last Cell in the CellRange.

    This must be a valied Cell address.

    Return Value

    CategoryData that will be used as a Chart.CategoryData.
    Remarks
    The Addresses given must correspond to a single Cell, a single Column or a single Row.
    Example
    lineChart.CategoryData = CategoryData.FromCells( worksheet, "B4", 'B8' );
    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