Spread Windows Forms 15.0
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet Namespace / Tables Class / Query Method
An integer value indicates the top row index.
An integer value indicates the left column index.
An integer value indicates the bottom row index.
An integer value indicates the right column index.
if set to true, all tables will returns; otherwise, returns only table which belong to the cell range completely.


In This Topic
    Query Method
    In This Topic
    Queries all tables which belong to the specified cell range.
    Syntax
    'Declaration
     
    
    Public Function Query( _
       ByVal row As Integer, _
       ByVal column As Integer, _
       ByVal row2 As Integer, _
       ByVal column2 As Integer, _
       ByVal intersecting As Boolean _
    ) As Table()
    'Usage
     
    
    Dim instance As Tables
    Dim row As Integer
    Dim column As Integer
    Dim row2 As Integer
    Dim column2 As Integer
    Dim intersecting As Boolean
    Dim value() As Table
     
    value = instance.Query(row, column, row2, column2, intersecting)

    Parameters

    row
    An integer value indicates the top row index.
    column
    An integer value indicates the left column index.
    row2
    An integer value indicates the bottom row index.
    column2
    An integer value indicates the right column index.
    intersecting
    if set to true, all tables will returns; otherwise, returns only table which belong to the cell range completely.

    Return Value

    A Table[] array represents all tables which belong to the specified cell range.
    See Also