Spread WinRT Documentation
GrapeCity.Xaml.SpreadSheet.Data Namespace / Worksheet Class / GetTables Method
Example


In This Topic
    GetTables Method
    In This Topic
    Gets the sheet tables.
    Syntax
    'Declaration
     
    Public Function GetTables() As SheetTable()
    'Usage
     
    Dim instance As Worksheet
    Dim value() As SheetTable
     
    value = instance.GetTables()
    public SheetTable[] GetTables()

    Return Value

    The array of table instances. The array is never null.
    Example
    This example uses the GetTables method.
    public class lname
            {
                public string last { get; set; }
                public int val { get; set; }
                public lname(string last, int val)
                {
                    this.last = last;
                    this.val = val;
                }
            }
    
    lname[] arr = new lname[] { new lname("Smith", 100), new lname("Fender", 3), new lname("Gill", 5) };
    gcSpreadSheet1.Sheets[0].AddTable("Table1", 0, 0, arr);
    listBox1.Items.Add(gcSpreadSheet1.Sheets[0].GetTables().Length.ToString());
    Public Class lname
            Public Property last() As String
                Get
                    Return m_last
                End Get
                Set(value As String)
                    m_last = Value
                End Set
            End Property
            Private m_last As String
            Public Property val() As Integer
                Get
                    Return m_val
                End Get
                Set(value As Integer)
                    m_val = Value
                End Set
            End Property
            Private m_val As Integer
            Public Sub New(last As String, val As Integer)
                Me.last = last
                Me.val = val
            End Sub
        End Class
    
    Dim arr As lname() = New lname() {New lname("Smith", 100), New lname("Fender", 3), New lname("Gill", 5)}
    GcSpreadSheet1.Sheets(0).AddTable("Table1", 0, 0, arr)
    ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).GetTables().Length.ToString())
    See Also