GetValue Method (Column)

Visual Basic
C#

'Declaration
 
Public Function GetValue( _
   ByVal row As System.Integer _
) As System.Object

'Usage
 
Dim instance As Column
Dim row As System.Integer
Dim value As System.Object
 
value = instance.GetValue(row)

public System.object GetValue( 
   System.int row
)

Parameters

row: The row index.

Return Value

Returns the cell's value.

This example uses the GetValue method.

C#

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());
 }

VB.NET

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

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

Column Class
Column Members