SetText Method (Column)

Visual Basic
C#

'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.

This example uses the SetText method.

C#
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 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

Target Platforms: Windows Server 2012, Windows RT

Reference

Column Class
Column Members