Spread WPF Documentation
SetValue Method (Column)
Example 


GrapeCity.Windows.SpreadSheet.Data Namespace > Column Class : SetValue Method
The row index.
The value for the cell.
Sets the value in a specified row in the current column.
Syntax
'Declaration
 
Public Sub SetValue( _
   ByVal row As System.Integer, _
   ByVal value As System.Object _
) 
'Usage
 
Dim instance As Column
Dim row As System.Integer
Dim value As System.Object
 
instance.SetValue(row, value)
public void SetValue( 
   System.int row,
   System.object value
)

Parameters

row
The row index.
value
The value for the cell.
Example
This example uses the SetValue 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