SetText(Int32,Int32,String) Method

Sets the formatted text in the cell in the specified sheet area using the IFormatter object for the cell.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Sub SetText( _
   ByVal row As System.Integer, _
   ByVal column As System.Integer, _
   ByVal value As System.String _
)

'Usage
 
Dim instance As Worksheet
Dim row As System.Integer
Dim column As System.Integer
Dim value As System.String
 
instance.SetText(row, column, value)

public void SetText( 
   System.int row,
   System.int column,
   System.string value
)

Parameters

row: The row index.
column: The column index.
value: The text for the specified cell.

Exceptions

Exception	Description
System.ArgumentOutOfRangeException	Specified row index is out of range; must be between 0 and the total number of rows.
System.ArgumentOutOfRangeException	Specified column index is out of range; must be between 0 and the total number of columns.

Example

This example uses the SetText method.

gcSpreadSheet1.Sheets[0].SetTag(0, 0, "test");
//gcSpreadSheet1.Sheets[0].SetTag(0, 0, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells, "test");
gcSpreadSheet1.Sheets[0].SetText(1, 1, "testing");
//gcSpreadSheet1.Sheets[0].SetText(1, 1, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells, "Testing");
gcSpreadSheet1.Sheets[0].SetValue(2, 2, "ABC");
//gcSpreadSheet1.Sheets[0].SetValue(2, 2, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells, "ABC");
//gcSpreadSheet1.Sheets[0].SetValue(2, 2, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells, "ABC", true);

VB.NET

GcSpreadSheet1.Sheets(0).SetTag(0, 0, "test")
'GcSpreadSheet1.Sheets(0).SetTag(0, 0, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells, "test")
GcSpreadSheet1.Sheets(0).SetText(1, 1, "testing")
'GcSpreadSheet1.Sheets(0).SetText(1, 1, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells, "Testing")
GcSpreadSheet1.Sheets(0).SetValue(2, 2, "ABC")
'GcSpreadSheet1.Sheets(0).SetValue(2, 2, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells, "ABC")
'GcSpreadSheet1.Sheets(0).SetValue(2, 2, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells, "ABC", True)

Requirements

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

Worksheet Class
Worksheet Members
Overload List