Gets the formatted text in the cell in the specified sheet area using the
IFormatter object for the cell.
'Declaration
Public Overloads Function GetText( _
ByVal As System.Integer, _
ByVal column As System.Integer, _
ByVal As SheetArea _
) As System.String
'Usage
Dim instance As Worksheet
Dim row As System.Integer
Dim column As System.Integer
Dim sheetArea As SheetArea
Dim value As System.String
value = instance.GetText(row, column, sheetArea)
public System.string GetText(
System.int ,
System.int column,
SheetArea
)
Parameters
- row
- The row index.
- column
- The column index.
- sheetArea
- The sheet area.
Return Value
Returns the formatted text of the cell.
This example uses the GetText method.
gcSpreadSheet1.Sheets[0].Cells[0, 0].Text = "Testing";
listBox1.Items.Add(gcSpreadSheet1.Sheets[0].GetText(0, 0).ToString());
listBox1.Items.Add(gcSpreadSheet1.Sheets[0].GetText(0, 0, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells).ToString());
gcSpreadSheet1.Sheets[0].Cells[1, 1].Value = 3;
listBox1.Items.Add(gcSpreadSheet1.Sheets[0].GetValue(1, 1).ToString());
listBox1.Items.Add(gcSpreadSheet1.Sheets[0].GetValue(1, 1, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells).ToString());
GcSpreadSheet1.Sheets(0).Cells(0, 0).Text = "Testing"
ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).GetText(0, 0).ToString())
ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).GetText(0, 0, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells).ToString())
GcSpreadSheet1.Sheets(0).Cells(1, 1).Value = 3
ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).GetValue(1, 1).ToString())
ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).GetValue(1, 1, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells).ToString())
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