Spread Silverlight Documentation
GrapeCity.Windows.SpreadSheet.Data Namespace / Column Class / GetText Method
The row index.
Example


In This Topic
    GetText Method (Column)
    In This Topic
    Gets the text in a specified row in the current column.
    Syntax
    'Declaration
     
    Public Function GetText( _
       ByVal row As Integer _
    ) As String
    'Usage
     
    Dim instance As Column
    Dim row As Integer
    Dim value As String
     
    value = instance.GetText(row)
    public string GetText( 
       int row
    )

    Parameters

    row
    The row index.

    Return Value

    Returns the cell's text.
    Example
    This example uses the GetText method.
    GcSpreadSheet1.ActiveSheet.Columns[0].SetText(1, "test");
    GcSpreadSheet1.ActiveSheet.Columns[0].SetValue(2, 5);
    GcSpreadSheet1.ActiveSheet.Rows[3].SetText(1, "C");
    GcSpreadSheet1.ActiveSheet.Rows[3].SetValue(3, 10);
    
    private void button1_Click(object sender, RoutedEventArgs e)
    {
            ListBox1.Items.Add(GcSpreadSheet1.ActiveSheet.Columns[0].GetText(1).ToString());
            ListBox1.Items.Add(GcSpreadSheet1.ActiveSheet.Columns[0].GetValue(2).ToString());
            ListBox1.Items.Add(GcSpreadSheet1.ActiveSheet.Rows[3].GetValue(1).ToString());
            ListBox1.Items.Add(GcSpreadSheet1.ActiveSheet.Rows[3].GetText(3).ToString());
     }
    GcSpreadSheet1.ActiveSheet.Columns(0).SetText(1, "test")
    GcSpreadSheet1.ActiveSheet.Columns(0).SetValue(2, 5)
    GcSpreadSheet1.ActiveSheet.Rows(3).SetText(1, "C")
    GcSpreadSheet1.ActiveSheet.Rows(3).SetValue(3, 10)
    
        Private Sub Button1_Click(sender As System.Object, e As System.Windows.RoutedEventArgs) Handles Button1.Click
            ListBox1.Items.Add(GcSpreadSheet1.ActiveSheet.Columns(0).GetText(1).ToString())
            ListBox1.Items.Add(GcSpreadSheet1.ActiveSheet.Columns(0).GetValue(2).ToString())
            ListBox1.Items.Add(GcSpreadSheet1.ActiveSheet.Rows(3).GetValue(1).ToString())
            ListBox1.Items.Add(GcSpreadSheet1.ActiveSheet.Rows(3).GetText(3).ToString())
        End Sub
    See Also