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

In This Topic
    GetTables Method
    In This Topic
    Gets the sheet tables.
    Public Function GetTables() As SheetTable()
    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.
    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);
    Public Class lname
            Public Property last() As String
                    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
                    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)
    See Also