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


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

    Parameters

    row
    The row index.

    Return Value

    Returns the cell's value.
    Example
    This example uses the GetValue 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