GrapeCity.Xaml.SpreadSheet.Data
GetValue Method (Column)
Example 


GrapeCity.Xaml.SpreadSheet.Data Namespace > Column Class : GetValue Method
The row index.
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

Reference

Column Class
Column Members