Spread Silverlight Documentation
GrapeCity.Windows.SpreadSheet.Data Namespace / Column Class / SetText Method
The row index.
The text string for the cell.
Example


In This Topic
    SetText Method (Column)
    In This Topic
    Sets the text in a specified row in the current column.
    Syntax
    'Declaration
     
    Public Sub SetText( _
       ByVal row As Integer, _
       ByVal text As String _
    ) 
    'Usage
     
    Dim instance As Column
    Dim row As Integer
    Dim text As String
     
    instance.SetText(row, text)
    public void SetText( 
       int row,
       string text
    )

    Parameters

    row
    The row index.
    text
    The text string for the cell.
    Example
    This example uses the SetText 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