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' );
    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