CellValue.TextValue Property

Returns a string contained in a cell.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v23.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

public string TextValue { get; }

VB.NET

Public ReadOnly Property TextValue As String

Property Value

Type	Description
String	A String value specifying the text value of a cell.

Remarks

Use the TextValue property to obtain the text value contained in a cell. To check whether the cell value is of the text type, use the CellValue.IsText or CellValue.Type property. If a cell value type is other than text, the TextValue property returns null (Nothing in VB). To get a string that specifies a cell value of any type as it is displayed in the cell, use the Cell.DisplayText property.

For more information on cell values, refer to the Cell Data Types document.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the TextValue property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

winforms-spreadsheet-use-custom-cell-editors/CS/DevAVInvoicing/Form1.cs#L141

// to display stores owned by the customer with the specified ID.
string customerId = invoice["B11"].Value.TextValue;
Table storesTable = customerStores.Tables[0];

wpf-spreadsheet-bind-a-worksheet-to-generic-list-or-bindinglist-data-source/CS/DataBindingToListExample/MyConverter.cs#L15

Weather w;
if (Enum.TryParse(value.TextValue, out w)) return w;
return Weather.Undefined;

how-to-bind-a-worksheet-to-a-generic-list-or-a-bindinglist-data-source/CS/DataBindingToListExample/MyConverter.cs#L15

Weather w;
if (Enum.TryParse(value.TextValue, out w)) return w;
return Weather.Undefined;

wpf-spreadsheet-bind-spreadsheet-to-ms-sql-server-database/CS/WpfSpreadsheet_BindToDataSource/MainWindow.xaml.cs#L74

dataSet.Suppliers.AddSuppliersRow(
    sheet["C4"].Value.TextValue, sheet["C6"].Value.TextValue, sheet["C8"].Value.TextValue,
    sheet["E4"].Value.TextValue, sheet["E6"].Value.TextValue, sheet["E8"].Value.TextValue,

winforms-spreadsheet-bind-to-ms-sql-server-database/CS/SuppliersExample/Form1.cs#L61

dataSet.Suppliers.AddSuppliersRow(
    sheet["C4"].Value.TextValue, sheet["C6"].Value.TextValue, sheet["C8"].Value.TextValue,
    sheet["E4"].Value.TextValue, sheet["E6"].Value.TextValue, sheet["E8"].Value.TextValue,

VB.NET

winforms-spreadsheet-use-custom-cell-editors/VB/DevAVInvoicing/Form1.vb#L129

' to display stores owned by the customer with the specified ID.
Dim customerId As String = invoice("B11").Value.TextValue
Dim storesTable As Table = customerStores.Tables(0)

wpf-spreadsheet-bind-a-worksheet-to-generic-list-or-bindinglist-data-source/VB/DataBindingToListExample/MyConverter.vb#L18

Dim w As Weather = Nothing
If System.Enum.TryParse(value.TextValue, w) Then
    Return w

how-to-bind-a-worksheet-to-a-generic-list-or-a-bindinglist-data-source/VB/DataBindingToListExample/MyConverter.vb#L18

Dim w As Weather = Nothing
If System.Enum.TryParse(value.TextValue, w) Then
    Return w

spreadsheet-document-api-use-worksheet-table-as-data-source/VB/SpreadsheetDocumentServerAsDataSourceExample/MyPictureProvider.vb#L22

Dim pic As Bitmap = Nothing
If pictures.TryGetValue(value.TextValue, pic) Then
    Return pic

wpf-spreadsheet-bind-spreadsheet-to-ms-sql-server-database/VB/WpfSpreadsheet_BindToDataSource/MainWindow.xaml.vb#L67

    ' Append a new row to the "Suppliers" data table.
    dataSet.Suppliers.AddSuppliersRow(sheet("C4").Value.TextValue, sheet("C6").Value.TextValue, sheet("C8").Value.TextValue, sheet("E4").Value.TextValue, sheet("E6").Value.TextValue, sheet("E8").Value.TextValue, sheet.Cells("G4").DisplayText, sheet.Cells("G6").DisplayText)
Catch ex As Exception